Question 1

The SQL character data format(s)  is(are)  ____.

Accepted Answer

A)   CHAR and VARCHAR
B)   VARCHAR only
C)   Alphanumeric
D)   CHAR only

Question 2

SQL requires the use of the ADD command to enter data into a table.

Accepted Answer

A) True 
 B)False

Question 3

A(n) ____________________ is performed when data is retrieved from more than one table at a time.

Accepted Answer

The answer of A(n) ____________________ is performed when data is...

Question 4

Oracle users can use the Access QBE (query by example) query generator.

Accepted Answer

A) True 
 B)False

Question 5

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?

Accepted Answer

A)   SELECT ONLY V_CODEFROM PRODUCT;
B)   SELECT UNIQUE V_CODEFROM PRODUCT;
C)   SELECT DIFFERENT V_CODEFROM PRODUCT;
D)   SELECT DISTINCT V_CODEFROM PRODUCT;

Question 6

Which query will output the table contents when the value of P_PRICE is less than or equal to 10?

Accepted Answer

A)   SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE P_PRICE  10;
B)   SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE P_PRICE 
C)   SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE P_PRICE => 10;
D)   SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE P_PRICE = 10;

Question 7

The ____ command would be used to delete the table row where the P_CODE is 'BRT-345'.

Accepted Answer

A)   DELETE FROM PRODUCTWHERE P_CODE = 'BRT-345';
B)   REMOVE FROM PRODUCTWHERE P_CODE = 'BRT-345';
C)   ERASE FROM PRODUCTWHERE P_CODE = 'BRT-345';
D)   ROLLBACK FROM PRODUCTWHERE P_CODE = 'BRT-345';

Question 8

The special operator used to check for similar character strings is ____.

Accepted Answer

A)   BETWEEN
B)   IS NULL
C)   LIKE
D)   IN

Question 9

An example of a command you would use when making changes to a PRODUCT table is ____.

Accepted Answer

A)   CHANGE PRODUCTSET P_INDATE = '18-JAN-2004'WHERE P_CODE = '13-Q2/P2';
B)   ROLLBACK PRODUCTSET P_INDATE = '18-JAN-2004'WHERE P_CODE = '13-Q2/P2';
C)   EDIT PRODUCTSET P_INDATE = '18-JAN-2004'WHERE P_CODE = '13-Q2/P2';
D)   UPDATE PRODUCTSET P_INDATE = '18-JAN-2004'WHERE P_CODE = '13-Q2/P2';

Question 10

The SQL command that lets you select attributes from rows in one or more tables is ____.

Accepted Answer

A)   INSERT
B)   SELECT
C)   COMMIT
D)   UPDATE

Question 11

What is a subquery? When is it used? Does the RDBMS deal with subqueries any differently from normal queries?

Accepted Answer

A subquery, also known as a nested query...

Question 12

The SQL query to output the contents of the EMPLOYEE table sorted by last name, first name, and initial is ____.

Accepted Answer

A)   SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONEFROM EMPLOYEELIST BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
B)   SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONEFROM EMPLOYEEORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
C)   SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONEFROM EMPLOYEEDISPLAY BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
D)   SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONEFROM EMPLOYEESEQUENCE BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;

Question 13

Which query will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand?

Accepted Answer

A)   SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH/P_PRICEFROM PRODUCT;
B)   SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH=P_PRICEFROM PRODUCT;
C)   SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICEFROM PRODUCT;
D)   SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH-P_PRICEFROM PRODUCT;

Question 14

The ____ command is used to restore the table's contents to their previous values.

Accepted Answer

A)   COMMIT; RESTORE;
B)   COMMIT; BACKUP;
C)   COMMIT; ROLLBACK;
D)   ROLLBACK;

Question 15

When you issue the DELETE FROM tablename command without specifying a WHERE condition, ____.

Accepted Answer

A)   no rows will be deleted
B)   the first row will be deleted
C)   the last row will be deleted
D)   all rows will be deleted

Question 16

In Oracle, the ____ command is used to change the display for a column, for example, to place a $ in front of a numeric value.

Accepted Answer

A)   DISPLAY
B)   FORMAT
C)   CHAR
D)   CONVERT

Question 17

Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command sequence.

Accepted Answer

A) True 
 B)False

Question 18

A table can be deleted from the database by using the ____ command.

Accepted Answer

A)   DROP TABLE
B)   DELETE TABLE
C)   MODIFY TABLE
D)   ERASE TABLE

Question 19

The SQL aggregate function that gives the average for the specific column is ____.

Accepted Answer

A)   COUNT
B)   AVG
C)   MAX
D)   SUM

Question 20

Any changes made to the contents of a table are not physically saved on disk until you use the SAVE <table name> command.

Accepted Answer

A) True 
 B)False

Exam 5: Beginning Structured Query Language Sql

A(n) ____________________ is performed when data is retrieved from more than one table at a time.

Correct AnswerverifiedShow Answer

The special operator used to check for similar character strings is ____.

Correct AnswerverifiedShow Answer

Any changes made to the contents of a table are not physically saved on disk until you use the SAVE <table name> command.

Correct AnswerverifiedShow Answer

Which query will output the table contents when the value of P_PRICE is less than or equal to 10?

Correct AnswerverifiedShow Answer

The SQL aggregate function that gives the average for the specific column is ____.

Correct AnswerverifiedShow Answer

What is a subquery? When is it used? Does the RDBMS deal with subqueries any differently from normal queries?

Correct AnswerverifiedA subquery, also known as a nested query...View AnswerShow Answer

Oracle users can use the Access QBE (query by example) query generator.

Correct AnswerverifiedShow Answer

An example of a command you would use when making changes to a PRODUCT table is ____.

Correct AnswerverifiedShow Answer

The SQL command that lets you select attributes from rows in one or more tables is ____.

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

The ____ command is used to restore the table's contents to their previous values.

Correct AnswerverifiedShow Answer

The SQL character data format(s) is(are) ____.

Correct AnswerverifiedShow Answer

Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command sequence.

Correct AnswerverifiedShow Answer

The ____ command would be used to delete the table row where the P_CODE is 'BRT-345'.

Correct AnswerverifiedShow Answer

In Oracle, the ____ command is used to change the display for a column, for example, to place a $ in front of a numeric value.

Correct AnswerverifiedShow Answer

When you issue the DELETE FROM tablename command without specifying a WHERE condition, ____.

Correct AnswerverifiedShow Answer

SQL requires the use of the ADD command to enter data into a table.

Correct AnswerverifiedShow Answer

A table can be deleted from the database by using the ____ command.

Correct AnswerverifiedShow Answer

Which query will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand?

Correct AnswerverifiedShow Answer

The SQL query to output the contents of the EMPLOYEE table sorted by last name, first name, and initial is ____.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A subquery, also known as a nested query...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified