SQL Objective Type Question & Answers For Interview

Q.1An 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.
Ans: B

Q.2 Errors occur more often when
a. data is entered by users
b. data is entered by operators
c. when data is handwritten by users and entered by an operator
d. the key board design is bad
Ans: c

Q.3 In an E-R diagram attributes are represented by
(A) rectangle. (B) square.
(C) ellipse. (D) triangle.
Ans: C

Q.4 In on-line data entry it is possible to
a. Give immediate feedback if incorrect data is entered
b. Eliminate all errors
c. Save data entry operators time
d. Eliminate forms
Ans: a

Q.5 In case of entity integrity, the primary key may be
(A) not Null (B) Null
(C) both Null & not Null. (D) any value.
Ans: A

Q.6 In interactive data input a menu is used to
a. enter new data
b. add/delete data
c. select one out of many alternatives often by a mouse click
d. detect errors in data input
Ans: c
Q.7 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
Ans: A

Q8  In interactive data input a template is normally used to
a. enter new data
b. add/delete data
c. select one out of many alternatives often by a mouse click
d. detect errors in data input
Ans: a
Q.9 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)
Ans: A
Q.10 Related fields in a database are grouped to form a
(A) data file. (B) data record.
(C) menu. (D) bank.
Ans: B Related data fields in a database are grouped to form a data record.
(A record is a collection of related fields)
Q.11 The database environment has all of the following components except:
(A) users. (B) separate files.
(C) database. (D) database administrator.
Ans: A