Question 1

Which query will output the table contents when the value of P_PRICE is less than or equal to 10?

Accepted Answer

A)  SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE P_PRICE  10; 
B)  SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE P_PRICE  10; 
D)  SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE P_PRICE = 10; 
A)  SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE P_PRICE  10; 
B)  SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE P_PRICE  10; 
D)  SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE P_PRICE = 10; B

Question 2

Which query 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} A

Question 3

The SQL command that lets you permanently save data changes is ____.

Accepted Answer

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

Question 4

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

Accepted Answer

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

Question 5

String comparisons are made from left to right.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

The answer of In an INSERT command,you can indicate just...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

A database language enables the user to create database and table structures to perform basic data management chores.

Accepted Answer

A) True 
 B)False

Question 10

The query used to list the P_CODE,P_DESCRIPT,P_INDATE,and P_PRICE fields from the PRODUCT table in ascending order by P_PRICE is ____.

Accepted Answer

A)  SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
FROM PRODUCT
SEQUENCE BY P_PRICE; 
B)  SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
FROM PRODUCT
LIST BY P_PRICE; 
C)  SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
FROM PRODUCT
ORDER BY P_PRICE; 
D)  SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
FROM PRODUCT
ASCENDING BY P_PRICE; 
A)  SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
FROM PRODUCT
SEQUENCE BY P_PRICE; 
B)  SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
FROM PRODUCT
LIST BY P_PRICE; 
C)  SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
FROM PRODUCT
ORDER BY P_PRICE; 
D)  SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
FROM PRODUCT
ASCENDING BY P_PRICE;

Question 11

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 12

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 13

The SQL query to output the contents of the EMPLOYEE table sorted by last name,first name,and initial is ____.

Accepted Answer

A)  SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE
FROM EMPLOYEE
LIST BY EMP_LNAME, EMP_FNAME, EMP_INITIAL; 
B)  SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE
FROM EMPLOYEE
ORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL; 
C)  SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE
FROM EMPLOYEE
DISPLAY BY EMP_LNAME, EMP_FNAME, EMP_INITIAL; 
D)  SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE
FROM EMPLOYEE
SEQUENCE BY EMP_LNAME, EMP_FNAME, EMP_INITIAL; 
A)  SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE
FROM EMPLOYEE
LIST BY EMP_LNAME, EMP_FNAME, EMP_INITIAL; 
B)  SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE
FROM EMPLOYEE
ORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL; 
C)  SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE
FROM EMPLOYEE
DISPLAY BY EMP_LNAME, EMP_FNAME, EMP_INITIAL; 
D)  SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE
FROM EMPLOYEE
SEQUENCE BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;

Question 14

If you add a new column to a table that already has rows,the existing rows will default to a value of ____________________ for the new column.

Accepted Answer

The answer of If you add a new column to...

Question 15

Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command sequence.

Accepted Answer

A) True 
 B)False

Question 16

To delete an index,use the ____________________ command.

Accepted Answer

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

Question 17

All SQL commands must be issued on a single line.

Accepted Answer

A) True 
 B)False

Question 18

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 19

The SQL command that modifies an attribute's values in one or more table's rows is ____.

Accepted Answer

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

Question 20

Since computers identify all characters by their numeric codes,mathematical operators cannot be used to place restrictions on character-based attributes.

Accepted Answer

A) True 
 B)False

Which query will output the table contents when the value of P_PRICE is less than or equal to 10?

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

The SQL command that lets you permanently save data changes is ____.

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

String comparisons are made from left to right.

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

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

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

A database language enables the user to create database and table structures to perform basic data management chores.

The query used to list the P_CODE,P_DESCRIPT,P_INDATE,and P_PRICE fields from the PRODUCT table in ascending order by P_PRICE is ____.

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

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

The SQL query to output the contents of the EMPLOYEE table sorted by last name,first name,and initial is ____.

If you add a new column to a table that already has rows,the existing rows will default to a value of ____________________ for the new column.

Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command sequence.

To delete an index,use the ____________________ command.

All SQL commands must be issued on a single line.

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

The SQL command that modifies an attribute's values in one or more table's rows is ____.

Since computers identify all characters by their numeric codes,mathematical operators cannot be used to place restrictions on character-based attributes.

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)

Which query will output the table contents when the value of P_PRICE is less than or equal to 10?

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

The SQL command that lets you permanently save data changes is ____.

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

String comparisons are made from left to right.

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

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

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

A database language enables the user to create database and table structures to perform basic data management chores.

The query used to list the P_CODE,P_DESCRIPT,P_INDATE,and P_PRICE fields from the PRODUCT table in ascending order by P_PRICE is ____.

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

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

The SQL query to output the contents of the EMPLOYEE table sorted by last name,first name,and initial is ____.

If you add a new column to a table that already has rows,the existing rows will default to a value of ____________________ for the new column.

Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command sequence.

To delete an index,use the ____________________ command.

All SQL commands must be issued on a single line.

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

The SQL command that modifies an attribute's values in one or more table's rows is ____.

Since computers identify all characters by their numeric codes,mathematical operators cannot be used to place restrictions on character-based attributes.

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

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