Practice Dbms Multiple Choice Questions with Answers Quiz-1

Q.1.

Which of the following levels is considered as the level closed to the end-users?

Internal Level
External Level
Conceptual Level
Physical Level

Q.2.

Which one of the following command is used to delete the existing row in a table?

Delete
Update
Insert
None of the above

Q.3.

A DBMS makes it possible for users to:-

CREATE
UPDATE
DELETE
ALL THE ABOVE

Q.4.

SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes)

DELETE FROM table_name;
DELETE TABLE table_name;
DROP TABLE table_name;
None

Q.5.

The term "Data independence" refers to____

Data is defined separately and not included in the programs
Programs are not dependent on the logical attributes of the data
Programs are not dependent on the physical attributes of the data
Both B & C

Q.6.

The term "SQL" stands for

Standard query language
Sequential query language
Structured query language
Server-side query language

Q.7.

Which of the following refers collection of the information stored in a database at a specific time?

Independence
Instance of the database
Schema
Data domain

Q.8.

The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

Where, from
From, select
Select, from
From, where

Q.9.

Which one of the following commands is used to restore the database to the last committed state?

Save point
Rollback
Commit
Both A & B

Q.10.

For what purpose the DML is provided?

Addition of new structure in the database
Manipulation & processing of the database
Definition of the physical structure of the database system
All of the above

Q.11.

Which of the following commands is used to save any transaction permanently into the database?

Commit
Rollback
Save point
None of the above

Q.12.

Which one of the following refers to the total view of the database content?

Conceptual view
Physical view
Internal view
External view

Q.13.

The Database Management Query language is generally designed for the _____

Support end-users who use English like commands
Specifying the structure of the database
Support in the development of the complex applications software
All of the above

Q.14.

Which one of the following commands is used for removing (or deleting) a relation forms the SQL database?

Delete
Drop
Remove
All of the above

Q.15.

Which of the following keys is generally used to represents the relationships between the tables?

Primary key
Foreign key
Secondary key
None of the above

Q.16.

Data redundancy occurs

when the same piece of data exists in multiple places.
when there is mismatch of data.
when there is NULL values.
when there is multiple values for an attribute.

Q.17.

In the given query which of the keyword has to be inserted?

table
values
from
relation

Q.18.

SELECT * FROM employee WHERE dept_name="Comp Sci";In the SQL given above there is an error . Identify the error.

Dept_name
Employee
“Comp Sci”
From

Q.19.

Which of the following is the most important feature of DBMS:

Command language like SQL
Ability to back up data
Ease of use
Ability to automate some tasks

Q.20.

Which of the following is NOT Advantages of DBMS

Increased data consistency
Reduced data redundancy
Improved data security
Increase data isolation

Support mcqgeeks.com by disabling your adblocker.