adplus-dvertising

Welcome to the SQL MCQs Page

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

frame-decoration

Check out the MCQs below to embark on an enriching journey through SQL. 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. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

SQL MCQs | Page 16 of 38

Explore more Topics under DBMS

Q151.
Which of the three possible types of triggers does SQL Server support?

a.

INSTEAD OF only

b.

AFTER only

c.

BEFORE only

d.

INSTEAD OF and AFTER only

Discuss
Answer: (d).INSTEAD OF and AFTER only
Q152.
Which of the following is a way to create and modify tables using SQL Server?

a.

Write SQL code using either CREATE or ALTER SQL statements only.

b.

Use the graphical facilities of SQL Server Enterprise Manager only.

c.

Both of the two methods above will work.

d.

Neither of the two methods above will work.

Discuss
Answer: (c).Both of the two methods above will work.
Q153.
With which type of SQL Server recovery model, is no logging done?

a.

Differential recovery

b.

Full recovery

c.

Bulk-logged recovery

d.

Simple recovery

Discuss
Answer: (d).Simple recovery
Q154.
SQL Server 2000 stored procedures can:

a.

never be kept within the database.

b.

be kept within the database and invoked by application programs.

c.

be stored on the users' computer.

d.

support BEFORE, INSTEAD OF and AFTER types.

Discuss
Answer: (b).be kept within the database and invoked by application programs.
Q155.
With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.

a.

READ_ONLY

b.

SCROLL_LOCK

c.

OPTIMISTIC

d.

PESSIMISTIC

Discuss
Answer: (c).OPTIMISTIC
Q156.
An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:

a.

COBOL.

b.

VB.NET.

c.

TRANSACT SQL.

d.

Visual Basic.

Discuss
Answer: (c).TRANSACT SQL.
Q157.
With this type of index, the data are stored in the bottom level of the index and in the same order as that index.

a.

Nonclustered

b.

Clustered

c.

Primary

d.

Secondary

Discuss
Answer: (b).Clustered
Q158.
In SQL Server 2000, which of the following makes a copy of the changes that have been made to the database since the last complete backup?

a.

Complete backup

b.

Transaction Log

c.

Differential backup

d.

None of the above is correct.

Discuss
Answer: (c).Differential backup
Q159.
With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.

a.

Nonclustered

b.

Clustered

c.

Primary

d.

Secondary

Discuss
Answer: (a).Nonclustered
Q160.
With which type of SQL Server recovery model are all database changes logged?

a.

Differential recovery

b.

Full recovery

c.

Simple recovery

d.

Bulk-logged recovery

Discuss
Answer: (b).Full recovery
Page 16 of 38

Suggested Topics

Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Data Science

Discover the fascinating world of extracting insights from data with our Data Science...

Management Information Systems

Discover how businesses leverage technology with our Management Information Systems...

Artificial Intelligence

Get started on the path to the future with our Artificial Intelligence MCQs. Covering...

CSS

Polish your web design skills with our CSS MCQs. Learn about selectors, properties,...

Operating System

Dive deep into the core of computers with our Operating System MCQs. Learn about...

Systems Programming

Decode low-level programming with our Systems Programming MCQs. These questions delve...

Discrete Mathematics

Refine your mathematical skills essential for computer science with our Discrete...

Object Oriented Programming Using C++

Enhance your programming skills with our MCQs on Object Oriented Programming using...

Computer Architecture

Unveil the science behind computer design with our Computer Architecture MCQs. Topics...