Question 1

The specification is used to avoid having duplicated values in a column.

Accepted Answer

The answer of The specification is used to avoid having...

Question 2

To list all the contents of the PRODUCT table, a user 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 3

If integer values are relatively small, must be used instead of INT.

Accepted Answer

The answer of If integer values are relatively small, must...

Question 4

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

Question 5

Which command is used to save changes to the database? What is the syntax for this command?

Accepted Answer

Any changes made to the table contents a

Question 6

A(n) is a query that is embedded (or nested) inside another query.

Accepted Answer

A)  alias 
B)  operator 
C)  subquery 
D)  view 
A)  alias 
B)  operator 
C)  subquery 
D)  view

Question 7

Which of the following queries uses the correct SQL syntax to list the table contents for either V_CODE = 21344 or V_CODE = 24288?

Accepted Answer

A)  SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE  24288; 
C)  SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE > 24288; 
D)  SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE = 24288; 
A)  SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE  24288; 
C)  SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE > 24288; 
D)  SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE = 24288;

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

DATE() and SYSDATE are special functions that return today's date in MS Access and , respectively.

Accepted Answer

The answer of DATE() and SYSDATE are special functions that...

Question 10

A(n) character is a symbol that can be used as a general substitute for other characters or commands.

Accepted Answer

The answer of A(n) character is a symbol that can...

Question 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

Most SQL implementations yield case-insensitive searches.

Accepted Answer

A) True 
 B)False

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

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

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Which of the following queries 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 command, coupled with appropriate search conditions, is an incredibly powerful tool that enables a user to transform data into information.

Accepted Answer

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

Question 20

According to the rules of precedence, which of the following computations should be completed first?

Accepted Answer

A)  Performing additions and subtractions 
B)  Performing multiplications and divisions 
C)  Performing operations within parentheses 
D)  Performing power operations 
A)  Performing additions and subtractions 
B)  Performing multiplications and divisions 
C)  Performing operations within parentheses 
D)  Performing power operations

The specification is used to avoid having duplicated values in a column.

To list all the contents of the PRODUCT table, a user would use .

If integer values are relatively small, must be used instead of INT.

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

Which command is used to save changes to the database? What is the syntax for this command?

A(n) is a query that is embedded (or nested) inside another query.

Which of the following queries uses the correct SQL syntax to list the table contents for either V_CODE = 21344 or V_CODE = 24288?

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

DATE() and SYSDATE are special functions that return today's date in MS Access and , respectively.

A(n) character is a symbol that can be used as a general substitute for other characters or commands.

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

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

Most SQL implementations yield case-insensitive searches.

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

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

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

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

Which of the following queries 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 command, coupled with appropriate search conditions, is an incredibly powerful tool that enables a user to transform data into information.

According to the rules of precedence, which of the following computations should be completed first?

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

The specification is used to avoid having duplicated values in a column.

To list all the contents of the PRODUCT table, a user would use .

If integer values are relatively small, must be used instead of INT.

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

Which command is used to save changes to the database? What is the syntax for this command?

A(n) is a query that is embedded (or nested) inside another query.

Which of the following queries uses the correct SQL syntax to list the table contents for either V_CODE = 21344 or V_CODE = 24288?

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

DATE() and SYSDATE are special functions that return today's date in MS Access and , respectively.

A(n) character is a symbol that can be used as a general substitute for other characters or commands.

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

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

Most SQL implementations yield case-insensitive searches.

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

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

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

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

Which of the following queries 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 command, coupled with appropriate search conditions, is an incredibly powerful tool that enables a user to transform data into information.

According to the rules of precedence, which of the following computations should be completed first?

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