Question 1

Date procedures are often more software-specific than other SQL procedures.

Accepted Answer

A) True 
 B)False

Question 2

The syntax for creating an index is .

Accepted Answer

A)   CREATE [NOT NULL] INDEX indexname FROM viewname(column1 [, column2]) ;
B)   CREATE [UNIQUE] INDEX indexname ON tablename( column1 [, column2]) ;
C)   CREATE [UNIQUE] INDEX indexname FROM tablename(column1 [, column2]) ;
D)   CREATE [DEFAULT] INDEX indexname ON viewname(column1 [, column2]) ;E) B) and C)
F) A) and B)

Question 3

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.E) None of the above
F) All of the above

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

The SQL aggregate function that gives the arithmetic mean for a specific column is .

Accepted Answer

A)   COUNT
B)   AVG
C)   MAX
D)   SUME) All of the above
F) None of the above

Question 6

What are the wildcard characters that are used with the LIKE command? Provide one or more examples of each.

Accepted Answer

The LIKE special operator is used in con...

Question 7

The special operator used to check whether an attribute value is within a range of values is .

Accepted Answer

A)   BETWEEN
B)   NULL
C)   LIKE
D)   INE) A) and D)
F) A) and C)

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;E) B) and C)
F) C) and D)

Question 9

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 10

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)   CONVERTE) B) and D)
F) A) and B) B

Question 11

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

Accepted Answer

A)   BETWEEN
B)   EXISTS
C)   LIKE
D)   INE) None of the above
F) B) and D)

Question 12

Which of the following queries 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 
D)   SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDATE >= {20-JAN-2010};E) B) and D)
F) A) and D)

Question 13

In a 1:M relationship, a user must always create the table for the side first.

Accepted Answer

The answer of In a 1:M relationship, a user must...

Question 14

The ANSI SQL standards are also accepted by the ISO.

Accepted Answer

A) True 
 B)False  True

Question 15

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 16

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

Accepted Answer

A)   COMMIT
B)   ROLLBACK
C)   UNSAVE
D)   UPDATEE) B) and D)
F) A) and C)

Question 17

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

Accepted Answer

Authentication

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

The special operator is used to check whether an attribute value is null.

Accepted Answer

A)   BETWEEN
B)   IS NULL
C)   LIKE
D)   NOT NULLE) A) and B)
F) All of the above

Question 20

A(n) is performed when data are retrieved from more than one table at a time.

Accepted Answer

The answer of A(n) is performed when data are retrieved...

Exam 7: Introduction to Structured Query Language Sql

Date procedures are often more software-specific than other SQL procedures.

Correct AnswerverifiedShow Answer

The syntax for creating an index is .

Correct AnswerverifiedShow Answer

The SQL data manipulation command HAVING:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The SQL aggregate function that gives the arithmetic mean for a specific column is .

Correct AnswerverifiedShow Answer

What are the wildcard characters that are used with the LIKE command? Provide one or more examples of each.

Correct AnswerverifiedThe LIKE special operator is used in con...View AnswerShow Answer

The special operator used to check whether an attribute value is within a range of values is .

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA subquery, also known as a nested query...View AnswerShow Answer

In Oracle, the command is used to change the display for a column, for example, to place a $ in front of a numeric value.

Correct AnswerverifiedB

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In a 1:M relationship, a user must always create the table for the side first.

Correct AnswerverifiedShow Answer

The ANSI SQL standards are also accepted by the ISO.

Correct AnswerverifiedTrue

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedAuthentication

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

Correct AnswerverifiedShow Answer

The special operator is used to check whether an attribute value is null.

Correct AnswerverifiedShow Answer

A(n) is performed when data are retrieved from more than one table at a time.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The LIKE special operator is used in con...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A subquery, also known as a nested query...
View Answer

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Authentication

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified