MCQ on DBMS with Answers doc – DBMS MCQ with Answers pdf for preparation MCA, BCA & IT academic and competitive examinations.
MCQ on DBMS with Answers
1. An Associative database has ___ fundamental data structures.
2. In the “Item” structure entries have a ___ identifier, a name and a type.
3. A relational database stores a minimum of a single ___ byte for missing data items in any given row.
4. A is a list of Chapters.
5. The combination of Chapters and Profiles can simplify the ___ of the database to particular users.
6. The concept of a ___ is missing from the Associative model.
5. Each entity has a single atomic value for the attribute is called ___ attribute.
6. Address is an example of ___ attribute.
7. The value for ___ type of attribute can be derived from the values of other related attributes or entities.
8. An attribute of an entity type for which each entity must have a unique value is called a ___ of the entity type.
Ans. key attribute
9. One of the following is a demerit of ER modelling.
a. Gives a higher-level abstraction of the system.
b. Can be generalized and specialized based on needs.
c. Physical design derived from the E-R Model may have some amount of ambiguities or inconsistency.
d. Intuitive and helps in physical database creation
Ans. Physical design derived from the E-R Model may have some amount of ambiguities or inconsistency.
10. How many basics are there in the E-R data model?
11. An ___ is a “thing” or object in the real world that is distinguishable from all other objects.
d. Simple attribute
12. Pick out the composite attribute from the list of attributes
d. Department number
13. “Color of the car and degrees of students” are examples for the ___
a. Null attribute
b. Derived attribute
c. Single valued
14. Identifying the natural relationship and their cardinalities between the entities is a step of ___.
a. Identify the entities
b. Find relationships
c. Identify the key attributes for every entity
d. Identify other relevant attributes
Ans. Find relationships
15. ER diagram includes a graphical notation, which depicts entity classes as ___.
a. Rectangles b. Ovals c. Diamonds d. Circles
16. A ___ is an association among several entities.
a. Relationship b. Key c. Partial key d. Entity
17. An entity that does not have a key attribute is called
a. Weak entity types
b. Entity Types
c. Null attribute
d. Derived attribute Database Management
Ans. Week-entity types
18. The is the fastest and most costly form of storage.
19. In the __ architecture, large numbers of disks are connected by a high-speed network to a number of server computers.
Ans. storage area network (SAN)
20. ___ time is the time from when a read or write request is issued to when data transfer begins.
21. The ___ is the average of the seek times, measured over a sequence of (uniformly distributed) random requests.
Ans. average seek time
22. A ___ is a contiguous sequence of sectors from a single track of one platter.
23. A commonly used algorithm in scheduling is ___.
Ans. elevator algorithm
24. The primary medium for the long-term on-line storage of data is the ___.
Ans. magnetic disk
25. The CD and DVD come under ___ memory storage.
26. Tape storage is referred to as ___ access storage.
27. Each disk platter has a flat ___ shape.
28. A ___ interfaces between the computer system and the actual hardware of the disk drive.
Ans. disk controller
29. The contents of the main memory are usually if a power failure or system crash occurs.
30. Flash memory differs from main memory in that data survive ___.
Ans. Power failure
31. A relation consists of a ___ and a relation instance.
Ans. relation schema
32. An instance of a relation is a set of tuples, also called.
33. Relation instance means relation instance that satisfies the ___ in the relation schema.
Ans. domain constraints
34. A is a basic storage structure of an RDBMS and consists of columns and rows.
35. A Row is a combination of column values in a table and is identified by a ___ key.
36. A ___ is an intersection of a row and a column.
37. ___ consists of a collection of objects or relations that store data.
38. Operations are used to ___ data and structures in a database.
39. Integrity Rules ensures data accuracy and ___.
40. ___ is the International Standards Organization (ISO) standard language for interacting with an RDBMS.
41. The basic unit of ___ in a relational database is called a table.
Ans. data storage
42. A combines data from separate database rows.
43. An RDBMS enables data between users.
44. An RDBMS minimizes the data.
45. A degree of a student is a valued attribute.
46. The uniquely differentiates one entity instance from all others in the entity.
47. A Concatenated Key is made up of parts that, when combined, become a ___ identifier.
48. The goal of a query optimizer is to find a good evaluation plan for a given ___.
49. Optimizing a relational algebra expression involves ___ basic steps.
50. The catalog relations are also called the catalog.
51. SQL commands can be roughly divided into ___ major categories with regard to their functionality.
52. To construct and administer the database there are ___ major DDL statements.
53. To manipulate data in tables directly or through views, we use the four standard ___ statements.
54. ___ is concerned with the manner in which multiple users operate upon the database.
55. A ___ of a relationship can be created which hides the sensitive information and defines only that part of a relationship that should be visible.
57. In a catalog related to view, the information storages are view name and.
58. Index ___ means the Number of distinct key values NKeys(I) for each index I.
59. Data definition in SQL is via the ___ statement.
60. The data types supported by SQL depend on the particular ___.
61. The definition of an existing relationship can be altered by using the ___ statement.
62. An existing relation or index could be deleted from the database by the ___ SQL statement.
63. SELECT does not eliminate ___ rows.
64. The use of ___ gives the range within which the values must lie.
65. Like predicate is used for pattern.
66. Subqueries can appear when using the ___ predicate, the IN predicate and when quantifiers are used
67. ANY stands for the existential quantifier and ALL for the ___ quantifier.
68. There are ___ built-in functions in SQL.
69. In SQL function has a special meaning in that it counts the number of rows of a relation.
70. When columns are to be modified ___ clause is used.
71. Data manipulation capabilities allow one to ___ and modify the contents of the database.
72. The statement specifies the method of selecting the tuples of the relations(s).
73. If the structure of the database changes, the user’s view of the data ___
Ans. can remain the same.
74. The view must not have a clause.
75. The base relations on which a view is based are sometimes called the relations.
Thanks for your visit to our website, please share the post MCQ on DBMS with Answers doc on social media.