数据库原理英文选择题.docx

1、Made by Christina2009-6-24Multiple-Choice Quiz 11. An E-Commerce system consists of the following components. Which of these same components must be included in a database? (a)The data, such as information about the goods available for sale, customers, orders placed, shipping information, etc.A data

2、base must include a collection of programs that control the data, such as programs to create, maintain, and manipulate the data. These programs can be easily used to create, maintain, and manipulate data in other domains. A database must include a collection of programs that operate on the data, but

3、 are specific to the E-commerce system. These programs enable users to browse through the store-items, place orders, track shipping, etc. (a) I only(b) I, II, and III (c) II only(d) I and II only 2. In a database system, whose responsibility is it to provide data consistency? (b) (a) the database ad

4、ministrators(b) the DBMSs (c) the users(d) the application programmers 3. An E-Commerce system consists of the following components. Which of the same components must be included in a database management system? (b)The data, such as information about the goods available for sale, customers, orders p

5、laced, shipping information, etc. A collection of programs must be included that control the data, such as programs to create, maintain, and manipulate the data. These programs can be easily used to create, maintain, and manipulate data in other domains, such as in a library information system. A co

6、llection of programs that operate on the data, but are specific to the E-commerce system. These programs enable users to browse through the store-items, place orders, track shipping, etc. (a) II and III only(b) II only (c) I, II, and III(d) I only 4. An E-Commerce database contains data about custom

7、ers, products, orders, system response times, etc. Which of the following can be specified as integrity constraints in an E-Commerce database system? (d) No two products can have the same product ID. The DBMS response time for all Web requests should be at most 2 seconds. A customer order cannot hav

8、e more than one shipping address. (a) I, II, and III(b) I and II only (c) I only(d) I and III only 5. An E-Commerce system consists of the following components. Which of these same components will constitute a database system? (c)The data, such as information about the goods available for sale, cust

9、omers, orders placed, shipping information, etc.A collection of programs that control the data, such as programs to create, maintain, and manipulate the data constitutes a database system. These programs can be easily used to create, maintain, and manipulate data in other domains such as in a librar

10、y information system. A collection of programs that operate on the data, but are specific to the E-commerce system, constitutes a database system. These programs enable users to browse through the store-items, place orders, track shipping, etc. (a) I only(b) II only (c) I, II, and III(d) I and II on

11、ly 6. A database is needed for which of the following application scenarios? (a)A video store that needs to keep track of data about members, about videos carried by the store, about videos rented by members, as well as data concerning borrow-date, return-date, and payment information. In the human

12、resources department of a company, information about employees, their titles, their salaries and sick days, and about vacation days taken by each employee. A computer-simulated video game which needs to calculate and display, the physical (x, y) location of each actor in the game, the speed with whi

13、ch they are moving at the current instant, the direction in which they are moving, the action they are performing, the angle at which the game-player is viewing the scene. (a) I and II only(b) I only (c) I and III only(d) I, II, and III 7. The physical storage structure will be _ to the application

14、programmer in a database approach, and will be _ to the application programmer in a file system approach. (c) (a) hidden, hidden(b) visible, visible (c) hidden, visible(d) visible, hidden Multiple-Choice Quiz 2 1. What information is necessary when specifying the structure of a table? (a) (a) the na

15、me of the table, the names of the tables attributes, the data types of attributes, and the formats of attributes (b) the name of the table and the names of the tables attributes (c) the name of the table, the names of the tables attributes, the data types of the tables attributes, the formats of the

16、 tables attributes, and the maximum number of rows that the table can have (d) the name of the table and the amount of storage space to be allocated to the table 2. The arity of a table is the number of _ in the table. (b) (a) keys(b) columns (c) rows(d) foreign keys 3. The cardinality of a table is

17、 the number of _ in the table. (c) (a) keys (b) foreign keys (c) rows(d) columns 4. The degree of a table is the number of _ in the table. (c) (a) key (b) rows (c) columns(d) foreign keys 5. For two tables to be union compatible, the tables should be the same with respect to which of the following?

18、(c) (a) keys(b) cardinality (c) degree(d) name 6. Which of the following SQL statements can be used to add a row to a table? (b) (a) CREATE(b) INSERT (c) APPEND(d) ADD 7. Which of the following SQL statements can be used to remove a row from a table? (a) (a) DELETE(b) ERASE (c) DESTROY(d) REMOVE 8.

19、Which of the following SQL statements can be used to modify just one row (out of many rows) in a table? (d) (a) MODIFY(b) CHANGE (c) ALTER(d) UPDATE 9. The SQL clause to perform a set UNION operation is (d) (a) MELD(b) UNITE (c) COMBINE(d) UNION 10. The term query by example refers to (d) (a) exampl

20、e SQL queries provided by other users that can be modified to suit current needs (b) a query for SQL examples (c) example SQL queries provided by the DBMS that users can modify to suit their current needs (d) a visual query language developed by IBM 11. The foreign key in a table T1 _ the same _ as

21、the corresponding primary key in table T2. (a) must have, name need not have, name must have, domain (a) II and III(b) I and III (c) I and II(d) I, II, and III 12. DML is used to (a) (a) add/modify/delete data in the database. (b) manipulate the structure of database applications. (c) add and delete

22、 tables. (d) specify the structure of a database. 13. What can be specified in the selection condition of a SELECT statement? (a) (a) a Boolean operation (b) the time at which the selection should be performed (c) an arithmetic operation (d) the conditions under which the statement should be execute

23、d 14. Which of the following SQL statements can be used to create a relational table? (c) (a) ADD(b) APPEND (c) CREATE(d) INSERT 15. With Query By Example, a user enters a query by (c) (a) placing SQL keywords, such as select, under the column names they want to retrieve (b) typing a syntactically c

24、orrect SQL query that uses column and table names similar to the correct column and table names in a database (c) filling in skeleton tables of the database with examples of what is to be retrieved (d) writing an English description of the data that the user needs 16. DDL is used to (b) (a) access t

25、he contents of tables. (b) specify the structure of a database. (c) add contents to tables. (d) define the structure of database applications. 17. A join operation joins _ tables into _. (c) (a) four, two(b) three, one (c) two, one(d) three, two 18. A difference operation can be applied to tables th

26、at (d) (a) have the same name (b) are the same size (c) have the same column names (d) are union compatible 19. The SQL clause to perform a set difference operation is (b) (a) REJECT(b) EXCEPT (c) DIFFER(d) OMIT Multiple-Choice Quiz 3 1. When a string whose length is strictly less than n is entered

27、as the value of a field whose SQL data type is VARCHAR(n), the system responds by (c) (a) padding the end of the string with NULL characters to length n before storing it. (b) padding the end of the string with spaces to length n before storing it. (c) storing the string as is. (d) re-prompting for

28、the entry of a string whose length is exactly n. 2. In SQL, when destroying a database, the RESTRICT option removes (b) (a) everything in the specified database: the data, schema, etc. (b) the schema if the database has no data (empty tables) (c) the data and schema from the specified database, but

29、not from related databases (d) the data but not the schema 3. In SQL, a database can be destroyed by which of the following? (c) (a) the command DESTROY DATABASE (b) a series of DESTROY TABLE commands (c) the command DROP SCHEMA (d) the command DELETE DATABASE 4. In SQL, when destroying a database,

30、the CASCADE option removes (b) (a) the data and schema from the specified database, and from related databases (b) everything in the specified database: the data, schema, etc. (c) the schema if the database has no data (empty tables) (d) the data but not the schema 5. In SQL, one function of the AS

31、operator is to (d) (a) limit the cardinality of a relation (b) define the domain of an attribute (c) control the order in which a querys rows are sorted (d) customize the names of columns in a querys result 6. In SQL, a database can be created by which of the following? (d) (a) the command ADD DATABASE (b) the command INSERT DATABASE (c) a series of CREATE TABLE commands (d) the command CREATE SCHEMA 7. When specifying a selection criterion