Question 1

Rows can be grouped into smaller collections quickly and easily using the clause within the SELECT statement.

Accepted Answer

The answer of Rows can be grouped into smaller collections...

Question 2

Most SQL implementations yield case-insensitive searches.

Accepted Answer

A) True 
 B)False

Question 3

The CHECK constraint is used to define a condition for the values that the attribute domain cannot have.

Accepted Answer

A) True 
 B)False

Question 4

All changes in a table structure are made using the command,followed by a keyword that produces the specific changes a user wants to make.

Accepted Answer

A) ALTER TABLE 
B) UPDATE TABLE 
C) COOMIT TABLE 
D) ROLLBACK TABLE 
A) ALTER TABLE 
B) UPDATE TABLE 
C) COOMIT TABLE 
D) ROLLBACK TABLE

Question 5

What is a schema? How many schemas can be used in one database?

Accepted Answer

In the SQL environment,a schema is a log

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

With the exception of the database process,most RDBMS vendors use SQL that deviates little from the ANSI standard SQL.

Accepted Answer

The answer of With the exception of the database process,most...

Question 9

The SQL command that allows a user to permanently save data changes is .

Accepted Answer

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

Question 10

If you have not yet used the COMMIT command to store the changes permanently in the database,you can restore the database to its previous condition with the ROLLBACK command.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

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

Question 12

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

Question 13

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

Accepted Answer

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

Question 14

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 15

The SQL data manipulation command HAVING:

Accepted Answer

A) restricts the selection of rows based on a conditional expression. 
B) restricts the selection of grouped rows based on a condition. 
C) modifies an attribute's values in one or more table's rows. 
D) groups the selected rows based on one or more attributes. 
A) restricts the selection of rows based on a conditional expression. 
B) restricts the selection of grouped rows based on a condition. 
C) modifies an attribute's values in one or more table's rows. 
D) groups the selected rows based on one or more attributes.

Question 16

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 17

The ANSI prescribes a standard SQL-the current fully approved version is known as SQL­07.

Accepted Answer

A) True 
 B)False

Question 18

The basic SQL vocabulary has fewer than words.

Accepted Answer

100 one hu

Question 19

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 20

To delete an index,one must use the command.

Accepted Answer

The answer of To delete an index,one must use the...

Rows can be grouped into smaller collections quickly and easily using the clause within the SELECT statement.

Most SQL implementations yield case-insensitive searches.

The CHECK constraint is used to define a condition for the values that the attribute domain cannot have.

All changes in a table structure are made using the command,followed by a keyword that produces the specific changes a user wants to make.

What is a schema? How many schemas can be used in one database?

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

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

With the exception of the database process,most RDBMS vendors use SQL that deviates little from the ANSI standard SQL.

The SQL command that allows a user to permanently save data changes is .

If you have not yet used the COMMIT command to store the changes permanently in the database,you can restore the database to its previous condition with the ROLLBACK command.

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

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.

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

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 data manipulation command HAVING:

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

The ANSI prescribes a standard SQL-the current fully approved version is known as SQL07.

The basic SQL vocabulary has fewer than words.

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

To delete an index,one must use the command.

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

Rows can be grouped into smaller collections quickly and easily using the clause within the SELECT statement.

Most SQL implementations yield case-insensitive searches.

The CHECK constraint is used to define a condition for the values that the attribute domain cannot have.

All changes in a table structure are made using the command,followed by a keyword that produces the specific changes a user wants to make.

What is a schema? How many schemas can be used in one database?

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

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

With the exception of the database process,most RDBMS vendors use SQL that deviates little from the ANSI standard SQL.

The SQL command that allows a user to permanently save data changes is .

If you have not yet used the COMMIT command to store the changes permanently in the database,you can restore the database to its previous condition with the ROLLBACK command.

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

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.

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

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 data manipulation command HAVING:

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

The ANSI prescribes a standard SQL-the current fully approved version is known as SQL­07.

The basic SQL vocabulary has fewer than words.

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

To delete an index,one must use the command.

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

The ANSI prescribes a standard SQL-the current fully approved version is known as SQL07.