vfxuanze 数据库

1. DBMS stands for C

A. Data Base Marginal System

B. Directory Based Memory Standard

C. Data Base Management System

D. Dual Bus Mask Storage

2. In a database, each row is called as a B

A. Horizontal data

B. Record

C. Information

D. None of these

3. All the rows in a table are C

A. Same

B. May or may not same

C. Different

D. All of these

4.Which of the following are the elements of a database D

A. Data

B. Relations

C. Constraint and Schema

D. All of these

5. Which of the following is a problem of file management system? D

A. Difficult to update

B. Lack of data independence

C. Data redundancy

D. All of above

6. What is the language used by most of the DBMSs for helping their users to access data? C

A. High level language

B. SQL

C. Query Language

D. 4GL

7. SQL stands for B

A. Standard Quality literature

B. Structured query Language

C. Standard Query Language

D. Standard Query Linguistics

8. In a large DBMS A

A. Each user can “see” only a small part of the entire database

B. Each subschema contains every field in the logical schema

C. Each user can access every subschema

D. None of the Above

9. Database Management System is a ________ A

A. Software

B. Hardware

C. Both are true

D. None of the above

10. Database management systems are intended to D

A. Eliminate data redundancy

B. Establish relationship among records in different files

C. Maintain data integrity

D. All of the above

11. DML is provided for C

A. Description of logical structure of database.

B. Addition of new structures in the database system.

C. Manipulation & processing of database.

D. Definition of physical structure of database system.

12. The highest level in the hierarchy of data organization is called B

A. Databank

B. Database

C. Data file

D. Data record

13. The language used application programs to request data from the DBMS is referred to as the A

A. DML

B. DDL

C. Query language

D. Any of the above

14. In the architecture of a database system external level is the D

A. Physical level.

B. Logical level.

C. Conceptual level

D. View level.

15. In the DBMS approach, application programs perform the B

A. Storage function

B. Processing functions

C. Access control

D. All of the above

16.The goals of DMBS is to___ and ____ database information. B

A. Store and search

B. Store and retrieve

C. Query and SQL

D. Read and write

17. Which of the following describes the high- level conceptual structuring of data? C

A. DBMS

B. SQL

C. Data model

D. E-R model

18. Overall design of the database is called database_______ D

A. View

B. Instance

C. Model

D. Schema

19. Actual content of the database at a particular moment is called B

A. View

B. Instance

C. Model

D. Schema

20. The language used express database schema using set of definitions is referred to as the B

A. DML

B. DDL

C. Query language

D. Any of the above

21. A statement requesting retrieval of information is called C

A. Table

B. Record

C. Query

D. Instance

22. A person who has the central control of both data and programs is called B

A. DBM

B. DBA

C. Security

D. Recorder

23. In an E-R diagram an entity set is represent by a A

A. Rectangle.

B. Ellipse.

C. Diamond

D. Circle.

24. In an E-R diagram attributes are represented by C

A. Rectangle.

B. Square.

C. Ellipse.

D. Triangle.

25. In an E-R diagram relationships are represented by D

A. Rectangle.

B. Square.

C. Ellipse.

D. Diamond.

26. Which of the following fields in a student file can be used as a primary key? B

A. Class

B. Student Number

C. GPA

D. Major

27. A set of possible data values is called D

A. Attribute.

B. Degree.

C. Tuple.

D. Domain.

28. ____________integrity ensures that each row can be uniquely identified an attribute called the primary key. B

A. Domain

B. Entity

C. Referential

D. None of the above

29. _____key is usually chose by the database designer C

A. Super

B. Candidate

C. Primary

D. Foreign

30. Minimal super keys are called ____keys B

A. Super

B. Candidate

C. Primary

D. Foreign

31. In an E-R diagram multivalued attribute represented by C

A. Square

B. Diamond C . Double ellipse D. Rectangle

32. In an E-R diagram derived attribute represented by B

A. Square

B. Dashed ellipse

C. Double ellipses

D. Rectangle

33. In an E-R diagram weak entity set represented by A

A. Double rectangle

B. Dashed ellipse

C. Double ellipses

D. Double diamond

34. A row of table in relational model terminology is classified as D

A. Range

B. Domain

C. Relation

D. Tuple

35. The column header of table in relational model terminology is classified as A

A. Attribute

B. Table starter

C. Table ender

D. Entity domain