Question # 1

Which of the following is INCORRECT statement concerning the database design process?

Choose an answer

During requirements collection and analysis phase, one can gather the data requirements of database users.

By referring to a high level data model, it is possible to understand the data requirements of the users, entity types, relationships and constraints.

Transformation of the high level data model into the implementation data model is called logical design or data model mapping

During the logical design phase of internal storage structures, access paths and file organization for the database files are specified.

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

Which of the following is one of the purposes of using DML commands?

Choose an answer

Creating databases

Destroying databases

Inserting data in tables

Non of the above

Which of the following is CORRECT about database management system's languages?

Choose an answer

Data definition languages are used to specify the conceptual schema only.

Data manipulation languages are used to create the databases

Data manipulation languages are used for retrieval, insertion, deletion and modification of data

Data definition langauges are only used to update data in the DBMS.

The ER- data model is an example of:

Choose an answer

Physical database

Logical database

Relational database

Conceptual database

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

Choose an answer

True

False

Not Sure

Which of the following concepts is applicable with respect to 2NF?

Choose an answer

Full functional dependency

Any kind of dependency

Transitive dependency

Non-transitive dependency

Which of the following SQL keywords is not used with DDL statements?

Choose an answer

Table

Update

Create

Alter

Which of the given techniques is/are used to improve query performance in database?

Choose an answer

Good File organization

Indexing

Both Indexing and Good File organization

Select only one record per query

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 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

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