Question 1

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 2

The ____________________ clause of the GROUP BY statement operates very much like the WHERE clause in the SELECT statement.

Accepted Answer

The answer of The ____________________ clause of the GROUP BY...

Question 3

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 4

____________________ words are words used by SQL to perform specific functions.

Accepted Answer

The answer of ____________________ words are words used by SQL...

Question 5

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 6

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 7

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

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

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 10

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 11

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

Accepted Answer

A) True 
 B)False

Question 12

What are the wildcard characters that are used with the LIKE command? Provide one or more examples of each.

Accepted Answer

% means any and all following or precedi

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

The answer of A table can be deleted from the...

Question 15

A common practice is to create a(n)____________________ on any field that is used as a search key,in comparison operations in a conditional expression,or when you want to list rows in a specific order.

Accepted Answer

The answer of A common practice is to create a(n)____________________...

Question 16

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 17

Most SQL implementations yield case-insensitive searches.

Accepted Answer

A) True 
 B)False

Question 18

Which query 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 19

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

Accepted Answer

A) True 
 B)False

Question 20

Which query will output the table contents when the value of V_CODE is not 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;

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

The ____________________ clause of the GROUP BY statement operates very much like the WHERE clause in the SELECT statement.

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

____________________ words are words used by SQL to perform specific functions.

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

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

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

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

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.

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 COMMIT command does not permanently save all changes.In order to do that,you must use SAVE.

What are the wildcard characters that are used with the LIKE command? Provide one or more examples of each.

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

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

A common practice is to create a(n)____________________ on any field that is used as a search key,in comparison operations in a conditional expression,or when you want to list rows in a specific order.

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

Most SQL implementations yield case-insensitive searches.

Which query 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?

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

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

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)

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

The ____________________ clause of the GROUP BY statement operates very much like the WHERE clause in the SELECT statement.

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

____________________ words are words used by SQL to perform specific functions.

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

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

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

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

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.

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 COMMIT command does not permanently save all changes.In order to do that,you must use SAVE.

What are the wildcard characters that are used with the LIKE command? Provide one or more examples of each.

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

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

A common practice is to create a(n)____________________ on any field that is used as a search key,in comparison operations in a conditional expression,or when you want to list rows in a specific order.

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

Most SQL implementations yield case-insensitive searches.

Which query 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?

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

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

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