Question 1

SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words.

Accepted Answer

A) True 
 B)False

Question 2

If a user adds a new column to a table that already has rows, the existing rows will default to a value of for the new column.

Accepted Answer

The answer of If a user adds a new column...

Question 3

All changes in a table structure are made using the command, followed by a keyword that produces the specific changes a user wants to make.

Accepted Answer

A)  ALTER TABLE 
B)  UPDATE TABLE 
C)  COMMIT TABLE 
D)  ROLLBACK TABLE 
A)  ALTER TABLE 
B)  UPDATE TABLE 
C)  COMMIT TABLE 
D)  ROLLBACK TABLE

Question 4

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

Accepted Answer

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

Question 5

An alias cannot be used when a table is required to be joined to itself in a recursive query.

Accepted Answer

A) True 
 B)False

Question 6

In SQL, all expressions evaluate to True or false.

Accepted Answer

The answer of In SQL, all expressions evaluate to True...

Question 7

Using the command, SQL indexes can be created on the basis of any selected attribute.

Accepted Answer

The answer of Using the command, SQL indexes can be...

Question 8

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 9

In an INSERT command, a user can indicate just the attributes that have required values by listing the inside parentheses after the table name.

Accepted Answer

attribute

Question 10

The SQL data type DATE stores date in the date format.

Accepted Answer

The answer of The SQL data type DATE stores date...

Question 11

With the exception of the database process, most RDBMS vendors use SQL that deviates little from the ANSI standard SQL.

Accepted Answer

The answer of With the exception of the database process,...

Question 12

To delete an index, one must use the command.

Accepted Answer

The answer of To delete an index, one must use...

Question 13

Explain the two SQL functions.

Accepted Answer

1. SQL is a data definition language (DD

Question 14

ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following queries 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?

Accepted Answer

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

Question 16

Which of the following queries 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 17

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 .

Accepted Answer

A) SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME, VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE; B) SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME, VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE => VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE; C) SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME, VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <= VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE; D) SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME, VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE; A) SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME, VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE; B) SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME, VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE => VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE; C) SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME, VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <= VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE; D) SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_PRICE, VENDOR.V_NAME, VENDOR.V_CONTACT, VENDOR.V_AREACODE, VENDOR.V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;

Question 18

The data format for SQL character is .

Accepted Answer

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

Question 19

The SQL aggregate function that gives the total of all values for a selected attribute in a given column is? .

Accepted Answer

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

Question 20

The command is used to restore the database to its previous condition.

Accepted Answer

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

SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words.

If a user adds a new column to a table that already has rows, the existing rows will default to a value of for the new column.

All changes in a table structure are made using the command, followed by a keyword that produces the specific changes a user wants to make.

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

An alias cannot be used when a table is required to be joined to itself in a recursive query.

In SQL, all expressions evaluate to True or false.

Using the command, SQL indexes can be created on the basis of any selected attribute.

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

In an INSERT command, a user can indicate just the attributes that have required values by listing the inside parentheses after the table name.

The SQL data type DATE stores date in the date format.

With the exception of the database process, most RDBMS vendors use SQL that deviates little from the ANSI standard SQL.

To delete an index, one must use the command.

Explain the two SQL functions.

ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause.

Which of the following queries 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?

Which of the following queries will output the table contents when the value of P_PRICE is less than or equal to 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 and the output is ordered by the price is .

The data format for SQL character is .

The SQL aggregate function that gives the total of all values for a selected attribute in a given column is? .

The command is used to restore the database to its previous condition.

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

SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words.

If a user adds a new column to a table that already has rows, the existing rows will default to a value of for the new column.

All changes in a table structure are made using the command, followed by a keyword that produces the specific changes a user wants to make.

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

An alias cannot be used when a table is required to be joined to itself in a recursive query.

In SQL, all expressions evaluate to True or false.

Using the command, SQL indexes can be created on the basis of any selected attribute.

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

In an INSERT command, a user can indicate just the attributes that have required values by listing the inside parentheses after the table name.

The SQL data type DATE stores date in the date format.

With the exception of the database process, most RDBMS vendors use SQL that deviates little from the ANSI standard SQL.

To delete an index, one must use the command.

Explain the two SQL functions.

ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause.

Which of the following queries 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?

Which of the following queries will output the table contents when the value of P_PRICE is less than or equal to 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 and the output is ordered by the price is .

The data format for SQL character is .

The SQL aggregate function that gives the total of all values for a selected attribute in a given column is? .

The command is used to restore the database to its previous condition.

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