Copy and Edit

Chapter 7 (True/False)

Description

asdf Quiz on Chapter 7 (True/False), created by . . on 22/09/2016.
. .
Quiz by . ., updated more than 1 year ago
. .
Created by . . about 8 years ago
113
2
0

Resource summary

Question 1

Question
1. A database language enables the user to create database and table structures to perform basic data management chores.
Answer
  • True
  • False

Question 2

Question
2. A database language enables the user to perform complex queries designed to transform the raw data into useful information.
Answer
  • True
  • False

Question 3

Question
3. The ANSI prescribes a standard SQL–the current fully approved version is known as SQL-07.
Answer
  • True
  • False

Question 4

Question
4. The ANSI SQL standards are also accepted by the ISO.
Answer
  • True
  • False

Question 5

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

Question 6

Question
6. Data type selection is usually dictated by the nature of the data and by the intended use.
Answer
  • True
  • False

Question 7

Question
7. Only numeric data types can be added and subtracted in SQL.
Answer
  • True
  • False

Question 8

Question
8. Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command sequence.
Answer
  • True
  • False

Question 9

Question
9. The CHECK constraint is used to define a condition for the values that the attribute domain cannot have.
Answer
  • True
  • False

Question 10

Question
10. SQL requires the use of the ADD command to enter data into a table.
Answer
  • True
  • False

Question 11

Question
11. You cannot insert a row containing a null attribute value using SQL
Answer
  • True
  • False

Question 12

Question
12. To list the contents of a table, you must use the DISPLAY command.
Answer
  • True
  • False

Question 13

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

Question 14

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

Question 15

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.
Answer
  • True
  • False

Question 16

Question
16. All SQL commands must be issued on a single line
Answer
  • True
  • False

Question 17

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.
Answer
  • True
  • False

Question 18

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.
Answer
  • True
  • False

Question 19

Question
19. Oracle users can use the Access QBE (query by example) query generator.
Answer
  • True
  • False

Question 20

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

Question 21

Question
21. String comparisons are made from left to right.
Answer
  • True
  • False

Question 22

Question
22. Date procedures are often more software-specific than other SQL procedures.
Answer
  • True
  • False

Question 23

Question
23. SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.
Answer
  • True
  • False

Question 24

Question
24. ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause.
Answer
  • True
  • False

Question 25

Question
25. The conditional LIKE must be used in conjunction with wildcard characters.
Answer
  • True
  • False

Question 26

Question
26. Most SQL implementations yield case-insensitive searches.
Answer
  • True
  • False

Question 27

Question
27. Some RDBMSs, such as Microsoft Access, automatically make the necessary conversions to eliminate case sensitivity.
Answer
  • True
  • False

Question 28

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.
Answer
  • True
  • False

Question 29

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 attributes do not match.
Answer
  • True
  • False

Question 30

Question
30. When joining three or more tables, you need to specify a join condition for one pair of tables.
Answer
  • True
  • False
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

El Perdón
Alonso Linares
Investiga las transformaciones de la cultura y de la vida cotidiana a lo largo del tiempo.
Sherlyn Muñoz
Irene
i.biza
Sean doce balines (a,b,c,d,e,f,g,h,i,j,k,l)
andres parra
Funciones Polinomiales
Julieta Maya
10.THE VALUATION PROCESS AND PRICING PROPERTIES
Brigita Safyra
Effective Citizens
Lauren Petrouleas
asdfas
bevan7
S C I E X
guohao.lam
Perspectives of learning
nilemon
Mind Idea
rodrigo.cespedes
Browse Library