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

Q131.

Any recursive view must be defined as the union of two subqueries: a _______ query that is nonrecursive and a __________ query.

Base, recursive

Recursive, Base

Base, Redundant

View, Base

Discuss

Answer: (a).Base, recursive

Q132.

Ranking of queries is done by which of the following ?

Group by

Order by

Having

Both Group by and Order by

Discuss

Answer: (b).Order by

Q133.

In rank() function if one value is shared by two tuples then

The rank order continues as counting numbers

The rank order continues by leaving one rank in the middle

The user specifies the order

The order does not change

Discuss

Answer: (b).The rank order continues by leaving one rank in the middle

Q134.

The __________ function that does not create gaps in the ordering.

Intense_rank()

Continue_rank()

Default_rank()

Dense_rank()

Discuss

Answer: (d).Dense_rank()

Q135.

SELECT ID, GPA
FROM student grades
ORDER BY GPA
____________;

Inorder to give only 10 rank on the whole we should use

Limit 10

Upto 10

Only 10

Max 10

Discuss

Answer: (a).Limit 10

Q136.

If there are n tuples in the partition and the rank of the tuple is r , then its ________ is defined as (r −1)/(n−1) .

Ntil()

Cum_rank

Percent_rank

rank()

Discuss

Answer: (c).Percent_rank

Q137.

Inorder to simplify the null value confusion in the rank function we can specify

Not Null

Nulls last

Nulls first

Either Nulls last or first

Discuss

Answer: (d).Either Nulls last or first

Q138.

Suppose we are given a view tot credits (year, num credits) giving the total number of credits taken by students in each year.The query that computes averages over the 3 preceding tuples in the specified sort order is

SELECT YEAR, avg(num credits)
OVER (ORDER BY YEAR ROWS 3 preceding)
AS avg total credits
FROM tot credits;

SELECT YEAR, avg(num credits)
OVER (ORDER BY YEAR ROWS 3 unbounded preceding)
AS avg total credits
FROM tot credits;

ALL OF the mentioned

NONE OF the mentioned

Discuss

Answer: (a).SELECT YEAR, avg(num credits)
OVER (ORDER BY YEAR ROWS 3 preceding)
AS avg total credits
FROM tot credits;

Q139.

The functions which construct histograms and use buckets for ranking is

Rank()

Newtil()

Ntil()

None of the mentioned

Discuss

Answer: (c).Ntil()

Q140.

The command ________________ such tables are available only within the transaction executing the query, and are dropped when the transaction finishes.

Create table

Create temporary table

Create view

Create label view

Discuss

Answer: (b).Create temporary table

Page 14 of 17

Welcome to the SQL Queries,Constraints and Triggers MCQs Page

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

Web Technologies

JavaScript

Discrete Mathematics

Software Architecture and Design

MongoDB

Hadoop

Embedded Systems

Compiler Design

Object Oriented Programming