Quiz
Chapter 7 (True/False)
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (30)
11. A database language enables the user to create database and table structures to perform basic data management
chores.- ATrue
- BFalse
22. A database language enables the user to perform complex queries designed to transform the raw data into useful
information.- ATrue
- BFalse
33. The ANSI prescribes a standard SQL–the current fully approved version is known as SQL-07.
- ATrue
- BFalse
44. The ANSI SQL standards are also accepted by the ISO.
- ATrue
- BFalse
55. SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words.
- ATrue
- BFalse
66. Data type selection is usually dictated by the nature of the data and by the intended use.
- ATrue
- BFalse
77. Only numeric data types can be added and subtracted in SQL.
- ATrue
- BFalse
88. Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command
sequence.- ATrue
- BFalse
99. The CHECK constraint is used to define a condition for the values that the attribute domain cannot have.
- ATrue
- BFalse
1010. SQL requires the use of the ADD command to enter data into a table.
- ATrue
- BFalse
1111. You cannot insert a row containing a null attribute value using SQL
- ATrue
- BFalse
1212. To list the contents of a table, you must use the DISPLAY command.
- ATrue
- BFalse
1313. Any changes made to the contents of a table are not physically saved on disk until you use the SAVE<table name> command.
- ATrue
- BFalse
1414. The COMMIT command does not permanently save all changes. In order to do that, you must use SAVE
- ATrue
- BFalse
1515. 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.
- ATrue
- BFalse
1616. All SQL commands must be issued on a single line
- ATrue
- BFalse
1717. 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.
- ATrue
- BFalse
1818. You can select partial table contents by naming the desired fields and by placing restrictions on the rows to be included in the output.
- ATrue
- BFalse
1919. Oracle users can use the Access QBE (query by example) query generator.
- ATrue
- BFalse
2020. Since computers identify all characters by their numeric codes, mathematical operators cannot be used to place restrictions on character-based attributes.
- ATrue
- BFalse
2121. String comparisons are made from left to right.
- ATrue
- BFalse
2222. Date procedures are often more software-specific than other SQL procedures.
- ATrue
- BFalse
2323. SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.
- ATrue
- BFalse
2424. ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause.
- ATrue
- BFalse
2525. The conditional LIKE must be used in conjunction with wildcard characters.
- ATrue
- BFalse
2626. Most SQL implementations yield case-insensitive searches.
- ATrue
- BFalse
2727. Some RDBMSs, such as Microsoft Access, automatically make the necessary conversions to eliminate case
sensitivity.- ATrue
- BFalse
2828. 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.
- ATrue
- BFalse
2929. 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.
- ATrue
- BFalse
3030. When joining three or more tables, you need to specify a join condition for one pair of tables.
- ATrue
- BFalse
Information
- Description
- asdf Quiz on Chapter 7 (True/False), created by . . on 22/09/2016.
- Author
- . .
- Language
- English
- Views
- 230
- Tags
- Rating
- No ratings yet Rate this quiz