(A) True
(B) False
(C) Both
(D) None
Tag: Database Interview Questions
Which of the following statements creates a database named COMPANY?
(A) CREATE DATABASE company
(B) CREATE DB company
(C) ADD DATABASE copmany
(D) CREATE company DATABASE
Which of the following statements are Data Definition Language command?
(A) INSERT
(B) UPDATE
(C) GRANT
(D) TRUNCATE
Which of the following describes a database system?
(A) A collection of stored operational data used by the application system of some particular enterprise
(B) A shared collection of logically related data (and a description of this data) designed to meet the information needs of an organisation
(C) A collection of stored data organised in such a way that all user requirements are satisfied by the database. In general there is only one copy of each item of data although there may be controlled repetition of some data
(D) All of the above
In a three-level DBMS architecture, the __ level interacts directly with the users.
(A) external
(B) conceptual
(C) internal
(D) physical
Which of the following concepts is applicable with respect to 2NF?
(A) Full functional dependency
(B) Any kind of dependency
(C) Transitive dependency
(D) Non-transitive dependency
Database management systems, operating systems, applications and utilities are all examples of __.
(A) hardware
(B) software
(C) computer infrastructure
(D) input and output
The __ constraint specifies whether each entity supertype occurrence must also be a member of at least one subtype?
(A) specialization
(B) uniqueness
(C) inheritance
(D) completeness