SBI IT OFFICER - Professional Knowledge Quiz

Dear Readers,

In view of the upcoming SBI IT Officer Examination, we have decided to provide you all a daily quiz on Professional Knowledge. Hope the post provides to be a fruitful for you all and hope you succeed in the upcoming exams!!!

Ques. 1 It is possible to define a schema completely using 

(A) VDL and DDL. 

(B) DDL and DML. 

(C) SDL and DDL.

(D) VDL and DML

Ques. 2 Which of the following is a valid SQL type? 

(A) CHARACTER 

(B) NUMERIC 

(C) FLOAT 

(D) All of the above 

Ques. 3 The RDBMS terminology for a row is 

(A) tuple. 

(B) relation. 

(C) attribute. 

(D) degree. 

Ques. 4 Which of the following operations need the participating relations to be union compatible? 

(A) UNION 

(B) INTERSECTION 

(C) DIFFERENCE

(D) All of the above

Ques. 5 The full form of DDL is 

(A) Dynamic Data Language 

(B) Detailed Data Language 

(C) Data Definition Language 

(D) Data Derivation Language

ANS C

Ques. 6 Which of the following is an advantage of view? 

(A) Data security 

(B) Derived columns 

(C) Hiding of complex queries 

(D) All of the above 

Ques. 7 A set of possible data values is called 

(A) attribute 

(B) degree 

(C) tuple

(D) domain. 

Ques. 8 Which of the operations constitute a basic set of operations for manipulating relational 

data? 

(A) Predicate calculus 

(B) Relational calculus 

(C) Relational algebra 

(D) None of the above 

Ques. 9 Which of the following is another name for weak entity? 

(A) Child 

(B) Owner 

(C) Dominant 

(D) All of the above 

Ques. 10 Which of the following database object does not physically exist? 

(A) base table 

(B) index 

(C) view 

(D) none of the above 

ANSWERS:

Ans 1 : B

Ans 2 : D 

Ans 3 : A 

Ans 4 : D

Ans 5 : D

Ans 6 : D

Ans 7 : D

Ans 8 : C

Ans 9 : A

Ans 10: C