Accounting
Anthropology
Archaeology
Art History
Banking
Biology & Life Science
Business
Business Communication
Business Development
Business Ethics
Business Law
Chemistry
Communication
Computer Science
Counseling
Criminal Law
Curriculum & Instruction
Design
Earth Science
Economic
Education
Engineering
Finance
History & Theory
Humanities
Human Resource
International Business
Investments & Securities
Journalism
Law
Management
Marketing
Medicine
Medicine & Health Science
Nursing
Philosophy
Physic
Psychology
Real Estate
Science
Social Science
Sociology
Special Education
Speech
Visual Arts
Humanities
Q:
If you add a new column to a table that already has rows, the existing rows will default to a value of ____________________ for the new column.
Q:
A specialty field in mathematics, known as ____________________ algebra, is dedicated to the use of logical operators.
Q:
In SQL, all ____________________ expressions evaluate to true or false.
Q:
The ____________________ command, coupled with appropriate search conditions, is an incredibly powerful tool that enables you to transform data into information.
Q:
A(n) ____________________, also known as a nested query or an inner query, is a query that is embedded (or nested) inside another query.
Q:
A(n) ____________________ character is a symbol that can be used as a general substitute for other characters or commands.
Q:
In an INSERT command, you can indicate just the attributes that have required values by listing the ____________________ inside parentheses after the table name.
Q:
To delete an index, use the ____________________command.
Q:
A common practice is to create a(n) ____________________ on any field that is used as a search key, in comparison operations in a conditional expression, or when you want to list rows in a specific order.
Q:
Using the ____________________ command, SQL indexes can be created on the basis of any selected attribute.
Q:
____________________ words are words used by SQL to perform specific functions.
Q:
In a 1:M relationship, you must alwayscreate the table for the ____________________ side first.
Q:
If your integer values are relatively small, use ____________________ instead of INT.
Q:
DATE() and SYSDATE are special functions that return today's date in MS Access and ____________________, respectively.
Q:
U.S. state abbreviations are always two characters, so ____________________(2) is a logical choice for the data type representing a state column.
Q:
With the exception of the database ____________________ process, most RDBMS vendors use SQL that deviates little from the ANSI standard SQL.
Q:
A(n) ____________________ is a logical group of database objects, such as tables and indexes, that are related to each other.
Q:
The basic SQL vocabulary has fewer than ____________________ words.
Q:
In the SQL environment, the word ____________________covers both questions and actions.
Q:
The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE and V_CONTACT fields from the VENDOR table, where the values of V_CODE match and the output is ordered by the price is ____.a. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <> VENDOR.V_CODE; ORDER BY P_PRICE;b. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE => VENDOR.V_CODE; ORDER BY P_PRICE;c. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <= VENDOR.V_CODE; ORDER BY P_PRICE;d. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE; ORDER BY P_PRICE;
Q:
The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE, and V_CONTACT fields from the VENDOR table where the values of V_CODE match is ____.
a. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <> VENDOR.V_CODE;
b. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;
c. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <= VENDOR.V_CODE;
d. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE => VENDOR.V_CODE;
Q:
The SQL aggregate function that gives the average for the specific column is ____.a. COUNT b. AVG c. MAXd. SUM
Q:
The SQL aggregate function that gives the total of all values for a selected attribute in a given column is ____.a. COUNT b. MIN c. MAXd. SUM
Q:
The SQL aggregate function that gives the number of rows containing non-null values for the given column is ____.a. COUNT b. MIN c. MAXd. SUM
Q:
Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another?
a. SELECT ONLY V_CODE FROM PRODUCT;
b. SELECT UNIQUE V_CODE FROM PRODUCT;
c. SELECT DIFFERENT V_CODE FROM PRODUCT;
d. SELECT DISTINCT V_CODE FROM PRODUCT;
Q:
The SQL query to output the contents of the EMPLOYEE table sorted by last name, first name, and initial is ____.
a. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE LIST BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
b. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE ORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
c. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE DISPLAY BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
d. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE SEQUENCE BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
Q:
The query used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from the PRODUCT table in ascending order by P_PRICE is ____.
a. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT SEQUENCE BY P_PRICE;
b. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT LIST BY P_PRICE;
c. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ORDER BY P_PRICE;
d. SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ASCENDING BY P_PRICE;
Q:
A table can be deleted from the database by using the ____ command.a. DROP TABLE b. DELETE TABLE c. MODIFY TABLEd. ERASE TABLE
Q:
The ____ command is used with the ALTER TABLE command to modify the table by deleting a column.a. DROP b. REMOVE c. DELETEd. ERASE
Q:
The special operator used to check whether a subquery returns any rows is ____.a. BETWEEN b. EXISTS c. LIKEd. IN
Q:
The special operator used to check for similar character strings is ____.a. BETWEEN b. IS NULL c. LIKEd. IN
Q:
The ____ special operator is used to check whether an attribute value is null.a. BETWEEN b. IS NULL c. LIKEd. IN
Q:
The special operator used to check whether an attribute value is within a range of values is ____.a. BETWEEN b. NULL c. LIKEd. IN
Q:
Which query uses the correct SQL syntax to list the table contents for either V_CODE = 21344 or V_CODE = 24288?
a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE <= 24288
b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE => 24288
c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE > 24288
d. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE = 24288
Q:
Which query will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand and display the results in a column labeled TOTVALUE?
a. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE AS TOTVALUE FROM PRODUCT;
b. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH=P_PRICE AS TOTVALUE FROM PRODUCT;
c. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH/P_PRICE AS TOTVALUE FROM PRODUCT;
d. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH-P_PRICE AS TOTVALUE FROM PRODUCT;
Q:
A(n) ____ is an alternate name given to a column or table in any SQL statement.a. alias b. data type c. stored functiond. trigger
Q:
Which query will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand?
a. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH/P_PRICE FROM PRODUCT;
b. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH=P_PRICE FROM PRODUCT;
c. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE FROM PRODUCT;
d. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH-P_PRICE FROM PRODUCT;
Q:
Which query will list all the rows in which the inventory stock dates occur on or after January 20, 2010?
a. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDATE >= '20-JAN-2010'
b. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDATE >= $20-JAN-2010$
c. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDATE <= '20-JAN-2010'
d. SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDATE >= {20-JAN-2010}
Q:
Which query will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?
a. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE <'1558-QW1';
b. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE = [1558-QW1]
c. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE = (1558-QW1)
d. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE = {1558-QW1}
Q:
Which query will output the table contents when the value of P_PRICE is less than or equal to 10?
a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE P_PRICE <> 10;
b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE P_PRICE <= 10;
c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE P_PRICE => 10;
d. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE P_PRICE = 10;
Q:
Which query will output the table contents when the value of V_CODE is not equal to 21344?
a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <> 21344;
b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <= 21344;
c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344;
d. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE => 21344;
Q:
Which query will output the table contents when the value of V_CODE is equal to 21344?
a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <> 21344;
b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <= 21344;
c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344;
d. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE => 21344;
Q:
A(n) ____ is a query that is embedded (or nested) inside another query.a. alias b. operator c. subqueryd. view
Q:
The ____ command would be used to delete the table row where the P_CODE is 'BRT-345'.
a. DELETE FROM PRODUCT WHERE P_CODE = 'BRT-345';
b. REMOVE FROM PRODUCT WHERE P_CODE = 'BRT-345';
c. ERASE FROM PRODUCT WHERE P_CODE = 'BRT-345';
d. ROLLBACK FROM PRODUCT WHERE P_CODE = 'BRT-345';
Q:
Which of the following is used to select partial table contents?
a. SELECT <column(s)> FROM <Table name> BY <Conditions>;
b. LIST <column(s)> FROM <Table name> BY <Conditions>;
c. SELECT <column(s)> FROM <Table name> WHERE <Conditions>;
d. LIST<column(s)> FROM <Table name> WHERE <Conditions>;
Q:
When you issue the DELETE FROM tablename command without specifying a WHERE condition, ____.a. no rows will be deleted b. the first row will be deleted c. the last row will be deletedd. all rows will be deleted
Q:
To delete a row from the PRODUCT table, use the ____ command.a. COMMIT b. DELETE c. ERASEd. KILL
Q:
Some RDBMSs, such as Oracle, automatically ____ data changes when issuing data definition commands.a. COMMIT b. ROLLBACK c. UNSAVEd. UPDATE
Q:
The ____ command is used to restore the table's contents to their previous values.a. COMMIT; RESTORE; b. COMMIT; BACKUP; c. COMMIT; ROLLBACK;d. ROLLBACK;
Q:
An example of a command you would use when making changes to a PRODUCT table is ____.
a. CHANGE PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
b. ROLLBACK PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
c. EDIT PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
d. UPDATE PRODUCT SET P_INDATE = '18-JAN-2004' WHERE P_CODE = '13-Q2/P2';
Q:
UPDATE tablename*****[WHERE conditionlist];The ____ command replaces the ***** in the syntax of the UPDATE command, shown above.a. SET columnname = expression b. columnname = expression c. expression = columnnamed. LET columnname = expression
Q:
The SQL command that modifies an attribute"s values in one or more table"s rows is ____.a. INSERT b. SELECT c. COMMITd. UPDATE
Q:
In Oracle, the ____ command is used to change the display for a column, for example, to place a $ in front of a numeric value.a. DISPLAY b. FORMAT c. CHARd. CONVERT
Q:
To list all the contents of the PRODUCT table, you would use ____.a. LIST * FROM PRODUCT; b. SELECT * FROM PRODUCT; c. DISPLAY * FROM PRODUCT;d. SELECT ALL FROM PRODUCT;
Q:
The SQL command that lets you select attributes from rows in one or more tables is ____.a. INSERT b. SELECT c. COMMITd. UPDATE
Q:
The SQL command that lets you permanently save data changes is ____.a. INSERT b. SELECT c. COMMITd. UPDATE
Q:
The SQL command that lets you insert rows into a table is ____.a. INSERT b. SELECT c. COMMITd. UPDATE
Q:
The SQL character data format(s) is(are) ____.a. CHAR and VARCHAR b. VARCHAR only c. Alphanumericd. CHAR only
Q:
The most recent fully approved version of standard SQL prescribed by the ANSI is ____.a. SQL-99 b. SQL-2003 c. SQL-4d. SQL-07
Q:
When joining three or more tables, you need to specify a join condition for one pair of tables.
Q:
To join tables, simply enumerate the tables in the FROM clause of the SELECT statement. The DBMS will create a Cartesian product of every table in the FROM clause. To get the correct results, you need to select the rows in which the common attribute values do not match.
Q:
The COUNT function is designed to tally the number of non-null "values" of an attribute, and is often used in conjunction with the DISTINCT clause.
Q:
Some RDBMSs, such as Microsoft Access, automatically make the necessary conversions to eliminate case sensitivity.
Q:
Most SQL implementations yield case-insensitive searches.
Q:
The conditional LIKE must be used in conjunction with wildcard characters.
Q:
ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause.
Q:
SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.
Q:
Date procedures are often more software-specific than other SQL procedures.
Q:
String comparisons are made from left to right.
Q:
Since computers identify all characters by their numeric codes, mathematical operators cannot be used to place restrictions on character-based attributes.
Q:
Oracle users can use the Access QBE (query by example) query generator.
Q:
You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output.
Q:
Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command's components.
Q:
All SQL commands must be issued on a single line.
Q:
If you have not yet used the COMMIT command to store the changes permanently in the database, you can restore the database to its previous condition with the ROLLBACK command.
Q:
The COMMIT command does not permanently save all changes. In order to do that, you must use SAVE.
Q:
Any changes made to the contents of a table are not physically saved on disk until you use the SAVE <table name> command.
Q:
To list the contents of a table, you must use the DISPLAY command.
Q:
You cannot insert a row containing a null attribute value using SQL.
Q:
SQL requires the use of the ADD command to enter data into a table.