Question # 1

Which of the following is true about DELETE command?

Choose an answer

is DDL Command

Resets identity of the table

cannot activate a trigger

Can be Rolled back

Description on particular collection of data using data model

Choose an answer

Schema

Relation

Data base

None of the above

Which of the following is the correct way to find out the size of cartesian product incase of CROSS JOIN?

Choose an answer

the number of columns in the first table multiplied by the number of columns in the second table.

the number of columns in the first table multiplied by the number of rows in the second table

the number of rows in the first table multiplied by the number of columns in the first table

the number of rows in the first table multiplied by the number of rows in the second table

Which of the following is not true about input forms?

Choose an answer

Provide an easy, effective, efficient way to enter data into a table

Especially useful when the person entering the data is not familiar with the inner workings

Provide different controls to add data into the tables

One input forms can populate one table at a time

Which of the following concept is applicable with respect to 2NF?

Choose an answer

Non-transitive dependency

Full functional dependency

Partial dependency

Transitive dependency

Suppose there are 4 fields in a table named WORKER (Id, first_name, last_name, joining_year). Which of the following gives all the information of the workers who have joined after 1965?

Choose an answer

SELECT * FROM WORKER WHERE joining_Year>1965;

SELECT * FROM WORKER WHERE joining_Year>'1965';

SELECT * FROM WORKER AND joining_Year>'1965';

SELECT * WHERE joining_Year>1965;

_______ is a control that users click to perform an action, set or toggle a state, or set an option.

Choose an answer

Button

Text box

Input form

Report

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

Choose an answer

Creating databases

Destroying databases

Inserting data in tables

Non of the above

Which of the following is INCORRECT about VIEWS?

Choose an answer

It is not possible to left out the data which is not required for a specific view.

A database view displays one or more database records on the same page.

Views can be used as security mechanisms

Views are generally used to focus the perception each user has of the database.

Which of the following is an example of volatile memory?

Choose an answer

RAM

ROM

Flash memory

CPU

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