Question 1

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 A

Question 2

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

Accepted Answer

schema

Question 3

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

Accepted Answer

Oracle

Question 4

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

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

Which query will list all the rows in which the inventory stock dates occur on or after January 20, 2010?

Accepted Answer

A)  SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE
FROM PRODUCT
WHERE P_INDATE >= '20-JAN-2010' 
B)  SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE
FROM PRODUCT
WHERE P_INDATE >= $20-JAN-2010$ 
C)  SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE
FROM PRODUCT
WHERE P_INDATE = {20-JAN-2010} 
A)  SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE
FROM PRODUCT
WHERE P_INDATE >= '20-JAN-2010' 
B)  SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE
FROM PRODUCT
WHERE P_INDATE >= $20-JAN-2010$ 
C)  SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE
FROM PRODUCT
WHERE P_INDATE = {20-JAN-2010}

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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 10

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

Accepted Answer

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

Question 11

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 12

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

Question 13

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 14

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

Accepted Answer

In the SQL environment, a schema is a lo

Question 15

The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE, and V_CONTACT fields from the VENDOR table where the values of V_CODE match is ____.

Accepted Answer

A)  SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE  VENDOR.V_CODE; 
B)  SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE = VENDOR.V_CODE; 
C)  SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE  VENDOR.V_CODE; 
A)  SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE  VENDOR.V_CODE; 
B)  SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE = VENDOR.V_CODE; 
C)  SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE  VENDOR.V_CODE;

Question 16

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

Question 17

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

Accepted Answer

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

Question 18

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 19

To delete an index, use the ____________________ command.

Accepted Answer

The answer of To delete an index, use the ____________________...

Question 20

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

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

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

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

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

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

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.

Which query will list all the rows in which the inventory stock dates occur on or after January 20, 2010?

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

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

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

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

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

You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output.

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

The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE, and V_CONTACT fields from the VENDOR table where the values of V_CODE match is ____.

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.

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

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

To delete an index, use the ____________________ command.

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

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters

Exam 5: Beginning Structured Query Language Sql

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

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

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

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

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

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.

Which query will list all the rows in which the inventory stock dates occur on or after January 20, 2010?

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

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

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

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

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

You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output.

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

The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE, and V_CONTACT fields from the VENDOR table where the values of V_CODE match is ____.

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.

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

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

To delete an index, use the ____________________ command.

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

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters

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