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 3 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

Q21.

Name

Annie

Bob

Callie

Derek

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

Select employee from name

Select name

Select name from employee

Select employee

Discuss

Answer: (c).Select name from employee

Q22.

Select ________ dept_name
from instructor;

Here which of the following displays the unique values of the column ?

All

From

Distinct

Name

Discuss

Answer: (c).Distinct

Q23.

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

Discuss

Answer: (a).Where, from

Q24.

Select ID, name, dept name, salary * 1.1
where instructor;

The query given below will not give an error. Which one of the following has to be replaced to get the desired output?

Salary*1.1

Where

Instructor

Discuss

Answer: (c).Where

Q25.

The ________ clause is used to list the attributes desired in the result of a query.

Where

Select

From

Distinct

Discuss

Answer: (b).Select

Q26.

Select name, course_id
from instructor, teaches

where instructor_ID= teaches_ID;

This Query can be replaced by which one of the following ?

Select name,course_id from teaches,instructor where instructor_id=course_id;

Select name, course_id from instructor natural join teaches;

Select name ,course_id from instructor;

Select course_id from instructor join teaches;

Discuss

Answer: (b).Select name, course_id from instructor natural join teaches;

Q27.

Select * from employee where salary>10000 and dept_id=101;
Which of the following fields are displayed as output?

Salary, dept_id

Employee

Salary

All the field of employee relation

Discuss

Answer: (d).All the field of employee relation

Q28.

Which of the following statements contains an error?

Select * from emp where empid = 10003;

Select empid from emp where empid = 10006;

Select empid from emp;

Select empid where empid = 1009 and lastname = ‘GELLER’;

Discuss

Answer: (d).Select empid where empid = 1009 and lastname = ‘GELLER’;

Q29.

Insert into employee _____ (1002,Joey,2000);
In the given query which of the keyword has to be inserted ?

Table

Values

Relation

Field

Discuss

Answer: (b).Values

Q30.

Which keyword must be used here to rename the field name ?

SELECT name ____ instructor name, course id
FROM instructor, teaches
WHERE instructor.ID= teaches.ID;

From

Rename

Join

Discuss

Answer: (c).As

Page 3 of 17

Welcome to the SQL Queries,Constraints and Triggers MCQs Page

SQL Queries,Constraints and Triggers MCQs | Page 3 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

Object Oriented Programming

Java Programming

JavaScript

Systems Analysis and Design Methods

HTML

Software Engineering

C Programming

Management Information Systems

MongoDB