Exercise : Database Management System MCQ Questions and Answers
Question 1
Literals in java must be preceded by which of these?
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. Both L and I
Description :
Data type long literals are appended by an upper or lowercase L.
View Answer
50/50
Workspace
Report
Discuss
Question 2
The decision tree classifier is a widely used technique for ______.
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. Classification
Description :
Decision Tree Classifier is a simple and widely used classification technique. It applies a straightforward idea to solve the classification problem. Decision Tree Classifier poses a series of carefully crafted questions about the attributes of the test record. Each time time it receive an answer, a follow-up question is asked until a conclusion about the class label of the record is reached.
Question 3
Using which language can a user request information from a database ?
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. Query
Description :
Query
Query language is a method through which the database entries can be accessed.
Question 4
A deadlock exists in the system if and only if the wait-for graph contains a ___________.
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. Cycle
Description :
Each transaction involved in the cycle is said to be deadlocked.
Question 5
This set of Database Questions & Answers focuses on “SQL Data Types and Schemas” Dates must be specified in the format
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. yyyy/mm/dd
Description :
yyyy/mm/dd is the default format in sql
Question 6
Which one of the following attribute can be taken as a primary key ?
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. Id
Description :
The attributes name , street and department can repeat for some tuples.But the id attribute has to be unique .So it forms a primary key.
Question 7
The distinguishable parts of a record are called
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. fields
Description :
No answer description available for this question. Let us discuss.
Question 8
A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. Schema diagram
Description :
No answer description available for this question. Let us discuss.
Question 9
______ will undo all statements up to commit?
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. Rollback
Description :
Rollback
Flashback will undo all the statements and Abort will terminate the operation.
Question 10
Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database ?
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. DML(Data Manipulation Langauge)
Description :
DML(Data Manipulation Langauge)
DML performs change in the values of the relation .