Question # 1

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.

You can’t modify more than one table at a time through a view.

Choose an answer

True

False

Not Sure

Which of the following is NOT a feature of Indexed sequential files?

Choose an answer

Records are stored in sequence and index is maintained.

Dense and nondense types of indexes are maintained.

Track overflows and file overflow areas can not be ensured

Cylinder index increases the efficiency

Select the correct statement about the ANSI/SPARC architecture

Choose an answer

The conceptual level is a level of indication between the internal level and the external level.

The internal level in a database system will definitely be relational.

Any given database has many conceptual schemas and one physical schema, but it has only one external schemas.

The external level is not concerned with individual user perceptions, while the conceptual level is concerned with a community user perception.

Which of the following statements is correct with respect to the two relations given above?

Choose an answer

The two relations are not union-compatible since their attribute names differ.

The set operations such as CARTESIAN PRODUCT and DIVISION can be applied on these two relations.

To find out those students who work as instructors, it is necessary to perform the operation Student ∩ Instructor.

CS403-MIDTERM SOLVED MCQS with references by MOAAZ(2).pdf

Which of the following is not true about input forms?

Choose an answer

Provide an easy, effective, efficient way to enter data into a table

Especially useful when the person entering the data is not familiar with the inner workings

Provide different controls to add data into the tables

One input forms can populate one table at a time

Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?

Choose an answer

User accessible catalog

Data processing

Authorization service

Recovery service

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 one of the properties of Transaction?

Choose an answer

atomicity

consistency

redundancy

durability

A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.

Choose an answer

strong

weak

business

relationship

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

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