Knowledge Check 2
1) One of the ways of storing data in Computers is
a. Data Base Management System
b. Data storage system
c. Data Report System
It is one of the ways of storing data in computers. The other type of storing data is file storing system
2) Draw backs of File System are ( Select the appropriate Option)
a. Data Dependency
b. Sharing
c. Security
d. None of the above
e. All of the above
. As all the options like Data dependency, sharing and security are the draw backs of file system.
3) The best definition of DBMS is ( choose the appropriate answer)
a. It is a program that lets one or more computer users create and access data in a database
b. It provides the definition, storage, and management of data in the centralized pool that can be shared by many users
c. Both a & b
d. None
4) What is Control data concurrency?
a. A properly set-up database minimizes data redundancy. It will avoid data repetition in the databases
b. Databases allow you to set up rules that ensure that data remains consistent when add or modify data
c. Databases allows multiple users to access the same database simultaneously
d. None
5) For a DBMS to be relational Codd’s rules have to be followed
a. False
b. True
c. None of the above
6) “A set of related tables forms a database and all data is represented as tables, the data can be viewed in no other way”, is the _________ codd’s rule
a.Codd’s 1 rule
b.Codd’s 2 rule
d. None of the above
Codd’s 2 rules specify that the primary key condition prevents the entryof duplicate and null values.
7) Database model conceived as flexible way of representing objects and their
Relationships, is known as _________ Model (choose the appropriate Model Name)
a. Network Model
b. Hierarchical Model
c. Relational Model
d. None of the above
8) The Different Types of Data Models are (choose the correct option)
a. Rational Model
b. Network Model
c. Hierarchical Model
d. Relational Model
e. a, b and c
f. b, c, and d
9) Data integrity means the consistency and accuracy of the data in the database
(i.e., keeping the garbage out of the database) is the ________ codd’s rule
a. Codd’s 10 rule
b.Codd’s 11 rule
d. None of the above
Codd’s 10 rules it is specify that Data integrity means the consistency and accuracy of the data in the database (i.e., keeping the garbage out of the database)
10) _________ represents a collection of information about a separate item
a. Table
b. Row
c. Column
d. database
0 comments:
Post a Comment