Question # 1

What is the impact of setting multiple indexes for the same key, in index sequential file

Choose an answer

Multiple indexes for the same key can not be set

It increases efficiency

It decreases efficiency

It will increase complexity as the access time will be increased

Which of the following is a correct way to implement one-to-many relationship while designing tables?

Choose an answer

by splitting the data into two tables with primary key and foreign key relationships

using a junction table with the keys from both the tables forming the composite primary key of the junction table.

by splitting each table into three

as a single table and rarely as two tables with primary and foreign key relationships

Which of the following are the general activities, which are performed during the development of application programs?

Choose an answer

Data input programs

Editing

Display

All of given

A database system allows the following EXCEPT

Choose an answer

management and control of data towards an efficient working of an organisation

more critical functions in organisations to be computerised and the need to keep a large volume of data available in an up to the minute current state increased.

any user to access all its data

integration of data across multiple applications into a single application.

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

ALTER TABLE exams ALTER COLUMN Q_description varchar(50) Syntax of ALTER TABLE is NOT correct.

Choose an answer

True

False

Not Sure

A relation (from the relational database model) consists of a set of tuples, which implies that

Choose an answer

all tuples in a relation must be distinct.

relational model supports multi-valued attributes whose values can be represented in sets

for any two tuples, the values associated with all of their attributes may be the same

all tuples in a particular relation may have different attributes.

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 should not be a property of a database transaction?

Choose an answer

Atomicity

Isolation

Durability

Divergence

Which of the following is NOT a component of a DFD?

Choose an answer

Dataflow

Datastore

External entities

Relationship between external entities

In a conceptual model for a university, what type of relationship exists between Grade and Student entitie

Choose an answer

1:1

1:M

M:M

Ternary

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

Choose an answer