1) Atomicity is _____
Options
a) Either all actions are carried out or none are. Users
should not have to worry about
the effect of incomplete transactions. DBMS ensures this by
undoing the actions of
incomplete transactions.
b) A concept which is used to model a relationship between a collection of
entities and relationships. It is used when we need to
express a relationship
among relationships.
Answer: a) Either all actions are carried out or none are.
Users should not have to
worry about the effect of incomplete transactions. DBMS
ensures this by undoing the
actions of incomplete transactions.
2) The phase that identifies an efficient execution plan for
evaluating a query that has
the least estimated cost is referred to as___.
Options
a) Query optimization
b) Query String
Answer: a) Query optimization
3) Expansion of DDL is _____.
Options
a) Data Description Language
b) Data Definition
Language
c) Data Degree
Language
Answer: Data Definition Language
4) A collection of conceptual tools for describing data, data relationships data
semantics and Constraints is called as_____.
Options Questions/Articles Extracted From
www.CareersValley.com
Page 36
a) Data base
b) Table
c) Data model
Answer: Data model
5) ______ is copying the three sets of files (database
files, redo logs, and control file)
when the instance is shut down. This is a straight file
copy, usually from the disk directly
to tape. You must shut down the instance to guarantee a
consistent copy.
Options
a) cold backup
b) hot backup
c) Armstrong Rules
Answer: cold backup
6) _______ is a program module, which ensures that database
remains in a consistent
state despite system failures and concurrent transaction
execution proceeds without
conflicting.
Options
a) Transaction manager
b) File manager
c) None of these
Answer: Transaction manager
7) _______ is a program module that provides the interface
between the low-level data
stored in database, application programs and queries
submitted to the system.
Options
a) Buffer manager
b) Storage manager
C) None of these
Answer: Storage manager
Questions/Articles Extracted From www.CareersValley.com
Page 37
8) A _____ with
respect to DBMS relates to user commands that are used to interact
with a database.
Options
a) Connection string
b) Query String
c) Query
Answer: Query
(Next 4 questions are of interview type)
9) In Very Simple Terms, Can you describe what is actually a
Database Server
instance?
Answer:
Every Database Server Instance is a complete server by
itself with own set of
databases, login credentials etc. A single machine that has
many server instances can
be logically compared to multiple machines with their own
Database Server installations.
10) Will executing/operating more than one Database Server
instances on a single
machine affect performance of applications adversely?
Answer:
More than one instance would require more memory and
processor related resources
than single instance on the same machine. But, more than one
instance can speed up
applications by allowing multiple applications to operate on
multiple instances of
Database Server simultaneously.
11) What could be the role of a server administrator to keep
up the performance of
machine with multiple instances?
Answer:
The server administrator is responsible for striking a
balance between number of allowed
SQL instances and system's hardware resources.
Questions/Articles Extracted From www.CareersValley.com
Page 38
12) Can databases on multiple instances have same names?
Answer:
Yes. Any database on an instance is completely local to that
database.
