Add delete and update records within a table

Assignment Help Basic Computer Science

Reference no: EM13900264

2. (TCO 7) Which of the following is NOT a feature of database management software?
(Points : 2)

Add, delete, and update records within a table.
Write questions that select specific records from a table for viewing.
View data on a PDA.
Create table descriptions.

Question 3. 3. (TCO 7) What SQL clause is used to determine the sequence in which the records are displayed in an SQL Query statement? (Points : 2)

SEQUENCE
ORDER BY
SORT BY
INDEX BY

Question 4. 4. (TCO 7) The _____ in a table is the column that makes each record different from all others.

unique record
primary key
sort key
magic field

Question 5. 5. (TCO 7) In an SQL Query statement, what Boolean operator can be used to test a set of conditions whereby all conditions must be true?

OR
AND
XOR
NOT

Question 6. 6. (TCO 7) The questions that cause the database software to extract the appropriate records from a table and specify the fields to be viewed are called _____.
(Points : 2)

reports
keys
queries
indexes

Question 7. 7. (TCO 7) Which field would be suitable as a primary key in a table that contains employee records?

Area code
Last name
Birth date
An employee number

Question 8. 8. (TCO 7) In an SQL Query statement, what Boolean operator can be used to test a set of conditions whereby any condition being true will and must test true?

OR
AND
XOR
NOT

Question 9. 9. (TCO 7) Which statement concerning primary keys is false?

Primary keys must be unique.
Primary keys may be numbers.
Primary keys may be letters.
A primary key value can repeat in a table.

Question 10.10. (TCO 7) The WSH Object used in a VBScript program to retrieve data from a database is _____.

ADODB.Recordset
ADODB.Open
ADODB.Retrieve
ADODB.Record

Reference no: EM13900264

Questions Cloud

Summary of the human resurce article into one paper : Find any Human Resurce Articles and summary the article into one paper. be carful about the plagiarism. HR Recruitment- http://catalog.flatworldknowledge.com/bookhub/reader/28091?e=portolesedias_1.0-ch04

Powerpoint slides for jive software optional : Powerpoint slides for Jive software. optional (handouts and sources)

What will be the optimal portfolia for agents : How would you model explicitly these two factors' impact on equities A and B? What assumptions will be required to assure general applicability of the standard APT framework to this model?

Identify characteristic of companies with accounts turnover : Categorize each of the preceding companies as to whether its turnover ratio is above or below 15. Based upon (2), identify a characteristic of companies with accounts receivable turnover ratios above 15.

Add delete and update records within a table : Add, delete, and update records within a table. Write questions that select specific records from a table for viewing. View data on a PDA.

Create a class name gasprices : Purpose: Create a class name GasPrices. Its main() method holds an integer variable named pricePerBarrel to which you will assign a value entered by a user at the keyboard. Create a method to which you pass pricePerBarrel. The method displays the ran..

What are some of the key concerns for her staff : What are some ways she can work her own training into her schedule? What are some of the key concerns for her staff, and how might they be addressed

Defines the middle 95% of the distribution of sample means : For random samples of size n = 25 selected from a normal distribution with a mean of m = 50 and a standard deviation of s =20, find each of the following: The range of sample means that defines the middle 95% of the distribution of sample means.

What proportion of the scores have values : A population of scores forms a normal distribution with a mean of m = 80 and a standard deviation of s = 10. What proportion of the scores have values between 75 and 85?

User Account

All Pages