Question # 1

Description on particular collection of data using data model

Choose an answer

Schema

Relation

Data base

None of the above

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

Which of the following enforces a relation into 1st normal form?

Choose an answer

The domain of attribute must include only atomic values

Every non-key attribute is fully functionally dependent on primary key

non-key attribute is non-transitively dependent on primary key.

Every non-key attribute is partially dependent on super key

Which of the following is not true about De-normalization?

Choose an answer

It is the process of attempting to optimize the performance of a database

De-normalization is a technique to move from lower to higher normal forms of database modeling

It enhances the performance of DB

In de-normalization it is required to add redundant data.

Only one type of constraint can be enforced in any table by CREATE command

Choose an answer

True

False

Not Sure

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

Select 'NORTH', CUSTOMER From CUST_DTLS Where REGION = 'N' Order By CUSTOMER Union Select 'EAST', CUSTOMER From CUST_DTLS Where REGION = 'E' Order By CUSTOMER The above statement

Choose an answer

Has an error - the string should be in double quotes

Has an error - ORDER BY clause.

Does not have an error.

Has an error - the string in single quotes 'NORTH' and 'SOUTH'.

A candidate key that does not have a null value and is selected to uniquely identify all other attribute values in any given row is called a

Choose an answer

superkey

candidate key

primary key

secondary key

A superkey that does not contain a subset of attributes that is itself a superkey is called a ___

Choose an answer

candidate key

primary key

superkey

secondary key

Which of the following is the correct description of cache hit?

Choose an answer

When data is found in the cache

When data is removed in the cache

The number of times the cache is accessed directly by the processor

When data is lost from the cache

_______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

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