Database Management System - DBMS Objective Question and Answer
Database Management System - DBMS MCQ Multiple Choice Questions - Page 3 for Practice
Database Management System - DBMS MCQ Questions for Practice
61. What is used to retrieve tuples from the relation.
Correct Answer is: Select
62. To select all column from the table the syntax is:
Correct Answer is: Select * from table_name
63. To select all columns from the table the syntax is:
Correct Answer is: Select * from table_name
64. The SQL statement to create a view is:
Correct Answer is: CREATE VIEW
65. System analyst and application programmers are commonly referred to as …………………….
Correct Answer is: Software engineers
66. Which are the not user in End-user:
Correct Answer is: All of these
67. Who access the database occasionally and have different needs each time:
Correct Answer is: Casual users
68. Who interact with the system by invoking one of the permanent application program:
Correct Answer is: Naïve users
69. Who interact with the system without writing a program:
Correct Answer is: Sophisticated user
70. …………………… is the process of organizing data into related tables.
Correct Answer is: Normalization
71. ………………… is a full form of SQL.
Correct Answer is: Structured query language
72. FDs are the types of constraints that are based on………………
Correct Answer is: Key
73. ……………… table store information about database or about the system.
Correct Answer is: System
74. What is a virtual table
Correct Answer is: View
75. SQL outputs a single table known as the………………
Correct Answer is: Result set
76. What SQL structure is used to limit column values of a table?
Correct Answer is: The CHECK constraint
77. A ................. normal form, normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.
Correct Answer is: Third
78. A .................normal form, normalization will be needed where all attributes in a relation are not functionally dependent only on the key attribute.
Correct Answer is: Third
79. In the ..........normal form, a composite attribute is converted to individual attributes.
Correct Answer is: First
80. In the.......... Normal form, a composite attribute is converted to individual attributes.
Correct Answer is: First
81. Which one is based on multi-valued dependency:
Correct Answer is: Fourth
82. In decomposition technique of splitting a relation into ……………… relation:
Correct Answer is: TWO or MORE
83. ………………… is preferred method for enforcing data integrity
Correct Answer is: Constraints
84. Which are the dependencies types:
Correct Answer is: All of these
85. The number of entities associated in relationship is called as its.....................
Correct Answer is: Degree
86. A relation is considered a:
Correct Answer is: Two dimensional table
87. Identify the criteria for designing database from the point of view of user
Correct Answer is: All of the above
88. Identify the criteria for designing database from the point of view of user
Correct Answer is: All of the above
89. The ........... operator preserves unmatched rows of the relations being joine
