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

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

Accepted Answer

True

Question 7

Only numeric data types can be added and subtracted in SQL.

Accepted Answer

False

Question 8

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

Accepted Answer

True

Question 9

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

Accepted Answer

False

Question 10

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

Accepted Answer

False

Question 11

You cannot insert a row containing a null attribute value using SQL.

Accepted Answer

False

Question 12

To list the contents of a table, you must use the DISPLAY command.

Accepted Answer

False

Question 13

Any changes made to the contents of a table are not physically saved on disk until you use the SAVE  command.
            answerFalse

questionThe COMMIT command does not permanently save all changes. In order to do that, you must use SAVE.
            answerFalse

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

questionAll SQL commands must be issued on a single line.
            answerFalse

questionAlthough SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command\'s components.
            answerTrue

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

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

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

questionString comparisons are made from left to right.
            answerTrue

questionDate procedures are often more software-specific than other SQL procedures.
            answerTrue

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

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

questionThe conditional LIKE must be used in conjunction with wildcard characters.
            answerTrue

questionMost SQL implementations yield case-insensitive searches.
            answerFalse

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

questionThe COUNT function is designed to tally the number of non-null \"values\" of an attribute, and is often used in conjunction with the DISTINCT clause.
            answerTrue

questionTo join tables, simply enumerate the tables in the FROM clause of the SELECT statement. The DBMS will create a Cartesian product of every table in the FROM clause. To get the correct results, you need to select the rows in which the common attribute values do not match.
            answerFalse

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

Accepted Answer

False

Question 14

The COMMIT command does not permanently save all changes. In order to do that, you must use SAVE.

Accepted Answer

False

Question 15

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

True

Question 16

All SQL commands must be issued on a single line.

Accepted Answer

False

Question 17

Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command\'s components.

Accepted Answer

True

Question 18

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 19

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

Accepted Answer

False

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

False

Question 21

String comparisons are made from left to right.

Accepted Answer

True

Question 22

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

Accepted Answer

True

Question 23

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

Accepted Answer

True

Question 24

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

Accepted Answer

True

Question 25

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

Accepted Answer

True

Question 26

Most SQL implementations yield case-insensitive searches.

Accepted Answer

False

Question 27

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

Accepted Answer

True

Question 28

The COUNT function is designed to tally the number of non-null \"values\" of an attribute, and is often used in conjunction with the DISTINCT clause.

Accepted Answer

True

Question 29

To join tables, simply enumerate the tables in the FROM clause of the SELECT statement. The DBMS will create a Cartesian product of every table in the FROM clause. To get the correct results, you need to select the rows in which the common attribute values do not match.

Accepted Answer

False

Question 30

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

Accepted Answer

False

Inf2603 Ch5 – Sql – True / False Test Questions – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards