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 – Application Performance

Posted on August 27, 2013 by Manish

This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Application Performance”.

1. The indirect change of the values of a variable in one module by another module is called
a) Internal change
b) Inter-module change
c) Side effect
d) Side-module update
View Answer

Answer: c
Explanation: The module of the search tree and the flow is directed by its values.

2. Which of the following data structure is not linear data structure?
a) Arrays
b) Linked lists
c) Arrays & Linked lists
d) None of the mentioned
View Answer

Answer: d
Explanation: Both array and linked lists are in data structure concepts.

3. Which of the following data structure is linear data structure?
a) Trees
b) Graphs
c) Arrays
d) None of the mentioned
View Answer

Answer: c
Explanation: Tree and graphs are not linear.

4. Which of the following criterion is NOT written using the proper syntax?
a) “Haris”
b) <500
c) NO VALUE
d) Between #1/1/2000# and #12/31/2000#
View Answer

Answer: c
Explanation: NO VALUE cannot be specified.

5. The operation of processing each element in the list is known as
a) Sorting
b) Merging
c) Inserting
d) Traversal
View Answer

Answer: d
Explanation: There are several types of traversals.

6. Finding the location of the element with a given value is:
a) Traversal
b) Search
c) Sort
d) None of the mentioned
View Answer

Answer: b
Explanation: Search is performed by traversing through the tree.

7. Arrays are best data structures
a) For relatively permanent collections of data
b) For the size of the structure and the data in the structure are constantly changing
c) All of the mentioned
d) None of the mentioned
View Answer

Answer: a
Explanation: The operator tree has a tree like format where the evaluation starts from root of the tree.

8. Linked lists are best suited
a) For relatively permanent collections of data
b) For the size of the structure and the data in the structure are constantly changing
c) All of the mentioned
d) None of the mentioned
View Answer

Answer: b
Explanation: A linked list is a data structure consisting of a group of nodes which together represent a sequence.

9. Each array declaration need not give, implicitly or explicitly, the information about
a) The name of array
b) The data type of array
c) The first data from the set to be stored
d) The index set of the array
View Answer

Answer: c
Explanation: The operator tree has a tree like format where the evaluation starts from root of the tree.

10. The elements of an array are stored successively in memory cells because
a) By this way computer can keep track only the address of the first element and the addresses of other elements can be calculated
b) The architecture of computer memory does not allow arrays to store other than serially
c) All of the mentioned
d) None of the mentioned
View Answer

Answer: a
Explanation: Memory is always allotted in order.

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 and Answers – Rapid Application Development
» Next Page - Database Questions and Answers – Application Security
« Database Questions and Answers – Rapid Application Development
Database Questions and Answers – Application Security »

Deep Dive @ Sanfoundry:

  1. Java Programming Examples on Combinatorial Problems & Algorithms
  2. C Programming Examples on Combinatorial Problems & Algorithms
  3. C Programming Examples on Stacks & Queues
  4. C Programming Examples without using Recursion
  5. C++ Programming Examples on Data-Structures
  6. Java Programming Examples on Data-Structures
  7. C Programming Examples on Data-Structures
  8. C# Programming Examples on Data Structures
  9. C Programming Examples on Linked List
  10. Data Structure 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