Welcome to the Data Modification and Constraints MCQs Page

Dive deep into the fascinating world of Data Modification and Constraints with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of Data Modification and Constraints, a crucial aspect of SQL Server. In this section, you will encounter a diverse range of MCQs that cover various aspects of Data Modification and Constraints, 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 SQL Server.

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

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

Data Modification and Constraints MCQs | Page 3 of 6

Explore more Topics under SQL Server

01

SQL Server Basics

02

Beyond Relational

03

Data Definition Language

04

Development with SQL Server

05

Data Connectivity

06

Enterprise Data Management

07

Data Security

08

Monitoring and Auditing

09

Performance Tuning and Optimization

10

Business Intelligence and Reporting Services

Q21.

Select __________ from instructor where dept name= ’Comp. Sci.’;

Which of the following should be used to find the mean of the salary?

Mean(salary)

Avg(salary)

Sum(salary)

Count(salary)

Discuss

Answer: (b).Avg(salary)

Q22.

The ________ connective tests for set membership, where the set is a collection of values produced by a select clause. The _________ connective tests for the absence of set membership.

Or, in

Not in, in

In, not in

In, or

Discuss

Answer: (c).In, not in

Q23.

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

Q24.

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;

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

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

Discuss

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

Q25.

Which server can join the indexes when only multiple indexes combined can cover the query?

SQL

DBMS

RDBMS

All of the mentioned

Discuss

Answer: (a).SQL

Q26.

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

Q27.

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

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

Salary*1.1

Where

Instructor

Discuss

Answer: (c).Where

Q28.

The below query is equivalent to ____________

Select * from student join takes using (ID);

Select * from student inner join takes using (ID);

Select * from student outer join takes using (ID);

Select * from student left outer join takes using (ID);

All of the mentioned

Discuss

Answer: (a).Select * from student inner join takes using (ID);

Q29.

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

SELECT ID, name FROM 1_Order WHERE instructor=1;

_Order

2Order

3Order

Instructor

Discuss

Answer: (a)._Order

Q30.

The following query can be replaced by which one of the following?

SELECT name, course_id
FROM instructor, teaches
WHERE instructor_ID= teaches_ID;

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;

Page 3 of 6

Welcome to the Data Modification and Constraints MCQs Page

Data Modification and Constraints MCQs | Page 3 of 6

Explore more Topics under SQL Server

SQL Server Basics

Beyond Relational

Data Definition Language

Development with SQL Server

Data Connectivity

Enterprise Data Management

Data Security

Monitoring and Auditing

Performance Tuning and Optimization

Business Intelligence and Reporting Services

Suggested Topics

CSS

CompTIA PenTest+ Certification Exam PT0 002

Digital Image Processing (DIP)

Big Data Computing

MySQL Database

Visual Basic

Software Architecture and Design

Digital Communication

R Programming