Question # 1

Which of the following enforces a relation into 1st normal form?

Choose an answer

The domain of attribute must include only atomic values

Every non-key attribute is fully functionally dependent on primary key

non-key attribute is non-transitively dependent on primary key.

Every non-key attribute is partially dependent on super key

Which of the following most certainly implies the need for an entire table to implement?

Choose an answer

A binary relationship

A ternary relationship

A recursive relationship

An identifying relationship

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)

Database management systems, operating systems, applications and utilities are all examples of ____.

Choose an answer

hardware

software

computer infrastructure

input and output

Which of the following constraints enforces entity integrity?

Choose an answer

PRIMARY KEY

FOREIGN KEY

CHECK

NOT NULL

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

Choose an answer

Atomicity

Isolation

Durability

Divergence

Identify which of the above statements is/are correct.

Choose an answer

Only A

Only B

Only B and C

Only A and B

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.

_______ is a control that users click to perform an action, set or toggle a state, or set an option.

Choose an answer

Button

Text box

Input form

Report

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

Choose an answer

Database

DBMS

Data model

Data

Who is responsible for authorizing access to the database, for coordinating and monitoring its use ?

Choose an answer

Database Designers

Database Administrators

End Users

Application Programmers

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