IBPS Clerk - Advance DBMS 1000+ MCQ [Solved] PDF Download

1. It is possible to define a schema completely using
A. VDL and DDL.
B. DDL and DML.
C. SDL and DDL.
D. VDL and DML.
Answer : B

2. Which of the following extracts its data from the result of an SQL SELECT statement.
A. View
B. Synonym
C. Sequence
D. Transaction
Answer : A

3. Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel
A. i only
B. ii only
C. Both
D. None of these
Answer : B

4. When all attributes in a relation tuple are not functionally dependent only on the key attribute. Which of the following normalization is needed?
A. first
B. second
C. third
D. fourth
Answer : C

5. In E-R Diagram weak entity set are represented by
A. Ellipse
B. Dashed ellipse
C. Dashed Rectangle
D. Doubled Rectangle
Answer : D

6. The command used to delete a particular column in a relation
A. UPDATE
B. DROP
C. ALTER
D. DELETE
Answer : C

7. The physical location of a record is determined by a mathematical formula that transforms
a file key into a record location is :
A. B-Tree File
B. Hashed File
C. Indexed File
D. Sequential file.
Answer : B

8. View never contains derived columns.
A. True
B. False
C. Cant say
D. none
Answer : A

9. DECLARE is a(an)
A. executable statement.
B. declarative statement.
C. Ordered file
D. none of the above
Answer : B

10. In this data model each record can hae more than one parent
A. Hierarchical model
B. E-R model
C. Network based model
D. none of these
Answer : C

11. In two-phase locking
A. the data items are locked in growing phase.
B. the data items are released in shrinking phase.
C. Both A and B are true
D. Both A and B are false
Answer : C

12. Noiseless channel has ……… types of protocols.
A. 2
B. 3
C. 4
D. 5
Answer : A

13. The collection of information stored in a database at a particular moment is?
A. View
B. Instance
C. Scheme
D. None of these
Answer : B

14. Which of the following is not a constraint on a single relation?
A. check
B. unique
C. not null
D. is duplicate
Answer : D

15. UML is stands for
A. Universal Modeling Language
B. Unified Modeling Language
C. United Modeling Language
D. Uni Modeling Language
Answer : B

16. The mode in which data item may be locked
A. Partner
B. Mutual
C. Exclusive
D. Atomic
Answer : C

17. In the architecture of a database system external level is the
A. physical level.
B. logical level.
C. conceptual level
D. view level.
Answer : D

18. Natural mask for a Class A network
A. 255.0.0.0
B. 255.255.0.0
C. 255.255.255.0
D. none of these
Answer : A

19. The left outer join takes all tuples
A. in the left relation which didnt match with any tuple in right relation
B. in the left relation which matched with a tuple in right relation
C. in the right relation which didnt match with any tuple in left relation
D. in the right relation which matched with a tuple in left relation
Answer : A

20. .................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.
A. Noise
B. Delay distortion
C. Attenuation distortion
D. Dispersion
Answer : B

21. The minimal set of super key is called
A. Primary key
B. Secondary key
C. Candidate key
D. Foreign key
Answer : C

22. Specialization is a
A. top-down approach.
B. bottom-up approach.
C. left-right approach.
D. none of the above
Answer : A

23. A data dictionary contains:
i) The name of all fields in all files.
ii) The data type of all fields in all files.
iii) The width of all fields in all files.
A. only i)
B. only i) and ii)
C. only ii) and iii)
D. i) ii) iii)
Answer : D

24. DBMS helps achieve
A. Data independence
B. Centralized control of data
C. Neither A) nor B)
D. both A) and B)
Answer : D