. .
Quiz by , created more than 1 year ago

asdf Quiz on Chapter 7 (True/False), created by . . on 22/09/2016.

49
2
0
. .
Created by . . over 7 years ago
Close

Chapter 7 (True/False)

Question 1 of 30

1

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

Select one of the following:

  • True
  • False

Explanation

Question 2 of 30

1

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

Select one of the following:

  • True
  • False

Explanation

Question 3 of 30

1

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

Select one of the following:

  • True
  • False

Explanation

Question 4 of 30

1

4. The ANSI SQL standards are also accepted by the ISO.

Select one of the following:

  • True
  • False

Explanation

Question 5 of 30

1

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

Select one of the following:

  • True
  • False

Explanation

Question 6 of 30

1

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

Select one of the following:

  • True
  • False

Explanation

Question 7 of 30

1

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

Select one of the following:

  • True
  • False

Explanation

Question 8 of 30

1

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

Select one of the following:

  • True
  • False

Explanation

Question 9 of 30

1

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

Select one of the following:

  • True
  • False

Explanation

Question 10 of 30

1

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

Select one of the following:

  • True
  • False

Explanation

Question 11 of 30

1

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

Select one of the following:

  • True
  • False

Explanation

Question 12 of 30

1

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

Select one of the following:

  • True
  • False

Explanation

Question 13 of 30

1

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

Select one of the following:

  • True
  • False

Explanation

Question 14 of 30

1

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

Select one of the following:

  • True
  • False

Explanation

Question 15 of 30

1

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.

Select one of the following:

  • True
  • False

Explanation

Question 16 of 30

1

16. All SQL commands must be issued on a single line

Select one of the following:

  • True
  • False

Explanation

Question 17 of 30

1

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.

Select one of the following:

  • True
  • False

Explanation

Question 18 of 30

1

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.

Select one of the following:

  • True
  • False

Explanation

Question 19 of 30

1

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

Select one of the following:

  • True
  • False

Explanation

Question 20 of 30

1

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

Select one of the following:

  • True
  • False

Explanation

Question 21 of 30

1

21. String comparisons are made from left to right.

Select one of the following:

  • True
  • False

Explanation

Question 22 of 30

1

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

Select one of the following:

  • True
  • False

Explanation

Question 23 of 30

1

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

Select one of the following:

  • True
  • False

Explanation

Question 24 of 30

1

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

Select one of the following:

  • True
  • False

Explanation

Question 25 of 30

1

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

Select one of the following:

  • True
  • False

Explanation

Question 26 of 30

1

26. Most SQL implementations yield case-insensitive searches.

Select one of the following:

  • True
  • False

Explanation

Question 27 of 30

1

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

Select one of the following:

  • True
  • False

Explanation

Question 28 of 30

1

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.

Select one of the following:

  • True
  • False

Explanation

Question 29 of 30

1

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 attributes do not match.

Select one of the following:

  • True
  • False

Explanation

Question 30 of 30

1

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

Select one of the following:

  • True
  • False

Explanation

Previous
Check answer
Next