Skip to content

Tools by ArtOfTesting
Manual
Automation
Performance
- Performance Testing
- JMeter Tutorial
Java
Interview
Tools Review

DBMS MCQ Quiz

DBMS Quiz

Hello Friends, here is a quick quiz with DBMS MCQs. You can also check our RDBMS Interview Questions and SQL Query Interview Questions to prepare for your interviews.

What is a tuple?

A tuple is a command to delete the content of a table.

A tuple is a database column.

A tuple is a single record or single row in a table.

Tuple stands for transactions in a table.

None

Which of the following is not a DDL command?

Create

Drop

Alter

Select

None

What are DCL commands?

These commands are used for managing data present in the database.

These commands are used to create roles, grant permission, and control access to the database objects.

These commands are used to define or alter the structure of the database.

The DCL commands are used to delete data from tables.

None

What are SQL constraints?

Set of rules that impose some restrictions while inserting, deleting, or updating the data in the databases.

Set of constraints to copy the data from database tables.

SQL commands to join to two tables.

SQL constraints to alter data in a table.

None

What is the difference between a unique key and a primary key?

Unique key cannot be deleted while primary can be deleted.

Unique is DDL commands while primary Key is DCL command.

Unique Key can be deleted while primary key cannot be deleted.

Unique key constraint allows a null value while primary key constraint doesn't.

None

Which of the following is incorrect about 'views' in SQL?

Views are virtual tables.

Views are used to add constraints in SQL.

Views refer to a named set of SQL statements.

Views can be referred same way as tables.

None

Which key is used to represents the relationships between the tables?

Unique Key

Primary key

Foreign key

Relationship Key

None

What are the triggers in SQL?

Triggers are SQL commands to trigger the joins on 2 tables.

Triggers are special types of stored procedures that get executed when a specified event occurs.

Triggers are used to traverse the result set of a SQL query one by one.

Triggers are use to improve the perforamance of SQL queries.

None

What is a coalesce function?

A coalesce function is used to return the first, not NULL value out of the different values passed to the coalesce function.

A coalesce function is used to return all the null values in a table.

A coalesce function is used to return all the primary keys in a table.

A coalesce function is used to return the first, null value out of the different values passed to the coalesce function.

None

What are orphan records?

Orphan records are records having a foreign key to a parent record that doesn't exist or got deleted.

Orphans records are columns without any constraints.

Orphans records are fields with null values.

Orphan records are rows with blank values.

None

Time's up

1 thought on “DBMS MCQ Quiz”

Shajahan Alam
March 30, 2022 at 8:25 am
Dcl TCL mock test
Reply

Leave a Comment Cancel reply

Comment

Name Email Website

Save my name, email, and website in this browser for the next time I comment.

About Us
Contact Us
Disclaimer
Terms of Service
Privacy Policy

© 2024 ArtOfTesting

Tools by ArtOfTesting
Manual
Automation
Performance
- Performance Testing
- JMeter Tutorial
Java
Interview
Tools Review

Search for: