Advance DBMS 1000+ MCQ with answer for CTET

1. In a Hierarchical model records are organized as
A. Graph.
B. List.
C. Links.
D. Tree.
Answer : D

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

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

4. The syntax to select all column from the table is
A. select all from tablename
B. select * from tablename
C. select from tablename
D. none of these
Answer : B

5. A logical schema
A. is the entire database.
B. is a standard way of organizing information into accessible parts.
C. describes how data is actually stored on disk.
D. both A) and C)
Answer : A

6. B-Tree is used for
A. searching data
B. storing data
C. both A and B
D. none of these
Answer : A

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

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

9. Query processing is
A. converting data to insert in a database
B. translation of query to lower form
C. range of activities involved in extracting data from a database
D. none of the above
Answer : C

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

11. 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 : C

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. Noiseless channel has ……… types of protocols.
A. 2
B. 3
C. 4
D. 5
Answer : A

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

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

16. A data manipulation command the combines the records from one or more tables is called
A. SELECT
B. PROJECT
C. JOIN
D. PRODUCT
Answer : C

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

18. As a side-effect of database update ,the system automatically executes a statement called
A. a view
B. a grant permission
C. a trigger
D. all of the above
Answer : C

19. Select the correct statement
i) Aggregate functions work on a group of data and return a single value.
ii) ODBC connects the frontend with the database without considering its compatibility
iii) View definition cant be used at multiple places through with clause .
A. i and ii only
B. ii and iii only
C. i and iii only
D. i only
Answer : A

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

21. What is the max data capacity of STP?
A. 1 Gbps
B. 56 Mbps
C. 100 Mbps
D. 256 Mbps
Answer : C

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

23. Which of the following statements is not true about two tier clent 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

24. Which one of the following is provided by a data dictionary ?
A. User data
B. Database structure data
C. Sorted data
D. Functional data
Answer : B

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

26. Event condition action model is related to
A. Views
B. Cursors
C. Triggers
D. None of these.
Answer : C

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

28. The number of cursors depend on the
A. number of queries
B. number of attributes
C. size of memory area
D. none of these
Answer : C

29. Which of the following submit and execute query at run time?
A. Static SQL
B. Dynamic SQL
C. both
D. none of these
Answer : B

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

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

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

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

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

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

36. Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization
A. i and ii only
B. ii and iii only
C. i and iii only
D. All i, ii iii
Answer : D

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

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. which of the following is a binary operation?
A. project
B. select
C. rename
D. none of the above
Answer : D

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

41. The host part in a class A type of an IP address has
A. 12 bits
B. 16 bits
C. 24 bits
D. 28 bits
Answer : C

42. .................. is the loss of energy as the signal propagates outward, where the amount of energy depends on the frequency.
A. Noise
B. Delay distortion
C. Attenuation distortion
D. Dispersion
Answer : C

43. A ………… clause permits a view definition to be used in multiple places within a query.
A. where
B. exist
C. with
D. select
Answer : C

44. .................. means sending a digital signal over a channel without changing the digital signal to an analog signal.
A. Baseband transmission
B. Broadband transmission
C. Digital transmission
D. Analog transmission
Answer : A

45. In mesh topology, if the number of devices is n , then the number of ports present in each device is
A. n
B. n+1
C. n-1
D. n/2
Answer : C

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

48. Object based data models are used in describing the abstraction of the following levels?
A. Conceptual and view
B. Only physical
C. Physical and conceptual
D. Only conceptual
Answer : A

49. Which of the following produces the relation that has attributes of R1 and R2
A. Cartesian product
B. Difference
C. Intersection
D. Product
Answer : A

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