NDA - Advance DBMS 1000+ MCQ [Solved] PDF Download

1. Cross Product is a:
A. Unary Operator
B. Binary Operator
C. Ternary Operator
D. none of the above
Answer : B

2. ............... noise is caused by the random motion of the electrons in a wire and is avoidable.
A. Thermal
B. Intermodulation
C. Cross talk
D. Impulse
Answer : A

3. Triggers are also called
A. active rules
B. passive rules
C. inferences
D. none of the above
Answer : A

4. In RDBMS, Data is presented as a collection of
A. Relation
B. Table
C. Attribute
D. Entity
Answer : A

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

6. 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

7. Select the incorrect statement(s)
i) Shared locks are compatible with each other.
ii) A relation which is in 3NF may have redundancy due to composite keys.
iii) A table in a database can have multiple indexes.
A. i only
B. ii, only
C. ii, iii only
D. none of the above
Answer : D

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

9. In defining the notion of the tuple variable, which one of the clause is useful?
A. as
B. by
C. from
D. none of the above
Answer : A

10. The statement in SQL which allows to change the definition of a table is
A. Select
B. Update
C. Create
D. Alter
Answer : D

11. Which of the following is the unit of signaling speed or modulation rate or the rate of symbol transmission?
A. Data rate
B. Bit rate
C. Signal to Noise Ratio
D. Baud rate
Answer : D

12. Which of the following statement returns data to the host variables one at a time?
A. SELECT
B. RETURN
C. FETCH
D. GET
Answer : C

13. Which of the following concurrency control schemes is not based on serializability property?
A. Two-phase locking
B. Timestamped based locking
C. Graph-based locking
D. none of the above
Answer : C

14. State which of the following statements are True
i) TCP is connection oriented but unreliable
ii) UDP is connection oriented but unreliable
iii) TCP is connectionless but reliable
iv) UDP is connectionless but reliable
A. i and ii only
B. ii and iii only
C. i and iii only
D. None of these
Answer : D

15. Which of the following is not proper state of transaction ?
A. Partially aborted
B. Partially committed
C. Aborted
D. Committed
Answer : A

16. Which of the following will NOT eliminates the ambiguities of a null value?
A. Define the attribute as required
B. Define subtypes
C. Define each attribute as having an initial value that is recognized as blank
D. Define supertypes
Answer : D

17. Select the incorrect statement
A. BCNF is stronger than 3NF
B. Relational algebra is a non-procedural language
C. Every conflict serializable schedule is view serializable.
D. none of the above
Answer : B

18. The raw facts and figures are:
A. Data
B. Data field
C. DBMS
D. DBASE
Answer : A

19. Which of the following is also known as Offline storage ?
A. primary storage
B. secondary storage
C. tertiary storage
D. none of the above
Answer : B

20. File organization that provides fast access to any arbitrary record
A. Hashed file
B. B-tree
C. Ordered file
D. Unordered file
Answer : A

21. Expand the acronym OLAP
A. Object Linked Access Program
B. Organizational Architecture Processing
C. Online Analytical Processing
D. none of these
Answer : C

22. Three SQL, DDL, CREATE commands are
A. Schema, Base and Table
B. Schema, Table and View
C. Base, Table and Schema
D. Key, Base and Table
Answer : B

23. A transaction which may not complete its execution successfully is termed as
A. Failed
B. Aborted
C. Blocked
D. Finished
Answer : B

24. In an Entity-Relationship Diagram Diamonds represents
A. Attributes
B. Multi-valued attributes
C. Wea entity set
D. Relationship sets
Answer : D

25. Which of the following layer uses trailer of the frame for error detection?
A. Transport layer
B. Network layer
C. Datalink layer
D. None of these
Answer : C

26. A type of query that is placed within a WHERE or HAVING clause of another query is called
A. Super query
B. Sub query
C. Master query
D. Multi-query
Answer : B

27. Which of the following file organization provides very fast access to any arbitrary record of a file?
A. Ordered file
B. Unordered file
C. Hashed file
D. B-tree
Answer : C

28. A transaction has following states
i) Active
ii) Fail
iii) Abort
iv) Commit
A. i and ii only
B. ii and iii only
C. i and iii only
D. iii and iv only
Answer : D

29. Related fields in a database are grouped to form a
A. data file.
B. data record.
C. menu.
D. bank.
Answer : B

30. Which of the following are the properties of entities?
A. Groups
B. Table
C. Attributes
D. Switchboards
Answer : C

31. 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

32. A …………… is a memory area where data are processed.
A. view
B. trigger
C. cursor
D. none of the above
Answer : C

33. Data Manipulation Language DML) is not to
A. Create information table in the Database
B. Insertion of new information into the Database
C. Deletion of information in the Database
D. Modification of information in the Database
Answer : A

34. What does a field or a combination of fields that has a unique value called ?
A. Foreign key
B. Secondary key
C. Primary key
D. Alternate key
Answer : C

35. 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

36. The union of primary keys of a related entity becomes …………. Of a relation.
A. primarykey
B. superkey
C. candidatekey
D. foreignkey
Answer : B

37. Noisy channel has ……… .. types of protocols
A. two
B. three
C. four
D. none
Answer : B

38. Volatile storage
A. loses its contents when power is switched off.
B. doesnt loses its contents when power is switched off.
C. creates backup when power is switched off.
D. none
Answer : A

39. Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.
A. Gray
B. White
C. Blue
D. Black
Answer : B

40. Tertiary storage
A. magnetic tape
B. juke box
C. optical disk
D. All of the above
Answer : D

41. Range variables are designed using the
A. TO clause
B. FROM clause
C. RANGE clause
D. none of the above
Answer : C

42. The output of the Data Definition Language is stored in the
A. view table
B. schema
C. metadata
D. all of the above.
Answer : C

43. A DBMS query language is designed to
A. support end users who use English-like commands.
B. support in the development of complex applications software.
C. specify the structure of a database.
D. all of the above.
Answer : D

44. The ________ states that a foreign key must either match a primary key value in another relation or it must be null.
A. entity integrity rule
B. referential integrity constraint
C. composite attribute
D. action assertion
Answer : A

45. A relation is said to be in ………. If it doesnt contain partial dependency
A. 1NF
B. 2NF
C. 3NF
D. BCNF
Answer : B

46. Every Boyce-Codd normal form is in
A. 3NF
B. 2NF
C. 1NF
D. none of the above
Answer : D

47. RAID
A. Redundant Arrays of Independent Disks
B. Redundant Arrays of Independent Drives
C. Redundant Arrays of Interconnected Drives
D. Redundant Arrays of Interconnected Disks
Answer : A

48. In which of the following SET concept is used ?
A. Network Model
B. Hierarchical Model
C. Relational Model
D. None of these
Answer : A