#2
| |||
| |||
Re: DBMS For SBI SO
Ok, here I am providing you the sample questions of Data Base Management Systems (DBMS) for SBI Specialist officer exam. SBI SO exam DBMS Sample questions 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 For more questions here is the attachment |
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
UPTU DBMS Question Paper | Unregistered | Main Forum | 1 | 12th November 2016 12:48 PM |
DBMS for SBI Specialist Officer | Unregistered | Main Forum | 1 | 26th October 2016 05:03 PM |
DBMS Lab KSOU | Unregistered | Main Forum | 1 | 27th September 2016 03:02 PM |
Mumbai University DBMS Lab Manual | Unregistered | Main Forum | 1 | 16th November 2015 01:53 PM |
DBMS Notes MDU | Unregistered | Main Forum | 0 | 17th July 2015 11:21 AM |
DBMS University Question Paper with Answers | Unregistered | Main Forum | 0 | 17th July 2015 10:12 AM |
DBMS Study Material for IBPS IT Officer | Unregistered | Main Forum | 0 | 13th July 2015 09:26 AM |
RTU DBMS syllabus | Unregistered | Main Forum | 0 | 10th July 2015 05:13 PM |
DBMS lab manual for Anna university | Unregistered | Main Forum | 0 | 10th July 2015 03:19 PM |
DBMS Notes MBA PDF MBA Notes Derivatives | rajnish barusa | Main Forum | 1 | 12th March 2013 12:46 PM |
DBMS Anna university syllabus | summit thakur.e | Main Forum | 1 | 29th September 2012 11:01 AM |
VTU Lab Programs DBMS | navid khan | Main Forum | 1 | 10th August 2012 01:39 PM |
|