Question 1

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

Accepted Answer

True

Question 2

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

Accepted Answer

True

Question 3

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

Accepted Answer

False

Question 4

The ANSI SQL standards are also accepted by the ISO.

Accepted Answer

True

Question 5

SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words.

Accepted Answer

False

Question 6

The SQL command that allows a user to insert rows into a table is _____.

Accepted Answer

INSERT

Question 7

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

Accepted Answer

COMMIT

Question 8

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

Accepted Answer

SELECT

Question 9

The SQL data manipulation command HAVING:

Accepted Answer

restricts the selection of grouped rows based on a condition.

Question 10

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

True

Question 11

Oracle users can use the Access QBE (query by example) query generator.

Accepted Answer

False

Question 12

Mathematical operators cannot be used to place restrictions on character-based attributes.

Accepted Answer

False

Question 13

String comparisons are made from left to right.

Accepted Answer

True

Question 14

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

Accepted Answer

True

Question 15

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

Accepted Answer

True

Question 16

ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause.

Accepted Answer

True

Question 17

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

Accepted Answer

False

Question 18

Most SQL implementations yield case-insensitive searches.

Accepted Answer

False

Question 19

Some RDBMSs, such as Microsoft Access, automatically make the necessary conversions to eliminate case sensitivity.

Accepted Answer

True

Question 20

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

Accepted Answer

Performing operations within parentheses

Question 21

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

Accepted Answer

EXISTS

Question 22

The special operator used to check whether an attribute value matches a given string pattern is _____.

Accepted Answer

Like

Question 23

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

Accepted Answer

IS NULL

Question 24

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

Accepted Answer

BETWEEN

Question 25

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

SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE  FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE = 24288;

Question 26

A(n) _____ is an alternate name given to a column or table in any SQL statement.

Accepted Answer

alias

Question 27

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

SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE  FROM PRODUCT;

Question 28

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

SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE  FROM PRODUCT WHERE P_INDATE >= \'20-JAN-2010\';

Question 29

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

Accepted Answer

SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE  FROM PRODUCT WHERE P_CODE

Question 30

Which of the following queries will output the table contents when the value of V_CODE is not equal to 21344?

Accepted Answer

SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE  FROM PRODUCT WHERE V_CODE  21344;

Question 31

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

Accepted Answer

SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE  FROM PRODUCT WHERE V_CODE = 21344;

Question 32

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

Accepted Answer

SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE  FROM PRODUCT WHERE P_PRICE

Question 33

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

Accepted Answer

SELECT  FROM  WHERE ;
        
                
            questionWhich 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 and display the results in a column labeled TOTVALUE?
            answerSELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE AS TOTVALUE  FROM PRODUCT;
        
                
                
            questionThe SQL query to output the contents of the EMPLOYEE table sorted by last name, first name, and initial is_____.
            answerSELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE ORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;
        
                
            questionThe 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 _____.
            answerSELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ORDER BY P_PRICE;

Question 34

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 and display the results in a column labeled TOTVALUE?

Accepted Answer

SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE AS TOTVALUE  FROM PRODUCT;

Question 35

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

Accepted Answer

SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE ORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;

Question 36

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

SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ORDER BY P_PRICE;

Lesson 6 Fundamentals of SQL – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards