1. _______refers to the basic facts and entities, such as names and numbers.
a. Data
b. Information
c. Input
d. Output
2. Information is processed from __________
a. Output
b. Data
c. Memory
d. None of these
3. MIS stands for:
a. Management Information Server
b. Management Information Service
c. Management Information System
d. Master Information System
4. Which is the false statement:
a. A database is ordered collection of data.
b. A database is systematic compilation of records in a computer.
c. DBMS manages the database
d. Data helps in making decisions.
5. Which is the data model
a. Relational
b. Object-Relational
c. Network
d. All of these
6. Which is not the feature of database:
a. Data redundancy
b. Independence
c. Flexibility
d. Data Integrity
7. Which is the type of data independence:
a. Physical data independence
b. Logical data independence
c. Both
d. None of these
8. Which is the feature of database:
a. Query Language
b. Multi user access
c. Data Dictionary
d. All of these
9. Which is the advantage of database:
a. Prevents Data redundancy
b. Restricts unauthorized access
c. Persistent storage
d. Backup and recovery
e. Integrity Constraints
f. All of these
10. Which is the database language:
a. C
b. C++
c. SQL
d. None of these
11. Which person is responsible for overall activities for database:
a. Database designer
b. Database analyst
c. Database Administrator
d. Database manager
12. Which level of database is viewed by user:
a. Internal level
b. External Level
c. Conceptual Level
d. All of these
13. Internal level has:
a. Individual Users View of the database
b. Community view of the database
c. Physical Representation of the database
d. All of these
14. Which is the component of database management system:
a. Query Language
b. Database Manager
c. File manager
d. All of these
15. ______is the structure of the database.
a. Table
b. Relation
c. Schema
d. None of these
16. Schema is usually stored in____________.
a. Tables
b. Data Dictionary
c. Both
d. None of these
17. Schema is defined by:
a. DML
b. DDL
c. DCL
d. DQL
18. DML language is used to:
a. Define schema
b. Define internal level
c. Access Data
d. All of these
19. DBMS is the bridge between operating system and ___________.
a. User
b. Database administrator
c. Application program
d. None of these
20. Which is the most popular database model:
a. Network Model
b. Relational Model
c. Hierarchical Model
d. Object Oriented
21. Which is the schema object:
a. Database links and clusters
b. Packages and Indexes
c. Procedures and functions
d. All of these
22. In database records are called:
a. Attributes
b. Entity
c. Tuples
d. Relations
23. An entity has a set of ___________ that describe it.
a. Attributes
b. Entity
c. Tuples
d. Relations
24. In ER model rectangle represents:
a. Attributes
b. Entity set
c. Relationships
d. None of these
25. Date is the type of attribute:
a. Simple
b. Composite
c. Single values
d. Multi valued
26. __________is the attribute or group of attributes that uniquely identify occurrence of each entity.
a. Foreign key
b. Super Key
c. Primary Key
d. All of these
27. _________is the real world object, such as a person, place etc.
a. Attribute
b. Entity
c. Records
d. All of these
28. Grant and revoke is the type of command:
a. DDL
b. DML
c. DCL
d. DQL
29. A user that manages the files of application in DBMS is called:
a. Administrator
b. Database analyst
c. File Manager
d. None of these
30. ________is the information about data.
a. Data
b. Meta-Data
c. Entity
d. Relations
No comments:
Post a Comment