Question 1

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 
A)  DROP TABLE 
B)  DELETE TABLE 
C)  MODIFY TABLE 
D)  ERASE TABLE

Question 2

The SQL command that allows a user to insert rows into a table is .

Accepted Answer

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

Question 3

Mathematical operators cannot be used to place restrictions on character-based attributes.

Accepted Answer

A) True 
 B)False

Question 4

To make the output more readable, the SQL standard permits the use of aliases for any column in a statement.

Accepted Answer

The answer of To make the output more readable, the...

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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.

Accepted Answer

A) True 
 B)False

Question 7

U.S. state abbreviations are always two characters, so (2) is a logical choice for the data type representing a state column.

Accepted Answer

The answer of U.S. state abbreviations are always two characters,...

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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 = expression 
A)  SET columnname = expression 
B)  columnname = expression 
C)  expression = columnname 
D)  LET columnname = expression

Question 10

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.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following queries will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?

Accepted Answer

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}; 
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};

Question 12

String comparisons are made from left to right.

Accepted Answer

A) True 
 B)False

Question 13

Some RDBMSs, such as Microsoft Access, automatically make the necessary conversions to eliminate case sensitivity.

Accepted Answer

A) True 
 B)False

Question 14

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

Question 15

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_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; 
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;

Question 16

To remove a row from the PRODUCT table, one must use the command.

Accepted Answer

A)  COMMIT 
B)  DELETE 
C)  ERASE 
D)  KILL 
A)  COMMIT 
B)  DELETE 
C)  ERASE 
D)  KILL

Question 17

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.

Accepted Answer

A) True 
 B)False

Question 18

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_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; 
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;

Question 19

Which of the following queries 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_CODE FROM PRODUCT WHERE V_CODE  21344; 
B)  SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE  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;

Question 20

The SQL command that allows a user to permanently save data changes is .

Accepted Answer

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

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

The SQL command that allows a user to insert rows into a table is .

Mathematical operators cannot be used to place restrictions on character-based attributes.

To make the output more readable, the SQL standard permits the use of aliases for any column in a statement.

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

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.

U.S. state abbreviations are always two characters, so (2) is a logical choice for the data type representing a state column.

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

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

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.

Which of the following queries will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?

String comparisons are made from left to right.

Some RDBMSs, such as Microsoft Access, automatically make the necessary conversions to eliminate case sensitivity.

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.

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

To remove a row from the PRODUCT table, one must use the command.

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.

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 .

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

The SQL command that allows a user to permanently save data changes is .

Database Systems

Data Models

The Relational Database Model

Entity Relationship Er Modeling

Advanced Data Modeling

Normalization of Database Tables

Advanced Sql

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 7: Introduction to Structured Query Language Sql

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

The SQL command that allows a user to insert rows into a table is .

Mathematical operators cannot be used to place restrictions on character-based attributes.

To make the output more readable, the SQL standard permits the use of aliases for any column in a statement.

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

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.

U.S. state abbreviations are always two characters, so (2) is a logical choice for the data type representing a state column.

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

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

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.

Which of the following queries will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?

String comparisons are made from left to right.

Some RDBMSs, such as Microsoft Access, automatically make the necessary conversions to eliminate case sensitivity.

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.

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

To remove a row from the PRODUCT table, one must use the command.

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.

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 .

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

The SQL command that allows a user to permanently save data changes is .

Database Systems

Data Models

The Relational Database Model

Entity Relationship Er Modeling

Advanced Data Modeling

Normalization of Database Tables

Advanced Sql

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters

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