上传者: peng3186
|
上传时间: 2019-12-21 20:26:17
|
文件大小: 259KB
|
文件类型: txt
View Assessment Result: Multiple-Choice Quiz 2
Your performance was as follows:
1.
The degree of a table is the number of _____ in the table.
(a) keys
(b) columns
(c) rows
(d) foreign keys
Correct answer is (b)
Your score on this question is: 10.00
Feedback:
(b)
--------------------------------------------------------------------------------
2.
The arity of a table is the number of _____ in the table.
(a) keys
(b) columns
(c) foreign keys
(d) rows
Correct answer is (b)
Your score on this question is: 10.00
Feedback:
(b)
--------------------------------------------------------------------------------
3.
What information is necessary when specifying the structure of a table?
(a) the name of the table and the amount of storage space to be allocated to the table
(b) the name of the table, the names of the table's attributes, the data types of the table's attributes, the formats of the table's attributes, and the maximum number of rows that the table can have
(c) the name of the table and the names of the table's attributes
(d) the name of the table, the names of the table's attributes, the data types of attributes, and the formats of attributes
Correct answer is (d)
Your score on this question is: 10.00
Feedback:
(d)
--------------------------------------------------------------------------------
4.
The foreign key in a table T1 _____ the same _____ as the corresponding primary key in table T2.
must have, name
need not have, name
must have, domain
(a) I, II, and III
(b) I and II
(c) I and III
(d) II and III
Correct answer is (d)
Your score on this question is: 10.00
Feedback:
(d)
--------------------------------------------------------------------------------
5.
Which of the following SQL statements can be used to add a row to a table?
(a) CREATE
(b) INSERT
(c) APPEND
(d) ADD
Correct answer is (b)