Question # 1

Select the correct statement among the following

Choose an answer

When different entity types participate only once in a single relationship type it is called a recursive relationship

Role names are not technically necessary in relationship types when all the participating entity types are distinct

Cardinality ratios for binary relationship are displayed on Entity Relationship Diagrams by using a diamond shape notation

Partial participation which is also called existence dependency is displayed as a double line connecting the participating entity type to the relationship .

DML commands are used for:

Choose an answer

inserting data into databases

creating databases

destroying databases

creating DB objects

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

Choose an answer

Database Designer

Database Administrator

End User

Application Programmer

Which of the following is not a benefit of normalization?

Choose an answer

Minimize insertion anomolies

Minimize deletion anomolies

Minimize updation anomolies

Maximize redundancy

Which of the following is the correct way of removing the Index called branchNoIndex?

Choose an answer

DROP INDEX branchNoIndex;

APPEND INDEX branchNoIndex;

REMOVE INDEX branchNoIndex;

DEL INDEX branchNoIndex;

A weak entity type

Choose an answer

must have total participation in an identifying relationship

does not have a key attribute(s)

both (a) and (b)

none of the above

The ER- data model is an example of:

Choose an answer

Physical database

Logical database

Relational database

Conceptual database

Which of the following gives all the fields from employee table named as EMP?

Choose an answer

SELECT * from EMP;

SELECT emp* from EMP'

SELECT emp_id where EMP;

SELECT * where EMP;

Which of the following constraints enforces referential integrity?

Choose an answer

FOREIGN KEY

CHECK

PRIMARY KEY

UNIQUE

Which of following is not the feature of Indexes?

Choose an answer

consume storage space

must be refreshed when the data in their master tables changes

improve the performance of SQL execution when they are used for query rewrites

can be accessed directly using a SELECT statement

Which of the following is NOT a feature of a good interface?

Choose an answer

Consistency

Process based

Data structure based

User friendly

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