Database Management System

Question 1 Multiple Choice (Single Answer)

The union of primary keys of the related entity sets becomes a _________.

candidate key
super key
composite key
primary key
foreign key

Question 2 Multiple Choice (Single Answer)

A directed graph which represents the deadlocks is called __________.

wait for graph
cyclic graph
schema
tree
B-tree

Question 3 Multiple Choice (Single Answer)

The syntax of a user query is verified by __________.

parser
DBA
query optimizer
translator
compiler

Question 4 Multiple Choice (Single Answer)

A block that is not permitted to be written back to a disc is called _______.

zapped
deleted code
dead code
pinned
stopped

Question 5 Multiple Choice (Single Answer)

QUEL is a query language of which of the following databases?

DB II
Ingress
Oracle
SQL
MySQL

Question 6 Multiple Choice (Single Answer)

________ produces the relation that has attributes of R1 and R2.

Cartesian product
Difference
Intersection
Union
Productivity

Question 7 Multiple Choice (Single Answer)

Collection of information stored in a database as a particular moment is _________.

schema
view
table
instance
relation

Question 8 Multiple Choice (Single Answer)

The file organization that provides very fast access to any arbitrary record of a file is _______.

unordered file
ordered file
structured file
hashed file
non structured file

Question 9 Multiple Choice (Single Answer)

A host language is a _________.

storage definition language
query language
the DML embedded in the general purpose language
always an object oriented language
always a non-procedural language

Question 10 Multiple Choice (Single Answer)

Which is a desirable property of a transaction?

Automaticity
Consistancy
ACID
Isolation
Durability

ACID means atomicity, consistency, isolation, and durability.Atomicity requires that each transaction is "all or nothing": if one part of the transaction fails, the entire transaction fails, and the database state is left unchanged. An atomic system must guarantee atomicity in each and every situation, including power failures, errors, and crashes. To the outside world, a committed transaction appears (by its effects on the database) to be indivisible ("atomThe consistency property ensures that any transaction will bring the database from one valid state to another. Any data written to the database must be valid according to all defined rules, including but not limited to constraints, cascades, triggers, and any combination thereof. This does not guarantee correctness of the transaction in all ways the application programmer might have wanted (that is the responsibility of application-level code) but merely that any programming errors do not violate any defined rules.ic"), and an aborted transaction does not happen.The consistency property ensures that any transaction will bring the database from one valid state to another. Any data written to the database must be valid according to all defined rules, including but not limited to constraints, cascades, triggers, and any combination thereof. This does not guarantee correctness of the transaction in all ways the application programmer might have wanted (that is the responsibility of application-level code) but merely that any programming errors do not violate any defined rules.The isolation property ensures that the concurrent execution of transactions results in a system state that would be obtained if transactions were executed serially, i.e. one after the other. Providing isolation is the main goal of concurrency control. Depending on concurrency control method, the effects of an incomplete transaction might not even be visible to another transaction.Durability means that once a transaction has been committed, it will remain so, even in the event of power loss, crashes, or errors. In a relational database, for instance, once a group of SQL statements execute, the results need to be stored permanently (even if the database crashes immediately thereafter). To defend against power loss, transactions (or their effects) must be recorded in a non-volatile memory.

Question 11 Multiple Choice (Single Answer)

A primary key _________.

uniquely identifies the data in a row
is also referred to as composite key
is a unique identifier in a column
must be accompanied by a corresponding foreign key
is always a super key

Question 12 Multiple Choice (Single Answer)

Which of the following is a property of an entity?

Table
Group
Attribute
DBMS
Row

Question 13 Multiple Choice (Single Answer)

DBA stands for _______.

Database Administrator
Database Access
Data Bank Administrator
Data Bank Access
Database Authority

Question 14 Multiple Choice (Single Answer)

Prevention of access to the database by unauthorized users is referred to as _______.

integrity
reliability
productivity
security
duplicacy

Question 15 Multiple Choice (Single Answer)

Between the users and the database itself, a DBMS acts as a/an ________.

barrier
interface
referee
obstacle
guide

Question 16 Multiple Choice (Single Answer)

Duplicate data is referred to as _______.

accurate data
redundant data
related data
grouped data
null data

Question 17 Multiple Choice (Single Answer)

One common approach of preventing deadlocks, before beginning an update is ________.

lock the DBMS
lock the database
lock one row
lock one column
lock a relation

Question 18 Multiple Choice (Single Answer)

Which of the following DBMS supports full-fledged client server application development?

Dbase iv
Oracle 7.1
SQL
Ingress
Foxpro 2.1

Question 19 Multiple Choice (Single Answer)

The level of data abstraction, which describes how data is actually stored is _________.

physical level
logical level
conceptual level
view
file level

Question 20 Multiple Choice (Single Answer)

In a hierarchical database, a hashing function is used to locate the ___________.

root
collision
primary key
composite key
duplicate record

Database Management System

Questions