Question 1

The special operator used to check whether a subquery returns any rows is .

Accepted Answer

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

Question 2

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 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 6

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 7

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 8

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?

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 9

The SQL command that allows a user to list the contents of a table is .

Accepted Answer

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

Question 10

In SQL,all expressions evaluate to true or false.

Accepted Answer

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

Question 11

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

Question 12

The condition is generally composed of an equality comparison between the foreign key and the primary key of related tables.

Accepted Answer

The answer of The condition is generally composed of an...

Question 13

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 14

UPDATE tablename *****
[WHERE conditionlist];
The command replaces the ***** in the syntax of the UPDATE command,shown above.

Accepted Answer

A) SET columnname = expression 
B) columnname = expression 
C) expression = columnname 
D) LET columnname = expression 
A) SET columnname = expression 
B) columnname = expression 
C) expression = columnname 
D) LET columnname = expression

Question 15

Data type selection is usually dictated by the nature of the data and by the intended use.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

___ __.is the process the DBMS uses to verify that only registered users access the database.

Accepted Answer

The answer of ___ __.is the process the DBMS uses...

Question 18

Which of the following queries will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?

Accepted Answer

A) SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICE FROM PRODUCT WHERE P_CODE <'1558-QW1'; 
B) SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICE FROM PRODUCT WHERE P_CODE = [1558-QW1]; 
C) SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICE FROM PRODUCT WHERE P_CODE = (1558-QW1); 
D) SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICE FROM PRODUCT WHERE P_CODE = {1558-QW1}; 
A) SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICE FROM PRODUCT WHERE P_CODE <'1558-QW1'; 
B) SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICE FROM PRODUCT WHERE P_CODE = [1558-QW1]; 
C) SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICE FROM PRODUCT WHERE P_CODE = (1558-QW1); 
D) SELECT P_CODE,P_DESCRIPT,P_QOH,P_MIN,P_PRICE FROM PRODUCT WHERE P_CODE = {1558-QW1};

Question 19

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 20

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

The special operator used to check whether a subquery returns any rows is .

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

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

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

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

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

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

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?

The SQL command that allows a user to list the contents of a table is .

In SQL,all expressions evaluate to true or false.

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

The condition is generally composed of an equality comparison between the foreign key and the primary key of related 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.

UPDATE tablename * [WHERE conditionlist]; The command replaces the * in the syntax of the UPDATE command,shown above.

Data type selection is usually dictated by the nature of the data and by the intended use.

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

_ .is the process the DBMS uses to verify that only registered users access the database.

Which of the following queries will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?

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.

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

Database Systems

Data Models

The Relational Database Model

Entity Relationship Ermodeling

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

Big Data Analytics and NoSQL

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 7: Introduction to Structured Query Language SQL

The special operator used to check whether a subquery returns any rows is .

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

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

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

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

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

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

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?

The SQL command that allows a user to list the contents of a table is .

In SQL,all expressions evaluate to true or false.

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

The condition is generally composed of an equality comparison between the foreign key and the primary key of related 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.

UPDATE tablename ***** [WHERE conditionlist]; The command replaces the ***** in the syntax of the UPDATE command,shown above.

Data type selection is usually dictated by the nature of the data and by the intended use.

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

___ __.is the process the DBMS uses to verify that only registered users access the database.

Which of the following queries will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?

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.

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

Database Systems

Data Models

The Relational Database Model

Entity Relationship Ermodeling

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

Big Data Analytics and NoSQL

Database Connectivity and Web Technologies

Database Administration and Security

Filters

UPDATE tablename * [WHERE conditionlist]; The command replaces the * in the syntax of the UPDATE command,shown above.

_ .is the process the DBMS uses to verify that only registered users access the database.