Question # 1

A collection of concepts that can be used to describe the structure of a database

Choose an answer

Database

DBMS

Data model

Data

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

Choose an answer

hardware

software

computer infrastructure

input and output

The Entity Relation Model models

Choose an answer

Entities, Relationships and Processes

Entities and Relationships

Relationships

Entities

As part of database naming conventions, attribute names should use suffixes such as ID, NUMBER or CODE for the _______.

Choose an answer

primary key

foreign key

index

determinant

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;

DML commands are used for:

Choose an answer

inserting data into databases

creating databases

destroying databases

creating DB objects

Identify the operation which is NOT one of the parts of the five basic set operations in relational algebra?

Choose an answer

Join

Union

Cartesian Product

Set Difference

Which of the following is Advantage of Re-Hashing technique to handle the collisions?

Choose an answer

Collisions don’t use primary table space

Unlimited number of elements

Fast access through use of main table space

Overhead of multiple linked lists

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

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

Which of the following statements are Data Definition Language command?

Choose an answer

INSERT

UPDATE

GRANT

TRUNCATE

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 should not be a property of a database transaction?

Choose an answer

Atomicity

Isolation

Durability

Divergence

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

Choose an answer

24 ( The number of rows in the first table multiplied by the number of rows in the second table )

32

12

16

Which of the following is NOT a feature of a good interface?

Choose an answer

Consistency

Process based

Data structure based

User friendly

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

Choose an answer

Choose an answer

Choose an answer

Choose an answer