Question 1

A(n) ____________________ is a logical group of database objects, such as tables and indexes, that are related to each other.

Accepted Answer

schema

Question 2

A specialty field in mathematics, known as ____________________ algebra, is dedicated to the use of logical operators.

Accepted Answer

The answer of A specialty field in mathematics, known as...

Question 3

You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output.

Accepted Answer

A) True 
 B)False

Question 4

SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.

Accepted Answer

A) True 
 B)False

Question 5

A(n) ____________________ character is a symbol that can be used as a general substitute for other characters or commands.

Accepted Answer

The answer of A(n) ____________________ character is a symbol that...

Question 6

Which query will list all the rows in which the inventory stock dates occur on or after January 20, 2010?

Accepted Answer

A)   SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATEFROM PRODUCTWHERE P_INDATE >= '20-JAN-2010'
B)   SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATEFROM PRODUCTWHERE P_INDATE >= $20-JAN-2010$
C)   SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATEFROM PRODUCTWHERE P_INDATE 
D)   SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATEFROM PRODUCTWHERE P_INDATE >= {20-JAN-2010}E) A) and C)
F) A) and D)

Question 7

UPDATE tablename *****
[WHERE conditionlist];
The ____ command replaces the ***** in the syntax of the UPDATE command, shown above.

Accepted Answer

A)   SET columnname = expression
B)   columnname = expression
C)   expression = columnname
D)   LET columnname = expressionE) A) and B)
F) B) and D) A

Question 8

Which query will output the table contents when the value of V_CODE is equal to 21344?

Accepted Answer

A)   SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE V_CODE  21344;
B)   SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE V_CODE 
C)   SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE V_CODE = 21344;
D)   SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODEFROM PRODUCTWHERE V_CODE => 21344;E) None of the above
F) All of the above

Question 9

A(n) ____________________ order sequence is a multilevel ordered sequence that can be created easily by listing several attributes, separated by commas, after the ORDER BY clause.

Accepted Answer

The answer of A(n) ____________________ order sequence is a multilevel...

Question 10

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 ____.

Accepted Answer

A)   SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE  VENDOR.V_CODE;
B)   SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE = VENDOR.V_CODE;
C)   SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE 
D)   SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE => VENDOR.V_CODE;E) A) and B)
F) None of the above

Question 11

____________________ words are words used by SQL to perform specific functions.

Accepted Answer

The answer of ____________________ words are words used by SQL...

Question 12

What is a schema? How many schemas can be used in one database?

Accepted Answer

In the SQL environment, a schema is a lo...

Question 13

DATE() and SYSDATE are special functions that return today's date in MS Access and ____________________, respectively.

Accepted Answer

Oracle

Question 14

Some RDBMSs, such as Oracle, automatically ____ data changes when issuing data definition commands.

Accepted Answer

A)   COMMIT
B)   ROLLBACK
C)   UNSAVE
D)   UPDATEE) A) and B)
F) A) and D)

Question 15

The ANSI prescribes a standard SQL-the current fully approved version is known as SQL-07.

Accepted Answer

A) True 
 B)False

Question 16

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.

Accepted Answer

The answer of A common practice is to create a(n)...

Question 17

A database language enables the user to perform complex queries designed to transform the raw data into useful information.

Accepted Answer

A) True 
 B)False

Question 18

To delete an index, use the ____________________ command.

Accepted Answer

The answer of To delete an index, use the ____________________...

Question 19

The ____ command is used with the ALTER TABLE command to modify the table by deleting a column.

Accepted Answer

A)   DROP
B)   REMOVE
C)   DELETE
D)   ERASEE) A) and B)
F) A) and C)

Question 20

When joining three or more tables, you need to specify a join condition for one pair of tables.

Accepted Answer

A) True 
 B)False

Exam 5: Beginning Structured Query Language Sql

A(n) ____________________ is a logical group of database objects, such as tables and indexes, that are related to each other.

Correct Answerverifiedschema

A specialty field in mathematics, known as ____________________ algebra, is dedicated to the use of logical operators.

Correct AnswerverifiedShow Answer

You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output.

Correct AnswerverifiedShow Answer

SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.

Correct AnswerverifiedShow Answer

A(n) ____________________ character is a symbol that can be used as a general substitute for other characters or commands.

Correct AnswerverifiedShow Answer

Which query will list all the rows in which the inventory stock dates occur on or after January 20, 2010?

Correct AnswerverifiedShow Answer

UPDATE tablename ***** [WHERE conditionlist]; The ____ command replaces the ***** in the syntax of the UPDATE command, shown above.

Correct AnswerverifiedA

Which query will output the table contents when the value of V_CODE is equal to 21344?

Correct AnswerverifiedShow Answer

A(n) ____________________ order sequence is a multilevel ordered sequence that can be created easily by listing several attributes, separated by commas, after the ORDER BY clause.

Correct AnswerverifiedShow Answer

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 ____.

Correct AnswerverifiedShow Answer

____________________ words are words used by SQL to perform specific functions.

Correct AnswerverifiedShow Answer

What is a schema? How many schemas can be used in one database?

Correct AnswerverifiedIn the SQL environment, a schema is a lo...View AnswerShow Answer

DATE() and SYSDATE are special functions that return today's date in MS Access and ____________________, respectively.

Correct AnswerverifiedOracle

Some RDBMSs, such as Oracle, automatically ____ data changes when issuing data definition commands.

Correct AnswerverifiedShow Answer

The ANSI prescribes a standard SQL-the current fully approved version is known as SQL-07.

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

A database language enables the user to perform complex queries designed to transform the raw data into useful information.

Correct AnswerverifiedShow Answer

To delete an index, use the ____________________ command.

Correct AnswerverifiedShow Answer

The ____ command is used with the ALTER TABLE command to modify the table by deleting a column.

Correct AnswerverifiedShow Answer

When joining three or more tables, you need to specify a join condition for one pair of tables.

Correct AnswerverifiedShow Answer

Correct Answer
verified
schema

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

UPDATE tablename * [WHERE conditionlist]; The ____ command replaces the * in the syntax of the UPDATE command, shown above.

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
In the SQL environment, a schema is a lo...
View Answer

Correct Answer
verified
Oracle

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified