Question 1

In the SQL environment,the word ____________________ covers both questions and actions.

Accepted Answer

The answer of In the SQL environment,the word ____________________ covers...

Question 2

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 3

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 4

Some RDBMSs,such as Oracle,automatically ____ data changes when issuing data definition commands.

Accepted Answer

A)  COMMIT 
B)  ROLLBACK 
C)  UNSAVE 
D)  UPDATE 
A)  COMMIT 
B)  ROLLBACK 
C)  UNSAVE 
D)  UPDATE

Question 5

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 6

A specialty field in mathematics,known as ____________________ algebra,is dedicated to the use of logical devices.

Accepted Answer

The answer of A specialty field in mathematics,known as ____________________...

Question 7

The COUNT function 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 8

To delete a row from the PRODUCT table,use the ____ command.

Accepted Answer

A)  COMMIT 
B)  DELETE 
C)  ERASE 
D)  KILL 
A)  COMMIT 
B)  DELETE 
C)  ERASE 
D)  KILL

Question 9

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 10

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 11

A database language enables the user to perform complex queries designed to transform the raw data into useful information.

Accepted Answer

A) True 
 B)False

Question 12

The special operator used to check whether an attribute value is within a range of values is ____.

Accepted Answer

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

Question 13

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 14

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 15

The SQL aggregate function that gives the number of rows containing non-null values for the given column is ____.

Accepted Answer

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

Question 16

A(n)____________________,also known as a nested query or an inner query,is a query that is embedded (or nested)inside another query.

Accepted Answer

The answer of A(n)____________________,also known as a nested query or...

Question 17

A(n)____________________ is a group of database objects,such as tables and indexes,that are related to each other.

Accepted Answer

The answer of A(n)____________________ is a group of database objects,such...

Question 18

To list all the contents of the PRODUCT table,you would use ____.

Accepted Answer

A)  LIST * FROM PRODUCT; 
B)  SELECT * FROM PRODUCT; 
C)  DISPLAY * FROM PRODUCT; 
D)  SELECT ALL FROM PRODUCT; 
A)  LIST * FROM PRODUCT; 
B)  SELECT * FROM PRODUCT; 
C)  DISPLAY * FROM PRODUCT; 
D)  SELECT ALL FROM PRODUCT;

Question 19

The SQL command that lets you insert rows into a table is ____.

Accepted Answer

A)  INSERT 
B)  SELECT 
C)  COMMIT 
D)  UPDATE 
A)  INSERT 
B)  SELECT 
C)  COMMIT 
D)  UPDATE

Question 20

The most recent fully approved version of standard SQL prescribed by the ANSI is ____.

Accepted Answer

A)  SQL-99 
B)  SQL-2003 
C)  SQL-4 
D)  SQL-07 
A)  SQL-99 
B)  SQL-2003 
C)  SQL-4 
D)  SQL-07

In the SQL environment,the word ____________________ covers both questions and actions.

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

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

Some RDBMSs,such as Oracle,automatically ____ data changes when issuing data definition commands.

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

A specialty field in mathematics,known as ____________________ algebra,is dedicated to the use of logical devices.

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

To delete a row from the PRODUCT table,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.

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 database language enables the user to perform complex queries designed to transform the raw data into useful information.

The special operator used to check whether an attribute value is within a range of values is ____.

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

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

The SQL aggregate function that gives the number of rows containing non-null values for the given column is ____.

A(n)____________________,also known as a nested query or an inner query,is a query that is embedded (or nested)inside another query.

A(n)____________________ is a group of database objects,such as tables and indexes,that are related to each other.

To list all the contents of the PRODUCT table,you would use ____.

The SQL command that lets you insert rows into a table is ____.

The most recent fully approved version of standard SQL prescribed by the ANSI is ____.

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)

In the SQL environment,the word ____________________ covers both questions and actions.

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

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

Some RDBMSs,such as Oracle,automatically ____ data changes when issuing data definition commands.

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

A specialty field in mathematics,known as ____________________ algebra,is dedicated to the use of logical devices.

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

To delete a row from the PRODUCT table,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.

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 database language enables the user to perform complex queries designed to transform the raw data into useful information.

The special operator used to check whether an attribute value is within a range of values is ____.

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

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

The SQL aggregate function that gives the number of rows containing non-null values for the given column is ____.

A(n)____________________,also known as a nested query or an inner query,is a query that is embedded (or nested)inside another query.

A(n)____________________ is a group of database objects,such as tables and indexes,that are related to each other.

To list all the contents of the PRODUCT table,you would use ____.

The SQL command that lets you insert rows into a table is ____.

The most recent fully approved version of standard SQL prescribed by the ANSI is ____.

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