logo
  • Home
  • Test & Rank
  • About
  • Training
  • Programming
  • CS
  • IT
  • IS
  • ECE
  • EEE
  • EE
  • Civil
  • Mechanical
  • Chemical
  • Metallurgy
  • Instrumentation
  • Aeronautical
  • Aerospace
  • Biotechnology
  • Mining
  • Marine
  • Agriculture
  • MCA
  • BCA
  • Internship
  • Jobs
  • Contact

SQL Server Multiple Choice Questions | MCQs | Quiz

SQL Server Interview Questions and Answers
Practice SQL Server questions and answers for interviews, campus placements, online tests, aptitude tests, quizzes and competitive exams.

Get Started

•   SQL Server Basics
•   Management Studio - 1
•   Management Studio - 2
•   Data Types
•   Built in Functions
•   Basic SQL - 1
•   Basic SQL - 2
•   Basic SQL - 3
•   Joins
•   Views
•   Data Aggregation
•   Powershell
•   Windowing
•   Ranking
•   Subqueries
•   Modifying Data - 1
•   Modifying Data - 2
•   Constraints
•   Hierarchies
•   XML Data Working - 1
•   XML Data Working - 2
•   XML Data Working - 3
•   Xquery
•   Full Text Search
•   Data Definition Language - 1
•   Data Definition Language - 2
•   Data Definition Language - 3
•   Transact SQL
•   Procedural Flow
•   Variables
•   Cursor
•   Error Handling
•   Stored Procedure - 1
•   Stored Procedure - 2
•   Builtin Stored Procedures
•   User Defined Functions - 1
•   User Defined Functions - 2
•   DML Triggers
•   DDL Triggers
•   Dynamic SQL
•   SQL Injection
•   Bulk Operations
•   Distributed Queries
•   ADO.NET
•   LINQ - 1
•   LINQ - 2
•   Service Broker
•   Replication
•   Integration Services - 1
•   Integration Services - 2
•   Sql Server Access
•   Data Management
•   Policy Based Management
•   Recovery
•   Backup
•   Database Maintenance
•   SQL Server Agent
•   Transferring Database
•   Database Snapshots
•   Log Shipping
•   Database Mirroring
•   Clustering
•   Authentication
•   Securables
•   Data Cryptography
•   Row Level Security
•   Data Audit
•   Schema Audit
•   Performance Monitoring
•   Profiling
•   Wait States
•   Extended Events
•   Change Tracking
•   Change Data Capture
•   SQL Audit
•   Data Warehouse
•   Query Execution Plan
•   Indexing Strategies - 1
•   Indexing Strategies - 2
•   Query Plan Reuse
•   Transaction - 1
•   Transaction - 2
•   Locking
•   Blocking
•   Transaction Log
•   Data Compression
•   Partitioning
•   Resource Governor
•   Business Intelligence
•   Analysis Services - 1
•   Analysis Services - 2
•   Analysis Services - 3
•   MDX - 1
•   MDX - 2
•   Reporting Services - 1
•   Reporting Services - 2
•   Excel Data Analysis
•   Specifications - 1
•   Specifications - 2
•   System Databases

Best Reference Books

SQL Server Books

SQL Server Tests

Certification Test
Internship Test
Job Test
All Tests
Top Rankers
Practice Test 1
Practice Test 2
Practice Test 3
Practice Test 4
Practice Test 5
Practice Test 6
Practice Test 7
Practice Test 8
Practice Test 9
Practice Test 10
Mock Test 1
Mock Test 2
Mock Test 3
Mock Test 4
Mock Test 5
Mock Test 6
Mock Test 7
Mock Test 8
Mock Test 9
Mock Test 10
« Prev Page
Next Page »

SQL Server Questions and Answers – Data Definition Language – 2

Posted on August 23, 2017 by Manish

This set of SQL Server Quiz focuses on “Data Definition Language – 2”.

1. Point out the wrong statement.
a) You cannot drop a database currently being used
b) A database cannot be dropped regardless of its state
c) Any database snapshots on a database must be dropped before the database can be dropped
d) None of the mentioned
View Answer

Answer: b
Explanation: A database can be dropped regardless of its state: offline, read-only, suspect, and so on.
advertisement

2. Which of the following database should be backed up regularly?
a) Adventure Works
b) Pub
c) TEMPDB
d) Master
View Answer

Answer: d
Explanation: When a database is dropped, the master database should be backed up.

3. The DROP DATABASE statement must run in ________ mode.
a) Autocommit
b) Commit
c) Readcommit
d) None of the mentioned
View Answer

Answer: a
Explanation: Autocommit mode is the default transaction management mode.

4. Features provided by ALTER DATABASE statement do not include ____________
a) Deletes database
b) Modifies file
c) Changes the attributes of a database
d) Changes the database collation
View Answer

Answer: a
Explanation: ALTER DATABASE is used to modify the database.

5. Point out the correct statement.
a) Database snapshots cannot be modified
b) Database snapshots can be modified
c) A collation name can be specified with the FOR ATTACH or FOR ATTACH_REBUILD_LOG clauses
d) None of the mentioned
View Answer

Answer: a
Explanation: A database snapshot is a read-only, static view of a SQL Server database.
advertisement

6. Command used to shrink the size of the database is _____________
a) DBCC SHRINK
b) SHRINKDATABASE
c) DBCC SHRINKDATABASE
d) DBCC SHRINKDB
View Answer

Answer: c
Explanation: To decrease the size of a database, use DBCC SHRINKDATABASE.

7. Maximum number of filegroups specified for each database is ___________
a) 32, 667
b) 32, 777
c) 32, 766
d) 32, 767
View Answer

Answer: d
Explanation: A maximum of 32, 767 files and 32, 767 file groups can be specified for each database.

8. When does most ALTER DATABASE statements fail?
a) Database is in the RESTORING state
b) Database is in the STORING state
c) Database is in the RESTORE state
d) None of the mentioned
View Answer

Answer: a
Explanation: When a database is in RESTORING state then it means one or more files of the primary filegroup is been restored or one or more secondary files are being resotored offline.

9. Which of the following statement modifies view index?
a) ALTER INDEX
b) ALTER VIEW INDEX
c) ALTER INDEX_VIEW
d) None of the mentioned
View Answer

Answer: a
Explanation: ALTER INDEX modifies an existing table or view index (relational or XML) by disabling, rebuilding, or reorganizing the index; or by setting options on the index.

10. Which of the following index options are added by the CREATE INDEX statement?
a) XML INDEX
b) INCLUDED (column)
c) PARTITION SCHEME
d) ONLINE
View Answer

Answer: d
Explanation: CREATE INDEX includes the following new syntax elements:XML INDEX, INCLUDED and PARTITION SCHEME.
advertisement

Sanfoundry Global Education & Learning Series – SQL Server.

To practice all areas of SQL Server for quizzes, here is complete set of 1000+ Multiple Choice Questions and Answers.

« Prev Page - SQL Server Questions and Answers – Data Definition Language – 1
» Next Page - SQL Server Questions and Answers – Data Definition Language – 3

« SQL Server Questions and Answers – Data Definition Language – 1
SQL Server Questions and Answers – Data Definition Language – 3 »
advertisement

Deep Dive @ Sanfoundry:

  1. Database Management System Questions and Answers
  2. Data Structure Questions and Answers
  3. Oracle Database Questions and Answers
  4. Data Science Questions and Answers
  5. Java Programming Examples on Utility Classes
  6. C++ Programming Examples on Data-Structures
  7. Java Programming Examples on Data-Structures
  8. C Programming Examples on Data-Structures
  9. MySQL Database Questions and Answers
  10. SQL Server Questions and Answers
Manish Bhojasia
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He is Linux Kernel Developer & SAN Architect and is passionate about competency developments in these areas. He lives in Bangalore and delivers focused training sessions to IT professionals in Linux Kernel, Linux Debugging, Linux Device Drivers, Linux Networking, Linux Storage, Advanced C Programming, SAN Storage Technologies, SCSI Internals & Storage Protocols such as iSCSI & Fiber Channel. Stay connected with him @ LinkedIn | Facebook | Twitter

Best Careers

Developer Tracks
SAN Developer
Linux Kernel Developer
Linux Driver Developer
Linux Network Developer

Live Training Photos
Mentoring
Software Productivity
GDB Assignment
Sanfoundry is No. 1 choice for Deep Hands-ON Trainings in SAN, Linux & C, Kernel Programming. Our Founder has trained employees of almost all Top Companies in India such as VMware, Citrix, Oracle, Motorola, Ericsson, Aricent, HP, Intuit, Microsoft, Cisco, SAP Labs, Siemens, Symantec, Redhat, Chelsio, Cavium, ST-Micro, Samsung, LG-Soft, Wipro, TCS, HCL, IBM, Accenture, HSBC, Mphasis, Tata-Elxsi, Tata VSNL, Mindtree, Cognizant and Startups.

Best Trainings

SAN I - Technology
SAN II - Admin
Linux Fundamentals
Advanced C Training
Linux-C Debugging
System Programming
Network Programming
Linux Threads
Kernel Programming
Kernel Debugging
Linux Device Drivers

Best Reference Books

Computer Science Books
Algorithm & Programming Books
Electronics Engineering Books
Electrical Engineering Books
Chemical Engineering Books
Civil Engineering Books
Mechanical Engineering Books
Industrial Engineering Books
Instrumentation Engg Books
Metallurgical Engineering Books
All Stream Best Books

Questions and Answers

1000 C Questions & Answers
1000 C++ Questions & Answers
1000 C# Questions & Answers
1000 Java Questions & Answers
1000 Linux Questions & Answers
1000 Python Questions
1000 PHP Questions & Answers
1000 Hadoop Questions
Cloud Computing Questions
Computer Science Questions
All Stream Questions & Answers

India Internships

Computer Science Internships
Instrumentation Internships
Electronics Internships
Electrical Internships
Mechanical Internships
Industrial Internships
Systems Internships
Chemical Internships
Civil Internships
IT Internships
All Stream Internships

About Sanfoundry

About Us
Copyright
Terms
Privacy Policy
Jobs
Bangalore Training
Online Training
Developers Track
Mentoring Sessions
Contact Us
Sitemap
© 2011 Sanfoundry. All Rights Reserved.