Question 1

The SQL aggregate function that gives the average for the specific column is ____.

Accepted Answer

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

Question 2

An example of a command you 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 3

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 4

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 5

In Oracle, the ____ command is used to change the display for a column, for example, to place a $ in front of a numeric value.

Accepted Answer

A)  DISPLAY 
B)  FORMAT 
C)  CHAR 
D)  CONVERT 
A)  DISPLAY 
B)  FORMAT 
C)  CHAR 
D)  CONVERT

Question 6

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 7

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

A(n) ____________________ is performed when data is retrieved from more than one table at a time.

Accepted Answer

The answer of A(n) ____________________ is performed when data is...

Question 9

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 10

SQL requires the use of the ADD command to enter data into a table.

Accepted Answer

A) True 
 B)False

Question 11

What is a subquery? When is it used? Does the RDBMS deal with subqueries any differently from normal queries?

Accepted Answer

A subquery, also known as a nested query

Question 12

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 13

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 14

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

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

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 18

Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another?

Accepted Answer

A)  SELECT ONLY V_CODE
FROM PRODUCT; 
B)  SELECT UNIQUE V_CODE
FROM PRODUCT; 
C)  SELECT DIFFERENT V_CODE
FROM PRODUCT; 
D)  SELECT DISTINCT V_CODE
FROM PRODUCT; 
A)  SELECT ONLY V_CODE
FROM PRODUCT; 
B)  SELECT UNIQUE V_CODE
FROM PRODUCT; 
C)  SELECT DIFFERENT V_CODE
FROM PRODUCT; 
D)  SELECT DISTINCT V_CODE
FROM PRODUCT;

Question 19

The special operator used to check for similar character strings is ____.

Accepted Answer

A)  BETWEEN 
B)  IS NULL 
C)  LIKE 
D)  IN 
A)  BETWEEN 
B)  IS NULL 
C)  LIKE 
D)  IN

Question 20

Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command sequence.

Accepted Answer

A) True 
 B)False

The SQL aggregate function that gives the average for the specific column is ____.

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

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

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

In Oracle, the ____ command is used to change the display for a column, for example, to place a $ in front of a numeric value.

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

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

A(n) ____________________ is performed when data is retrieved from more than one table at a time.

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

SQL requires the use of the ADD command to enter data into a table.

What is a subquery? When is it used? Does the RDBMS deal with subqueries any differently from normal queries?

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

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

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

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

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

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

Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another?

The special operator used to check for similar character strings is ____.

Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command sequence.

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters

Exam 5: Beginning Structured Query Language Sql

The SQL aggregate function that gives the average for the specific column is ____.

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

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

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

In Oracle, the ____ command is used to change the display for a column, for example, to place a $ in front of a numeric value.

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

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

A(n) ____________________ is performed when data is retrieved from more than one table at a time.

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

SQL requires the use of the ADD command to enter data into a table.

What is a subquery? When is it used? Does the RDBMS deal with subqueries any differently from normal queries?

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

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

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

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

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

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

Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another?

The special operator used to check for similar character strings is ____.

Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command sequence.

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters