Question # 1

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

Which of the following is a feature of PRIMARY KEY constraint?

Choose an answer

unique identifier for a row within a database table.

allow any actions that would destroy links between tables

limit the values that can be placed in a column.

enforces that the column will only accept null values.

Select the correct statement about the ANSI/SPARC architecture

Choose an answer

The conceptual level is a level of indication between the internal level and the external level.

The internal level in a database system will definitely be relational.

Any given database has many conceptual schemas and one physical schema, but it has only one external schemas.

The external level is not concerned with individual user perceptions, while the conceptual level is concerned with a community user perception.

Identify the correct statement

Choose an answer

Entity integrity constraints specify that primary key values can be composite

Entity integrity constraints are specified on individual relations.

Entity integrity constraints are specified between weak entities.

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

GRANT SELECT, UPDATE(Designation) ON Employee TO Amali,Hiruni WITH GRANT OPTION; What does this SQL statement do?

Choose an answer

Grant permission to Amali,only to retrieve data from Employee table and grant permission to Hiruni, only to update the designation from Employee table.

Grant permission to Amali & Hiruni to retrieve data from Employee table

Grant permission to Hiruni in order to grant, select and update permission to Amali.

Grant permission to Amali and Hiruni to update all data except designation in Employee table

_______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

The ____ constraint specifies whether each entity supertype occurrence must also be a member of at least one subtype

Choose an answer

specialization

uniqueness

inheritance

completeness

The main memory of a computer system is also known as

Choose an answer

ROM

RAM

PROM

Hard disk

A relation (from the relational database model) consists of a set of tuples, which implies that

Choose an answer

all tuples in a relation must be distinct.

relational model supports multi-valued attributes whose values can be represented in sets

for any two tuples, the values associated with all of their attributes may be the same

all tuples in a particular relation may have different attributes.

_______ 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

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

Choose an answer

24

32

12

16

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