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:
(a)Tables
(b)Fields
(c)Records
(d)Keys
(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)
(c)Query
(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)
(c)Query
(d)Relational Schema
(e)None of the above
Q6.To remove a relation from an SQL database, we use the ______ command.
(a)Delete
(b)Purge
(c)Remove
(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?
(a)Relation
(b)Instance
(c)Table
(d)Column
(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
(a)Schema
(b)View
(c)Query
(d)Data dictionary
(e)None of the above
Q11. In E-R diagram generalization is represented by
(a)Ellipse
(b)Dashed ellipse
(c)Rectangle
(d)Triangle
(e)Diamond
Q12. In the __________ normal form, a composite attribute is converted to individual attributes.
(a)First
(b)Second
(c)Third
(d)Fourth
(e)Fifth
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:
(a)2NF
(b)3NF
(c)4NF
(d)5NF
(e)1NF
Q15.Which forms are based on the concept of functional dependency:
(a)1NF
(b)2NF
(c)3NF
(d)4NF
(e)5NF
