DBMS Basics set 1

Computer Science is the study of how we can use computers to process and store data. The field encompasses a wide range of topics, from database management systems (DBMSs) to artificial intelligence (AI).

1: _________ is collection of operations that performs a single logical function in database application.
a. Interaction  
b. Operation  
c. Transaction
d. None of these
2: _____________ refers to the correctness and completeness of the data in a database?
a. Data security     
b. Data integrity
c. Data constraint
d. Data independence
3: __________________ is collection of interrelated data and set of program to access them.
a. Programming language      
b. Database Management System
c. Database  
d. Data Structure
4: A collection of objects whose behavior and states are defined in accordance to classes is said to be
a. Object relational databases    
b. Object Oriented databases  
c. Object entity databases
d. Object network databases
5: A condition that led to the development of databases was
a. a demand for more data to support information needs  
b. an increase in the amount of data handled by organizations  
c. the proliferation of data files
d. All of the above  
6: A data dictionary is a special file that contains:
a. The name of all fields in all files.    
b. The width of all fields in all files.  
c. The data type of all fields in all files.
d. All of the above.  
7: A data warehouse is which of the following?
a. Can be updated by end users.     
b. Contains numerous naming conventions and formats.
c. Organized around important subject areas.  
d. Contains only current data.
8: A data warehouse uses:
a. partial operational data.        
b. historical operational data.  
c. future operational data.  
d. health care data.
9: A database application can perform which of the following activities?
a. Add records       
b. Read records
c. Update records
d. All of the above.
10: A database is a complex type of ______.
a. Application   
b. Data Structure
c. Manager
d. None of these