Question # 1

Which of the following gives all the fields from employee table named as EMP?

Choose an answer

SELECT * from EMP;

SELECT emp* from EMP'

SELECT emp_id where EMP;

SELECT * where EMP;

The main memory of a computer system is also known as

Choose an answer

ROM

RAM

PROM

Hard disk

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

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.

Identify the correct statement about ANSI/SPARC architecture.

Choose an answer

The external level is not concerned with individual user perceptions

The internal level, in a database system, will always be relational

Any given database has exactly one conceptual schema and one physical schema, but it may have several external schemas.

A data definition language is used to define the internal schema

Which of the following serves as a milestone or reference point in the log file?

Choose an answer

Constraints

Relations

Check points

Transactions identities

Which of the following is not true about relational tables?

Choose an answer

Column values are of the same kind

Each row is unique

Each column must have a unique name.

The sequence of rows is significant.

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.

Which of the following will be deleted relating to a table if you use TRUNCATE command?

Choose an answer

all rows in a table

indexes

table structure and its columns

constraints

_______ 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

A collection of related data is

Choose an answer

Logical model

Database

Data

Relational model

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