Question # 1

Suppose there are 8 rows and 4 columns in TABLE1 and 3 rows and 4 coulmns in TABLE2; what is the size of the cartesian product incase of CROSS JOIN between these two tables?

Choose an answer

24

32

12

16

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 statements are Data Manipulation Language command?

Choose an answer

INSERT

GRANT

TRUNCATE

CREATE

Which of the following is NOT one of the ways of resolving deadlocks?

Choose an answer

Undoing all the updates made by the particular transaction which is the cause of deadlock.

A message is passed to the victim and depending on the system the transaction may or may not be started again automatically

Picking a list of all previously completed transactions and undoing all the updates.

Rollback `victim' transaction and restart it

The Entity Relation Model models

Choose an answer

Entities, Relationships and Processes

Entities and Relationships

Relationships

Entities

Identify the advantage of DELETE command over TRUNCATE.

Choose an answer

Can be Rolled back

is DDL Command.

cannot activate a trigger.

faster and uses fewer system

Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of

Choose an answer

Physical data independence.

Concurrency control

Logical data independence.

Functional dependency

Which of the following is NOT a component of a DFD? Select correct option:

Choose an answer

Dataflow

Datastore

External entities

Relationship between external entities

In which of the following situations, Clustering is suitable:

Choose an answer

Frequently updating

Relatively static

Relatively deletion

Relatively dynamic

DML commands are used for:

Choose an answer

inserting data into databases

creating databases

destroying databases

creating DB objects

Identify the correct statement with respect to normalization.

Choose an answer

Normalization is a formal technique that can be used only at the starting phase of the database design.

Normalization can be used as a top-down standalone database design technique.

The process of normalization through decomposition must achieve the lossless join property at any cost whereas the dependency reservation property is sometimes sacrificed.

The process of normalization through decomposition must achieve the dependency reservation property at any cost whereas the lossless join property is sometimes sacrificed.

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