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

1. Data stored in cursor is called ……………
A. record
B. active data set
C. object
D. none of the above
Answer : B

2. The privilege lists include
i) select
ii) insert
iii) update
iv) delete
A. only i)
B. only i) ii)
C. only i) ii) iii)
D. i) ii) iii) iv)
Answer : D

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

4. In case of entity integrity, the primary key may be
A. not Null
B. Null
C. both Null & not Null.
D. any value.
Answer : A

5. The race condition occurs when
A. Two concurrent processes attempt to interact with each other.
B. Two concurrent processes interact with different data files.
C. Two concurrent processes attempt to hold a data item .
D. none of the above.
Answer : C

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

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

8. In an Entity-Relationship Diagram Ellipses represents
A. Attributes
B. Weak entity set
C. Relationship sets
D. Multi-valued attributes
Answer : A

9. FDDI protocol operates in
i) Transport layer
ii) Network layer
iii) Datalink layer
iv) Physical layer
A. i and ii only
B. ii and iii only
C. i and iii only
D. iii and iv only
Answer : D

10. A relation which is in 3NF is
A. in 1NF also
B. in 2NF also
C. free from transitive dependencies
D. All of these
Answer : D

11. Functional dependencies are generalization of
A. Relation dependencies
B. Data dependencies
C. key dependencies
D. none of the above
Answer : A

12. A functional dependency between two or more non-key attributes is called
A. Transitive dependency
B. Partial transitive dependency
C. Functional dependency
D. Partial functional dependency
Answer : A

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

14. What are the different types of radio waves that are used for computer network applications?
i) Spread spectrum
ii) High power, single frequency
iii) High power, multiple frequency
iv) Low power, single frequency
v) Low power, multiple frequency
A. i, ii and iii only
B. i, ii and iv only
C. ii, iii and iv only
D. i, iii and iv only
Answer : B

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

16. The physical path over which a message travels
A. Thermal
B. Medium
C. Protocol
D. Impulse
Answer : B

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

18. Repeaters operate in
i) Physical layer
ii) Datalink layer
iii) Transport layer
iv) Network layer
A. i and ii only
B. ii and iii only
C. ii only
D. i only
Answer : D

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

20. Which of the following operator preserves unmatched rows of the relations being joined?
A. Inner join
B. Outer join
C. union
D. Intersect
Answer : B

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

22. Which of the following aggregate function doesnt ignore NULLs in its results?
A. COUNT
B. COUNT(*)
C. MAX
D. none of these
Answer : B

23. Secondary storage
A. magnetic disk
B. magnetic tape
C. juke box
D. cache Answer : A

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

25. Select the correct
i) A timestamp-based scheduler cant produce live lock
ii) Aggregate functions cant appear with HAVING clause.
iii) Isolation is a property of database transaction.
A. i and ii only
B. ii and iii only
C. i and iii only
D. i only
Answer : C

26. The transaction consists of all statements executed between
A. the begin transaction and end transaction
B. the start transaction and end transaction
C. the begin transaction and finish transaction
D. none of the above.
Answer : A

27. Full form of CIDR
A. Classful Inter Domain Routing
B. Classless International Domain Routing
C. Classless Inter Domain Routing
D. none of these
Answer : C

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

29. The ability to modify the conceptual schema without causing any change to the application program is known as
A. Physical data independence
B. Logical data independence
C. External data independence
D. Static data
Answer : B

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

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

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

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

34. Which of the following Key is used to represent relationship between the tables?
A. Primary key
B. Secondary Key
C. Foreign Key
D. None of these
Answer : C

35. An operation that will increase the length of a list is
A. insert
B. modify
C. lookup
D. none of the above
Answer : A

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

37. Which of the following statements is not true about two tier client server database architecture?
A. SQL statements are processed on tier server
B. SQL statements may be processed on some of the clients
C. Business logic is mostly processed on clients
D. Business logic may be processed on the server
Answer : C

38. The types of noiseless channels are
i) Selective Reject ARQ
ii) simplest protocol
iii) Go-Back-N ARQ
iv) Stop-and-Wait Protocol
A. i, ii only
B. ii and iv only
C. ii and iv only
D. i, iv only
Answer : C

39. Only one communication channel is needed rather than n channels to transmit data between two communicating devices
A. parallel
B. serial
C. analog
D. digital
Answer : B

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

41. The overall design of a database is called
A. Subschema of the database
B. Schema of the database
C. Structure of the database
D. View of the database
Answer : B

42. which of the following is a binary operation?
A. project
B. select
C. rename
D. none of the above
Answer : D

43. The maximum number of children in a B-tree of order m is
A. m+1
B. m
C. m-1
D. m/2
Answer : B

44. Count function in SQL returns the number of
A. values.
B. distinct values.
C. groups.
D. columns.
Answer : A

45. Unwanted energy from source other than the transmitter.
A. Attenuation
B. Distortion
C. Delay
D. Noise
Answer : D

46. In which of the following transmissions, we can send data by grouping n bits at a time instead of a single bit?
A. parallel
B. serial
C. analog
D. digital
Answer : A

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

48. Which of the following is not a database object?
A. index
B. sequence
C. cursor
D. trigger
Answer : C

49. Transaction access data using two operations
A. read(), print()
B. read(), write()
C. scan(), write()
D. none of the above
Answer : B

50. The statement
Every foreign-key value must match a primary-key value in an associated table
Is related to
A. View
B. Cursor defination
C. Referential intergrity
D. Trigger
Answer : C