Question 1

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 2

You cannot insert a row containing a null attribute value using SQL.

Accepted Answer

A) True 
 B)False

Question 3

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 4

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;

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

An alias is especially useful when a table must be joined to itself in a(n)____________________ query.

Accepted Answer

The answer of An alias is especially useful when a...

Question 9

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

Question 10

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

Accepted Answer

The answer of What is a schema? How many schemas...

Question 11

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 12

To list the contents of a table,you must use the DISPLAY command.

Accepted Answer

A) True 
 B)False

Question 13

The ____________________ command,coupled with appropriate search conditions,is an incredibly powerful tool that enables you to transform data into information.

Accepted Answer

The answer of The ____________________ command,coupled with appropriate search conditions,is...

Question 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

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,so ____________________(2)is...

Question 17

In SQL,all ____________________ expressions evaluate to true or false.

Accepted Answer

The answer of In SQL,all ____________________ expressions evaluate to true...

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 and the output is ordered by the price 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;
ORDER BY P_PRICE; 
B)  SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE => VENDOR.V_CODE;
ORDER BY P_PRICE; 
C)  SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE <= VENDOR.V_CODE;
ORDER BY P_PRICE; 
D)  SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE = VENDOR.V_CODE;
ORDER BY P_PRICE;

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

Only numeric data types can be added and subtracted in SQL.

Accepted Answer

A) True 
 B)False

Exam 7: Introduction to Structured Query Language (SQL)

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

You cannot insert a row containing a null attribute value using SQL.

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

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

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

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

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

An alias is especially useful when a table must be joined to itself in a(n)____________________ query.

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

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

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

To list the contents of a table,you must use the DISPLAY command.

The ____________________ command,coupled with appropriate search conditions,is an incredibly powerful tool that enables you to transform data into information.

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

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

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

In SQL,all ____________________ expressions evaluate to true or false.

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

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

Only numeric data types can be added and subtracted in SQL.