DBMS Quiz for SBI Specialist Officer Exam

Hii Readers..In this post we will post some important DBMS questions which are very important for the preparation of the SBI Specialist Officer Exam.There will be around 20 questions from DBMS.

DBMS Quiz for SBI Specialist Officer Exam

1.Boye Codd Normal Form (BCNF) is needed when :
a)Two non key attributes are independent.
b)There is more than one possible composite key.
c)The are two or more possible composite overlapping keys and one attribute of composite key is dependent on an attribute of another composite key.
d)There are two possible keys and they are dependent on one other.

2.What in a Distributed Database supports Multi-user access ?
a)Distribution Design
b)Concurrency Control
c)Replication
d)Redundancy

3.The values for an attribute or a column are drawn from a set of values known as a :
a)Tuples
b)Attributes
c)Domain
d)All of these

4.The Tuple is Equivalent to :
a)row
b)Column
c)field
d)file

5.The Language uses applications programs to request data from the DBMS is reffered to as the ?
a)DML
b)DDL
c)Query Languange
d)None of these

6.Which of the following SQL statement is used to delete a column from a table ?
a)DELETE column-name from table name
b)ALTER TABLE table name DROP COLUMN column name
c)DROP Column name FROM table name
d)None of These

7.In SQL,Which command is used to recompile a view ?
a)COMPILE VIEW
b)DEFINE VIEW
c)CREATE VIEW
d)ALTER VIEW

8.DBMS are intended to :
a)Eliminate Data Redundancy
b)Establish Relationships among records in different files
c)Manage file access
d)Maintain data Interity of the above

9.When you drop a …………corresponding indexes are also dropped ?
a)Column
b)Sequence
c)View
d)Table

10.A……………Database does not use the pointers or physical links ,but instead finds related records by examining the contents of fields :
a)Network
b)Hierarchical
c)Relational
d)Object Oriented

KEY:

1.c
2.b
3.c
4.a
5.a
6.b
7.a
8.c
9.b
10.a

So this is all about DBMS Quiz for SBI Specialist Officer Exam .Please share your experience regarding our site,if u have any suggestions or complaints comment below and subscribe us with your email-id and like our facebook page to be updated withsscjunction.com . Thank You!