Question # 1

DML commands are used for:

Choose an answer

inserting data into databases

creating databases

destroying databases

creating DB objects

Database management systems, operating systems, applications and utilities are all examples of ____.

Choose an answer

hardware

software

computer infrastructure

input and output

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

Which of the following SQL keywords is not used with DDL statements?

Choose an answer

Table

Update

Create

Alter

An entity type is

Choose an answer

defined when the database is actually constructed

a specific type such as an integer, text, date, logical etc

a coherent set of similar objects that we want to store data on (e.g. STUDENT, COURSE, CAR)

defined by the database designer

Which of the following should not be a property of a database transaction?

Choose an answer

Atomicity

Isolation

Durability

Divergence

Which of the following is incorrect with respect to indexed sequential files?

Choose an answer

New records are added to an overflow file

Record in main file that precedes it is updated to contain a pointer to the new record

The overflow is merged with the main file during a batch update

Multiple indexes for the same key field cannot be setup

Select the correct statement among the following.

Choose an answer

Role names are not technically necessary in relationship types when all the participating entity types are distinct

When different entity types participate only once in a single relationship type it is called a recursive relationship.

Cardinality ratios for binary relationship are displayed on Entity Relationship Diagrams by using a diamond shape notation.

Partial participation which is also called existence dependency is displayed as a double line connecting the participating entity type to the relationship.

A weak entity type

Choose an answer

must have total participation in an identifying relationship

does not have a key attribute(s)

both (a) and (b)

none of the above

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

Choose an answer

24

54

6

1

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

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