DBI202-Test Questions and Answers All
Solved Correctly.
Authorizing access to database, coordinating, monitoring its use, are responsibilities of
a.database administrator
b.database designer
c.database programmer
d.database user - Answer A
Suppose relation R(A,B,C,D,E) and its FDs: AB->C, B->D, C->E, E->A. Which of following sets is a
closure of {AB}?
a. {AB}
b. {ABC}
c. {ABCD}
d. {ABCDE} - Answer D
The responsibility of Database management system is
a. Allow users to share data on the computer
b. Allow users the ability to crawl data from the Internet
c. Allow users the ability to manage data stored in hard disk
d. Allow users to create new databases and specify their schemas - Answer D
Which of the followings was the first ever used for data model?
A. File system
B. Tree based model
C. Graph based model
D. Relational model - Answer A
Which of the following statement is belong to DML(Data Manipulation Language)?
A. INSERT
B. CREATE
C. ALTER
D. GRANT - Answer A
Choose an INCORRECT statement
, A. Database is created and maintained by a DMBS
B. SQL is a only language be used to develop database application
C. Database is a collection of data that is managed by a DBMS
D. Database is a collection of information that exists over a long period of time - Answer B
The database system does NOT include any of the following
A. Operating System
B. data
C. DBMS Software
D. Application programs - Answer A
Select the INCORRECT statement
A. Microsoft PowerPoint is a special kind of DBMS
B. The first DBMS based on file system
C. The first DBMS was born in 1960s
D. The DBMS is expected to support the storage of very large amounts of data - Answer A
Which of the following keywords is NOT included in SQL query language?
A. MODIFY
B. INSERT
C. ALTER
D. UPDATE
E. SELECT - Answer A
Select the INCORRECT statement
A. A database is a collection of a irrelevant data
B. A database is managed by a DBMS
C. A database is a collection of data that exists over a long period of time
D. DBMS is a software package or system - Answer A
Which of the following statements best defines about data model?
A. Data model is a set of concepts used to represent structures of data
B. Data model is a set of concepts used to represent how data is stored
C. Data model is a set of concepts used to represent how to access data
Solved Correctly.
Authorizing access to database, coordinating, monitoring its use, are responsibilities of
a.database administrator
b.database designer
c.database programmer
d.database user - Answer A
Suppose relation R(A,B,C,D,E) and its FDs: AB->C, B->D, C->E, E->A. Which of following sets is a
closure of {AB}?
a. {AB}
b. {ABC}
c. {ABCD}
d. {ABCDE} - Answer D
The responsibility of Database management system is
a. Allow users to share data on the computer
b. Allow users the ability to crawl data from the Internet
c. Allow users the ability to manage data stored in hard disk
d. Allow users to create new databases and specify their schemas - Answer D
Which of the followings was the first ever used for data model?
A. File system
B. Tree based model
C. Graph based model
D. Relational model - Answer A
Which of the following statement is belong to DML(Data Manipulation Language)?
A. INSERT
B. CREATE
C. ALTER
D. GRANT - Answer A
Choose an INCORRECT statement
, A. Database is created and maintained by a DMBS
B. SQL is a only language be used to develop database application
C. Database is a collection of data that is managed by a DBMS
D. Database is a collection of information that exists over a long period of time - Answer B
The database system does NOT include any of the following
A. Operating System
B. data
C. DBMS Software
D. Application programs - Answer A
Select the INCORRECT statement
A. Microsoft PowerPoint is a special kind of DBMS
B. The first DBMS based on file system
C. The first DBMS was born in 1960s
D. The DBMS is expected to support the storage of very large amounts of data - Answer A
Which of the following keywords is NOT included in SQL query language?
A. MODIFY
B. INSERT
C. ALTER
D. UPDATE
E. SELECT - Answer A
Select the INCORRECT statement
A. A database is a collection of a irrelevant data
B. A database is managed by a DBMS
C. A database is a collection of data that exists over a long period of time
D. DBMS is a software package or system - Answer A
Which of the following statements best defines about data model?
A. Data model is a set of concepts used to represent structures of data
B. Data model is a set of concepts used to represent how data is stored
C. Data model is a set of concepts used to represent how to access data
