CS403 Current Quiz Nov 2010

Question # 1 of 10 ( Start time: 01:13:48 PM ) Total Marks: 1


A ____ relationship exists when an association is maintained within a single entity.

Select correct option:



Unary

Binary

Ternary

Weak









Question # 2 of 10 ( Start time: 01:14:33 PM ) Total Marks: 1

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

Select correct option:



Database



DBMS



Data model



Data







Question # 3 of 10 ( Start time: 01:16:00 PM ) Total Marks: 1

Which of the following is NOT a component of a DFD?

Select correct option:



Dataflow

Datastore

External entities

Relationship between external entities





Question # 4 of 10 ( Start time: 01:17:27 PM ) Total Marks: 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 ____.

Select correct option:



superkey

candidate key

primary key

secondary key



Question # 5 of 10 ( Start time: 01:18:32 PM ) Total Marks: 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 ____.

Select correct option:



superkey

candidate key

primary key

secondary key

Question # 6 of 10 ( Start time: 01:19:51 PM ) Total Marks: 1

A primary key is an attribute (or set of attributes) that has been chosen for an entity, whose values are used to uniquely identify a particular instance of an entity. True or false?

Select correct option:



True

False

Partially True

None of the given



Question # 7 of 10 ( Start time: 01:20:37 PM ) Total Marks: 1

Incase of Context-level Diagram, the system is represented by

Select correct option:



One process atleast

Two processes atleast

One process only

Any number of processes


Question # 8 of 10 ( Start time: 01:22:03 PM ) Total Marks: 1

Data Redundancy Means

Select correct option:



Security of data

Duplication of data

Management of data

Recovery of data


Question # 9 of 10 ( Start time: 01:23:29 PM ) Total Marks: 1

Which levels are mostly used for Detailed DFD?

Select correct option:



Level-0, Level-1

Level-1, Level-2

Level-2, Level-3

Level-3, Level-4


Question # 10 of 10 ( Start time: 01:23:42 PM ) Total Marks: 1

In a three-level DBMS architecture, the ______ level interacts directly with the users.

Select correct option:



external

conceptual

internal

physical

Another Quiz :-

Which of the following might be represented with a multivalued attribute


class location

A primary key is an attribute (or set of attributes) that has been chosen for an entity, whose values are used to uniquely identify a particular instance of an entity. True or false?

True

Data about data is database (true Meta data)

false

A ____ relationship exists when an association is maintained within a single entity.

Unary

Data Redundancy Means

Duplication of data

The entity relationship diagram is used to graphically represent the ____ database model

Physical

The most widely used conceptual model is the ____ model.

ER



ER model meant

enable detailed descriptions of data query processing

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 ____.

primary key

A table can be logically connected to another table by defining a ____.

Common attrinute