Question # 1

Controlling redundancy in a database management system DOES NOT help to

Choose an answer

avoid duplication

avoid unnecessary wastage of storage space

avoid unauthorised access to data

avoid inconsistency among data

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

Choose an answer

24 ( The number of rows in the first table multiplied by the number of rows in the second table )

32

12

16

Which of following is NOT generally the aim of data partitioning and placement of data?

Choose an answer

Reduce Workload

Balance Workload

Merging different relations

Speed up rate of useful works.

Laser records data by burning microscopic holes in the surface of the disk with a

Choose an answer

Hard disk

RAM

Optical disk

Floppy disk

Identify the correct statement.

Choose an answer

Referential integrity constraints check whether the primary key values are unique

Referential integrity constraints check whether an attribute value lies in the given range

Referential integrity constraints are specified between entities having recursive relationships

When Referential integrity rules are enforced, a tuple in one relation that refers to another relation must refer to an existing tuple.

_______ records data by burning microscopic holes in the surface of the disk with a laser.

Choose an answer

Hard disk

RAM

Optical disk

Floppy disk

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

Choose an answer

inserting records into databases

updating records into databases

manipulating databases

creating and destroying databases

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

Consider a transaction which includes following operations Z= Z + 10 Write Z ... Suppose that the value of Z after addition and the execution of this operation is 17. Now against the write operation the entry made in the log file will be What does Z reflects in the above entry?

Choose an answer

Object being updated

Identity of the transaction

Object value

Identity of the next transaction to be executed

Which of the following is correct?

Choose an answer

The relation Interview is in 3NF

The relation Interview is in BCNF.

The FD3 violates 3NF.

The FD2 violates 2NF

Which of the following is not true regarding DB transactions?

Choose an answer

A set of database operations that are processed partly

A database transaction is a logical unit of database operations

A database transaction must be atomic

A database transaction must contains the ACID property

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