Question # 1

In a conceptual model for a university, what type of relationship exists between Grade and Student entitie

Choose an answer

1:1

1:M

M:M

Ternary

Structural constraints of a relationship type refer to

Choose an answer

identifying the owner entity type relevant to a given entity type

whether the existence of an entity depends on it being related to another entity via the relationship type.

the role that a participating entity from the entity type plays in each relationship instance

the constraints applicable in granting access to tables, columns and views in a database schema.

In a conceptual model for a university, what type of relationship exists between Grade and Student entities?

Choose an answer

1:1

1:M

M:M

Ternary

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

Which of the following statements creates a database named COMPANY.

Choose an answer

CREATE DATABASE company

CREATE DB company

ADD DATABASE copmany

CREATE company DATABASE

Which of the following are the general activities, which are performed during the development of application programs?

Choose an answer

Data input programs

Editing

Display

All of given

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

If K is a foreign key in relation R1, then

Choose an answer

every tuple of R1 has a distinct value for K

k can not have a null value for tuples in R1

K is a key for some other relation.

K is a primary key for R1.

Which of the following is an example of volatile memory?

Choose an answer

RAM

ROM

Flash memory

CPU

_______ records data by burning microscopic holes in the surface of the disk with a laser.

Choose an answer

Hard disk

RAM

Optical disk

Floppy disk

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

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