Tuesday, 24 November 2015

IBPS Specialist IT Officer Exam MCQs [DBMS] Quiz – 42

1. A command that lets you change one or more fields of  a record is ?
(a) insert
(b) Modify
(c) Look-up
(d) All of above

2. In a large DBMS  ?
(a) Each user can see only a small part of the entire database
(b) Each user can access every sub schema
(c) Each sub schema contains every field in the logical schema
(d) All of above

3. A trigger is ?
(a) A statement that enables to start any DBMS
(b) A statement that is executed by the user when debugging an application program
(c) A condition the system tests for the validity of the database user
(d) A statement that is executed automatically by the system as a side effect of modification to the database

4.  Manager’s salary details are hidden from the employee. This is ?
(a) Conceptual level data hiding
(b) Physical level data hiding
(c) Externel level hiding
(d) None of above

5. The compiled form of the definition is known as  ?
(a) Data Dictionary
(b) Directory
(c) System catalog
(d) All of above

6. Once a sequence is created, it is documented in the ?
(a) Database
(b) Datatable
(c) Data Dictionary
(d) Data Document

7. The online soft copy display a customer’s charge account to respond to an inquiry is an example of  ?
(a) forecasting report
(b) exception report
(c) regularly scheduled report
(d) on demand report

8. In order to understand DBMS, it is important to understand?
(a) the physical schema
(b) all sub schema that are system support
(c) one sub schema
(d) Both A and B

9. The user defined data type can be created using
(a) Create datatype
(b) Create data
(c) Create definetype
(d) Create type

10. Values of one type can be converted to another domain using which of the following ?
(a) Cast
(b) Drop type
(c) Alter type
(d) Convert

11. Which of the following closely resembles Create view ?
(a) Create table . . .like
(b) Create table . . . as
(c) With data
(d) Create view as

12. A deadlock exists in the system if and only if the wait-for graph contains a ___________.
(a) Cycle
(b) Direction
(c) Bi-direction
(d) Rotation

13.  __________ rollback requires the system to maintain additional information about the state of all the running transactions.
(a) Total
(b) Partial
(c) Time
(d) Commit

14. Which one of the following cannot be taken as a primary key ?
(a) Id
(b) Register number
(c) Dept_id
(d) Street

15. A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .
(a) Candidate
(b) Primary
(c) Super
(d) Sub

16. The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as primary key is called
(a) Referential relation
(b) Referencing relation
(c) Referenced relation
(d) Referred relation

17. The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation .
(a) Referential relation
(b) Referencing relation
(c) Referenced relation
(d) Referred relation

18. A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
(a) Referential
(b) Referencing
(c) Specific
(d) Primary

19. Literals in java must be preceded by which of these?
(a) L
(b) l
(c) D
(d) both a & b

20. Literal can be of which of these data types?
(a) integer
(b) float
(c) boolean
(d) all of the mentioned

Also read:


  1. thnks but can u give me further dbms qistikns

  2. thnks but can u give me further dbms qistikns

  3. thank arpan, we are updating more dbms mcqs. tuned with team mm.