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

Q1.

Which schema object instructs Oracle to connect to a remotely access an object of a database?

Sequence

Remote link

Database link

Data link

Discuss

Answer: (d).Data link

Q2.

DML changes are

Insert

Update

Create

Both Insert and Update

Discuss

Answer: (d).Both Insert and Update

Q3.

Which of the following object types below cannot be replicated?

Data

Trigger

View

Sequence

Discuss

Answer: (d).Sequence

Q4.

How to force a log switch?

By using ALTER SYSTEM LOG

By using ALTER SYSTEM SWITCH LOGFILE

By using ALTER SYSTEM SWITCH LOGS

By using ALTER SYS LOGFILES

Discuss

Answer: (b).By using ALTER SYSTEM SWITCH LOGFILE

Q5.

In the following query, which expression is evaluated first?

SELECT id_number, (quantity - 100 / 0.15 - 35 * 20) FROM inventory

100 / 0.15

quantity – 100

35*20

0.15-35

Discuss

Answer: (a).100 / 0.15

Q6.

The ORDER BY clause can only be used in

SELECT queries

INSERT queries

GROUP BY queries

HAVING queries

Discuss

Answer: (a).SELECT queries

Q7.

Which of the following rule below are categories of index?

Column and Functional

Multiple Column and functional

Column, Multiple Column and functional

None of the mentioned

Discuss

Answer: (a).Column and Functional

Q8.

What is the purpose of SMON background process?

Performs crash recovery when a failed instance starts up again

Performs recovery when a user process fails

Writes redo log entries to disk

None of the mentioned

Discuss

Answer: (a).Performs crash recovery when a failed instance starts up again

Q9.

Which of the following queries are legal?

SELECT deptno, count(deptno) FROM emp GROUP BY ename;

SELECT deptno, count(deptno), job FROM emp GROUP BY deptno;

SELECT deptno, avg(sal) FROM emp;

SELECT deptno, avg(sal) FROM emp GROUP BY deptno;

Discuss

Answer: (d).SELECT deptno, avg(sal) FROM emp GROUP BY deptno;

Q10.

Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?

select job, sum(sal) from emp where sum(sal) > 2500 and comm is null;

select job, sum(sal) from emp where comm is null group by job having sum(sal) > 2500;

select job, sum(sal) from emp where sum(sal) > 2500 and comm is null group by job;

select job, sum(sal) from emp group by job having sum(sal) > 2500 and comm is not null;

Discuss

Answer: (b).select job, sum(sal) from emp where comm is null group by job having sum(sal) > 2500;

Page 1 of 17

Welcome to the SQL Queries,Constraints and Triggers MCQs Page

SQL Queries,Constraints and Triggers MCQs | Page 1 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 Using C++

Python

MySQL Database

PHP

Systems Analysis and Design Methods

CompTIA PenTest+ Certification Exam PT0 002

Management Information Systems

Web Technologies

Data Structures and Algorithms