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

DBMS Multiple Choice Questions | MCQs | Quiz

Database Management System Interview Questions and Answers
Pratice Database Management System questions and answers for interviews, campus placements, online tests, aptitude tests, quizzes and competitive exams.

Get Started

•   Relational Database
•   Keys
•   Relational Query Operations
•   SQL Basics
•   SQL Queries
•   Basic SQL Operations
•   Set Operations
•   Null Values Operations
•   Nested Subqueries - 1
•   Nested Subqueries - 2
•   Database Modification
•   Join Expressions
•   Views
•   Transactions
•   Integrity Constraints
•   SQL Data Types & Schema
•   Authorizations
•   Programming Language
•   Functions & Procedures
•   Triggers
•   Recursive Queries
•   OLAP
•   Relational Algebra
•   Tuple Relational Calculus
•   Entity Relationship Model
•   Constraints
•   Entity Relationship Diagram
•   Relational Schemas
•   E - R Design Issues
•   Extended E - R Features
•   Querying database - 1
•   Querying database - 2
•   Atomic Domains
•   Normal Forms
•   Functional Theory
•   Decomposition Algorithms
•   Multivalued Dependencies
•   Database Design Process
•   Application Programs
•   Web Fundamentals
•   Servlets & JSP
•   Application Architectures
•   Application Development
•   Application Performance
•   Application Security
•   Encryption & Its Application
•   Physical Storage Media
•   Magnetic Disk
•   RAID
•   Tertiary Storage
•   File Organisations
•   Files-Records Organization
•   Data Dictionary Storage
•   Database Buffer
•   Ordered Indices
•   Hashing Techniques
•   Ordered Indexing & Hashing
•   Bitmap Indices
•   SQL Index Definition
•   Query Processing
•   Selection Operation
•   Sorting
•   Join Operations
•   Expressions Evaluation
•   Relational Expressions
•   Expression Statistics
•   Materialized Views
•   Query Optimization
•   Transaction Concept
•   Simple Transaction Model
•   Storage Structure
•   Transaction Atomicity
•   Querying database - 3
•   Querying database - 4
•   Querying database - 5
•   Isolation Levels
•   SQL Statements
•   Lock-Based Protocols
•   Deadlocks
•   Multiple Granularity
•   Multiversion Schemes
•   Snapshot Isolation
•   Insertion Deletion
•   Index Structures
•   Failure Classification
•   Recovery
•   Buffer Management
•   Nonvolatile Storage Failure
•   ARIES
•   Undo Operations
•   Remote Backup Systems

Best Reference Books

Database Management System Books
« Prev Page
Next Page »

Database Questions and Answers – Index Definition in SQL

Posted on August 27, 2013 by Manish

This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Index Definition in SQL”.

1. What is the purpose of index in sql server
a) To enhance the query performance
b) To provide an index to a record
c) To perform fast searches
d) All of the mentioned
View Answer

Answer: d
Explanation: A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes.

2. How many types of indexes are there in sql server?
a) 1
b) 2
c) 3
d) 4
View Answer

Answer: b
Explanation: They are clustered index and non clustered index.

3. How non clustered index point to the data?
a) It never points to anything
b) It points to a data row
c) It is used for pointing data rows containing key values
d) None of the mentioned
View Answer

Answer: c
Explanation: Nonclustered indexes have a structure separate from the data rows. A nonclustered index contains the nonclustered index key values and each key value entry has a pointer to the data row that contains the key value.

4. Which one is true about clustered index?
a) Clustered index is not associated with table
b) Clustered index is built by default on unique key columns
c) Clustered index is not built on unique key columns
d) None of the mentioned
View Answer

Answer: b
Explanation: Nonclustered indexes have a structure separate from the data rows. A nonclustered index contains the nonclustered index key values and each key value entry has a pointer to the data row that contains the key value.

5. What is true about indexes?
a) Indexes enhance the performance even if the table is updated frequently
b) It makes harder for sql server engines to work to work on index which have large keys
c) It doesn’t make harder for sql server engines to work to work on index which have large keys
d) None of the mentioned
View Answer

Answer: b
Explanation: Indexes tend to improve the performance.

6. Does index take space in the disk ?
a) It stores memory as and when required
b) Yes, Indexes are stored on disk
c) Indexes are never stored on disk
d) Indexes take no space
View Answer

Answer: b
Explanation: Indexes take memory slots which are located on the disk.

7. What are composite indexes ?
a) Are those which are composed by database for its internal use
b) A composite index is a combination of index on 2 or more columns
c) Composite index can never be created
d) None of the mentioned
View Answer

Answer: b
Explanation: A composite index is an index on two or more columns of a table.

8. If an index is _________________ the metadata and statistics continue to exists
a) Disabling
b) Dropping
c) Altering
d) Both Disabling and Dropping
View Answer

Answer: a
Explanation: A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes.

9. In _______________ index instead of storing all the columns for a record together, each column is stored separately with all other rows in an index.
a) Clustered
b) Column store
c) Non clustered
d) Row store
View Answer

Answer: b
Explanation: A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes.

10. A _________________ index is the one which satisfies all the columns requested in the query without performing further lookup into the clustered index.
a) Clustered
b) Non Clustered
c) Covering
d) B-Tree
View Answer

Answer: c
Explanation: A covered query is a query where all the columns in the query’s result set are pulled from non-clustered indexes.

Sanfoundry Global Education & Learning Series – Database Management System.

To practice all areas of Database Management System, here is complete set on 1000+ Multiple Choice Questions and Answers on Database Management System.
« Prev Page - Database Questions & Answers – Bitmap Indices
» Next Page - Database Questions and Answers – Query Processing
« Database Questions & Answers – Bitmap Indices
Database Questions and Answers – Query Processing »

Deep Dive @ Sanfoundry:

  1. C# Programming Examples on Matrix
  2. C# Programming Examples on LINQ
  3. Data Structure Questions and Answers
  4. C Programming Examples on Matrix
  5. RDBMS Questions and Answers
  6. SQL Server Questions and Answers
  7. MongoDB Questions and Answers
  8. MySQL Database Questions and Answers
  9. Database Management System Questions and Answers
  10. Oracle Database Questions and Answers
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He is Linux Kernel Developer and 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 & Cluster Administration, Advanced C Programming, SAN Storage Technologies, SCSI Internals and Storage Protocols such as iSCSI & Fiber Channel. Stay connected with him below:
LinkedIn | Facebook | Twitter | Google+

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
TOS & Privacy
Jobs
Bangalore Training
Online Training
SAN Training
Developers Track
Mentoring Sessions
Contact Us
Sitemap
© 2011 Sanfoundry