Question # 1

A ______ is used to maintain a connection between the users of the database system.

Choose an answer

Mail server

File Server

Client-serve

None of the given.

Which of the following should not be a property of a database transaction?

Choose an answer

Atomicity

Isolation

Durability

Divergence

Which of the following is Advantage of Re-Hashing technique to handle the collisions?

Choose an answer

Collisions don’t use primary table space

Unlimited number of elements

Fast access through use of main table space

Overhead of multiple linked lists

Identify the INCORRECT statement among the given.

Choose an answer

An entity may be an object with a physical existence like a car, a house or an Employee

One cannot consider something which has conceptual existence like a course in a degree program as an entity

Age can be considered as a single value attribute of a person.

An entity type describes the schema or intension for a set of entities which share the same structure.

Suppose there are 8 rows and 4 columns in TABLE1 and 3 rows and 4 coulmns in TABLE2; what is the size of the cartesian product incase of CROSS JOIN between these two tables?

Choose an answer

24

32

12

16

Which of the following is NOT a feature of Context DFD?

Choose an answer

one process (which represents the entire system)

all sources/sinks (external entities)

data flows linking the process to the sources and sinks (external entities)

sub-processes (which explain and decomposed the major process into small processes)

Which of the following functions are NOT performed by a database administrator?

Choose an answer

Planning, designing and implementing database systems

Establishing standards and procedures for database systems

Communicating with database users

Allocation of storage locations and data structures

Which of the following statements are Data Definition Language command?

Choose an answer

INSERT

UPDATE

GRANT

TRUNCATE

A collection of concepts that can be used to describe the structure of a database

Choose an answer

Database

DBMS

Data model

Data

Which of the following is NOT one of the ways of resolving deadlocks?

Choose an answer

Undoing all the updates made by the particular transaction which is the cause of deadlock.

A message is passed to the victim and depending on the system the transaction may or may not be started again automatically

Picking a list of all previously completed transactions and undoing all the updates.

Rollback `victim' transaction and restart it

More Classes

Other Links

CS-403 Final Term Exams Preparation Virtual University MCQs With Answers

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer