Question 1

The conditional LIKE must be used in conjunction with wildcard characters.

Accepted Answer

A) True 
 B)False

Question 2

Most SQL implementations yield case-insensitive searches.

Accepted Answer

A) True 
 B)False

Question 3

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

Question 4

If your integer values are relatively small,use ____________________ instead of INT.

Accepted Answer

The answer of If your integer values are relatively small,use...

Question 5

To delete an index,use the ____________________ command.

Accepted Answer

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

Question 6

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 7

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

Accepted Answer

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

Question 8

A(n)____ is an alternate name given to a column or table in any SQL statement.

Accepted Answer

A)  alias 
B)  data type 
C)  stored function 
D)  trigger 
A)  alias 
B)  data type 
C)  stored function 
D)  trigger

Question 9

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 attributes do not match.

Accepted Answer

A) True 
 B)False

Question 10

COUNT 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 11

Which of the following is used to select partial table contents?

Accepted Answer

A) SELECT FROM BY ; B) LIST FROM

BY ; C) SELECT FROM

WHERE ; D) LIST FROM

WHERE ; A) SELECT FROM

BY ; B) LIST FROM

BY ; C) SELECT FROM

WHERE ; D) LIST FROM

WHERE ;

Question 12

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

Question 13

The basic SQL vocabulary has fewer than ____________________ words.

Accepted Answer

100
one hu

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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; 
A)  COMMIT; RESTORE; 
B)  COMMIT; BACKUP; 
C)  COMMIT; ROLLBACK; 
D)  ROLLBACK;

Question 16

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

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_CODE
FROM PRODUCT
WHERE P_PRICE  10; 
B)  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; 
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; 
D)  SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODE
FROM PRODUCT
WHERE P_PRICE = 10;

Question 18

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 
A)  INSERT 
B)  SELECT 
C)  COMMIT 
D)  UPDATE

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

Question 20

The COMMIT command does not permanently save all changes.In order to do that,you must use SAVE.

Accepted Answer

A) True 
 B)False

The conditional LIKE must be used in conjunction with wildcard characters.

Most SQL implementations yield case-insensitive searches.

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

If your integer values are relatively small,use ____________________ instead of INT.

To delete an index,use the ____________________ command.

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

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

A(n)____ is an alternate name given to a column or table in any SQL statement.

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 attributes do not match.

COUNT is designed to tally the number of non-null "values" of an attribute,and is often used in conjunction with the DISTINCT clause.

Which of the following is used to select partial table contents?

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

The basic SQL vocabulary has fewer than ____________________ words.

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

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

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

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

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

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

The COMMIT command does not permanently save all changes.In order to do that,you must use SAVE.

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)

The conditional LIKE must be used in conjunction with wildcard characters.

Most SQL implementations yield case-insensitive searches.

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

If your integer values are relatively small,use ____________________ instead of INT.

To delete an index,use the ____________________ command.

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

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

A(n)____ is an alternate name given to a column or table in any SQL statement.

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 attributes do not match.

COUNT is designed to tally the number of non-null "values" of an attribute,and is often used in conjunction with the DISTINCT clause.

Which of the following is used to select partial table contents?

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

The basic SQL vocabulary has fewer than ____________________ words.

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

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

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

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

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

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

The COMMIT command does not permanently save all changes.In order to do that,you must use SAVE.

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