Professional Knowledge Quiz for IBPS SO IT Officer 2017

Q1.A banking system consist of user accounts, money transfers, withdrawal, deposits, etc. These all represent tables or entities that can be manipulated with SQL. What is full form of SQL?
(a)Shortcut query language
(b)Structured query language
(c)Simple query language
(d)Sorted query language
(e)None of the above

Q2.A relational database consists of a collection of:
(e)None of the above

Q3.OLAP stands for:
(a)Online analytical processing
(b)Online analysis processing
(c)Online transaction processing
(d)Online aggregate processing
(e)None of the above

Q4.Which one of the following is used to define the structure of the relation ,deleting relations and relating schemas ?
(a)DML(Data Manipulation Langauge)
(b)DDL(Data Definition Langauge)
(d)Relational Schema
(e)None of the above

Q5.Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database ?
(a)DML(Data Manipulation Langauge)
(b)DDL(Data Definition Langauge)
(d)Relational Schema
(e)None of the above

Q6.To remove a relation from an SQL database, we use the ______ command.
(d)Drop table
(e)None of the above

Q7.What term is used to refer to a specific record in your music database; for instance; information stored about a specific album?
(e)None of the above

Q8.An entity set that does not have sufficient attributes to form a primary key is termed a __________ .
(a)Strong entity set
(b)Variant set
(c)Weak entity set
(d)Variable set
(e)None of the above

Q9.Which of the following gives a logical structure of the database graphically ?
(a)Entity-relationship diagram
(b)Entity diagram
(c)Database diagram
(d)Architectural representation
(e)None of the above

Q10.A window into a portion of a database is
(d)Data dictionary
(e)None of the above

Q11. In E-R diagram generalization is represented by
(b)Dashed ellipse

Q12. In the __________ normal form, a composite attribute is converted to individual attributes.

Q13. Tables in second normal form (2NF):
(a)Eliminate all hidden dependencies
(b)Eliminate the possibility of a insertion anomalies
(c)Have a composite key
(d)Have all non key fields depend on the whole primary key
(e)All of the above

Q14. Which form has a relation that possesses data about an individual entity:

Q15.Which forms are based on the concept of functional dependency: