MCQ 1 DBMS Difficulty level 0

Q11.   The database schema is written in

(A) HLL                                                 (B) DML

(C) DDL                                                (D) DCL

Q12.   In the architecture of a database system external level is the

(A) physical level.                                  (B) logical level.

(C) conceptual level                               (D) view level.

Q13.   An entity set that does not have sufficient attributes to form a primary key is a

(A) strong entity set.                              (B) weak entity set.

(C) simple entity set.                              (D) primary entity set.

Q14.   In a Hierarchical model records are organized as

(A) Graph.                                             (B) List.

(C) Links.                                              (D) Tree.

Q15.   In an E-R diagram attributes are represented by

(A) rectangle.                                        (B) square.

(C) ellipse.                                            (D) triangle.

Q16.   In case of entity integrity, the primary key may be

(A) not Null                                            (B) Null

(C) both Null & not Null.                                     (D) any value.

Q17.   The language used in application programs to request data from the DBMS is referred

to as the

(A) DML                                                (B) DDL

(C) VDL                                                (D) SDL

Q18.   A logical schema

(A) is the entire database.

(B) is a standard way of organizing information into accessible parts.

(C) describes how data is actually stored on disk.

(D) both (A) and (C)

Q19.   Related fields in a database are grouped to form a

(A) data file.                                          (B) data record.

(C) menu.                                              (D) bank.

Q20. The database environment has all of the following components except:

(A) users.                                              (B) separate files.

(C) database.                                        (D) database administrator.