Welcome to the SQL Queries,Constraints and Triggers MCQs Page

Dive deep into the fascinating world of SQL Queries,Constraints and Triggers with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of SQL Queries,Constraints and Triggers, a crucial aspect of DBMS. In this section, you will encounter a diverse range of MCQs that cover various aspects of SQL Queries,Constraints and Triggers, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within DBMS.

Check out the MCQs below to embark on an enriching journey through SQL Queries,Constraints and Triggers. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of DBMS.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of SQL Queries,Constraints and Triggers. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

SQL Queries,Constraints and Triggers MCQs | Page 16 of 17

Explore more Topics under DBMS

01

DBMS Basics

02

Data Models

03

The Entity Relationship Approach

04

Relational Databases

05

Data Storage and Querying

06

Relational Algebra

07

Normalization

08

Storage and File Structures

09

Indexing and Hashing

10

Transactions

11

Concurrency Control

12

Recovery System

13

Distributed Databases

14

SQL

15

Data Warehousing and Data Mining

16

RDBMS

17

Advanced SQL

Q151.

Which of these query will display the the table given below ?

Select employee from name

Select name

Select name from employee

Select employee

Discuss

Answer: (c).Select name from employee

Q152.

Select * from employee where employee_id>1009;

Which of the following employee_id will be displayed?

1009, 1001, 1018

1009, 1018

1001

1018

Discuss

Answer: (d).1018

Q153.

Consider the two relations instructor and department. Which of the following is used to create view for these relations together?

CREATE VIEW instructor_info AS
SELECT ID, name, building
FROM instructor, department
WHERE instructor.dept name= department.dept name;

CREATE VIEW instructor_info
SELECT ID, name, building
FROM instructor, department;

CREATE VIEW instructor_info AS
SELECT ID, name, building
FROM instructor;

CREATE VIEW instructor_info AS
SELECT ID, name, building
FROM department;

Discuss

Answer: (a).CREATE VIEW instructor_info AS
SELECT ID, name, building
FROM instructor, department
WHERE instructor.dept name= department.dept name;

Q154.

Which of the following is used to provide privilege to only a particular attribute ?

Grant select on employee to Amit

Grant update(budget) on department to Raj

Grant update(budget,salary,Rate) on department to Raj

Grant delete to Amit

Discuss

Answer: (b).Grant update(budget) on department to Raj

Q155.

Which of the following statement is used to remove the privilege from the user Amir ?

Remove update on department from Amir

Revoke update on employee from Amir

Delete select on department from Raj

Grant update on employee from Amir

Discuss

Answer: (b).Revoke update on employee from Amir

Q156.

Which of the following is used to provide delete authorization to instructor ?

CREATE ROLE instructor ;
GRANT DELETE TO instructor;

CREATE ROLE instructor;
GRANT SELECT ON takes
TO instructor;

CREATE ROLE instructor;
GRANT DELETE ON takes
TO instructor;

All of the mentioned

Discuss

Answer: (c).CREATE ROLE instructor;
GRANT DELETE ON takes
TO instructor;

Q157.

Which of the following is true regarding views ?

The user who creates a view cannot be given update authorization on a view without having update authorization on the relations used to define the view

If a user creates a view on which no authorization can be granted, the system will allow the view creation request

A user who creates a view receives all privileges on that view

Discuss

Answer: (c).If a user creates a view on which no authorization can be granted, the system will allow the view creation request

Q158.

If we wish to grant a privilege and to allow the recipient to pass the privilege on to other users, we append the __________ clause to the appropriate grant command.

With grant

Grant user

Grant pass privilege

With grant option

Discuss

Answer: (d).With grant option

Q159.

In authorization graph if DBA provides authorization to u1 which in turn gives to u2 which of the following is correct ?

If DBA revokes authorization from u1 then u2 authorization is also revoked

If u1 revokes authorization from u2 then u2 authorization is revoked

If DBA & u1 revokes authorization from u1 then u2 authorization is also revoked

If u2 revokes authorization then u1 authorization is revoked

Discuss

Answer: (c).If DBA & u1 revokes authorization from u1 then u2 authorization is also revoked

Q160.

Which of the following is used to avoid cascading of authorizations from the user ?

Granted by current role

Revoke select on department from Amit, Satoshi restrict;

Revoke grant option for select on department from Amit;

Revoke select on department from Amit, Satoshi cascade;

Discuss

Answer: (b).Revoke select on department from Amit, Satoshi restrict;

Page 16 of 17

Welcome to the SQL Queries,Constraints and Triggers MCQs Page

SQL Queries,Constraints and Triggers MCQs | Page 16 of 17

Explore more Topics under DBMS

DBMS Basics

Data Models

The Entity Relationship Approach

Relational Databases

Data Storage and Querying

Relational Algebra

Normalization

Storage and File Structures

Indexing and Hashing

Transactions

Concurrency Control

Recovery System

Distributed Databases

SQL

Data Warehousing and Data Mining

RDBMS

Advanced SQL

Suggested Topics

Computer Graphics

Systems Analysis and Design Methods

IT Fundamentals

Neural Networks

Java Spring Framework

Python

JavaScript

Object Oriented Programming Using C++

R Programming