Question # 1

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

The main memory of a computer system is also known as

Choose an answer

ROM

RAM

PROM

Hard disk

Which of the following is not a feature of TRANSACTION?

Choose an answer

Users should be able to regard the execution of each transaction as atomic

Each transaction, run by itself

must preserve the consistency of the database

dependant on other concurrent transactions

Which of the following SQL commands deletes a record of an employee with the employee_id 12345, from a table named PERSON.

Choose an answer

DELETE FROM person WHERE employee_id = ‘12345’

DELETE WHERE person FROM employee_id = 12345

DROP FROM person WHERE employee_id = 12345

DELETE WHERE person WHERE employee_id = 12345

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 .

A software package designed to store and manage databases

Choose an answer

Database

DBMS

Data model

Data

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.

______ is a control that presents a set of choices from which a user can select one or more items; items can be text, graphics, or both.

Choose an answer

Text input

Report

Button

List box

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

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

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

_______is a control that enables users to select one option from an associated list; users can also type an option.

Choose an answer

Combo box

Button

Text box

Static area

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.

Suppose there are 4 fields in a table named CUST (customer_id, first_name, last_name, phone). Which of the following gives all the information of the customers in the table whose last name is ALI?

Choose an answer

SELECT * FROM CUST WHERE last_name='ALI';

SELECT * FROM CUST WHERE last_name=ALI;

SELECT * FROM CUSTOMER WHERE name=ALI;

SELECT * FROM CUSTOMER WHERE last_name=ALI;

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

Choose an answer

Physical data independence

Concurrency control.

Logical data independence.

Functional dependency

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

Choose an answer

Choose an answer

Choose an answer

Choose an answer