CS403-Database Management System | Mid-Term Grand Quiz Fall 2021

 

MID-TERM GRAND QUIZ
 FALL 2020 (Paper 1)

Question No 1:

The RDM (Raise For Success)(Relational Data Model) is popular due to its two major strengths and they are _______.

• Complexity/Easy Mathematical Foundation
• Complexity/Weak Mathematical Foundation
• Simplicity/Strong Mathematical Foundation Correct
• Simplicity/Weak Mathematical Foundation

Question No 2:

Database relation (Raise For Success) is also represented in a two dimensional structure called _______.

• Flow
• Table Correct
• Entity
• Column

Question No 3:

Which of the (Raise For Success) following is NOT a component of a DFD?

• Dataflow
• Datastore
• External entities
• Relationship between external entities Correct

Question No 4:

In natural join (Raise For Success) the common attribute in the output table appears _______.

• Twice
• Three times
• Four times
• Once Correct

Question No 5:

Which model (Raise For Success) operates at the lowest level of abstraction?

• conceptual
• internal
• external
• physical Correct

Question No 6:

Conceptual database (Raise For Success) design, expressed in E-R data model can be implemented using any _______.

• Data model
• Operating system
• Software
• Database Management System (DBMS) Correct

Question No 7:

The Three levels (Raise For Success) architecture is useful for ______.

• Arranging the data in an organized manner.
• Hiding the details if internal systems. Correct
• Breaking the data access restriction.
• Storing definitions of the structures.

Question No 8:

The attribute (Raise For Success) AGE is calculated from DATE_OF_BIRTH. The attribute AGE is a.

• Single valued
• Multi valued
• Composite
• Derived Correct

Question No 9:

Which levels (Raise For Success) are mostly used for Detailed DFD?

• Level-0, Level-1 Correct
• Level-1, Level-2
• Level-2, Level-3
• Level-3, Level-4

Question No 10:

Recursive (Raise For Success) relationship is also called ______.

• Unary Correct
• Ternary
• Primary
• Secondary

Question No 11:

Which of the (Raise For Success) following is a feature of CHECK constraint?

• limit the values that can be placed in a column. Correct
• used to enforce referential integrity.
• enforces the uniqueness of the values in a set of columns.
• is a unique identifier for a row within a database table.

Question No 12:

Consider the (Raise For Success) key "CNIC, Name" and choose the best option that describes the most effectively.

• The given key is a super key and alternate key. Correct
• The given key is not a super key but a candidate key.
• The given key is a super key and candidate key as well.
• The given key is a super key but not a candidate key.

Question No 13:

In Cross (Raise For Success) Reference Matrix attributes are specified on ______.

• X axis Correct
• Y axis
• Z axis
• None of the above

Question No 14:

Unary relationship (Raise For Success) involve a single entity it is also called _________.

• One to one relationship
• One to many relationship
• Many to many relationship
• Recursive relationship Correct

Question No 15:

If an entity (Raise For Success) "motor cycle" is associated with at most one "driver". then the relationship between these two entities is:

• One to one
• One to many
• Many to many
• Many to one Correct

Question No 16:

Which of the (Raise For Success) following is INCORRECT statement, about database design process?

• During requirements collection and analysis phase, one can gather the data requirements of database users.
• By referring to a high level data model, it is possible to understand the data requirements of the users, entity types, relationships and constraints. Correct
• Transformation of the high level data model is called logical design or data model mapping.
• During the logical design phase of internal storage structure, access paths and file organization for the database files are specified.

Question No 17:

Which of the (Raise For Success) following is the second stage in the Database Development Process?

• Database Design
• Preliminary Study
• Physical Design Correct
• Requirement Analysis

Question No 18:

In a three-level (Raise For Success) DBMS architecture, the _____ level interacts directly with the users.

• external Correct
• conceptual
• internal
• physical

Question No 19:

We have two (Raise For Success) entities "Person" and "Doctor". Which of the following is best suitable type of relationship between the mentioned entities?

• Inheritance Correct
• Sub type
• Super type
• Unary

Question No 20:

Normalization is (Raise For Success) a process of restructuring a relation to.

• minimize duplication of data in a database. Correct
• maximize duplication of data to ensure reliability.
• make it of uniform size.
• allow addition of data.

Question No 21:

If A ->B and A ->C, then A ->BC

The inference (Raise For Success) Rules applies is:

• Union Correct
• Decomposition
• Augmentation
• Reflexivity

Question No 22:

The attribute (Raise For Success) whose value is not stored in a database is known as ________ attributive.

• Stored
• Single value
• Multi value Correct
• Derived 

Question No 23:

Which feature of (Raise For Success) database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?

• User accessible catalog
• Data processing
• Recovery service Correct
• Authorization service

Question No 24:

Student and (Raise For Success) Book are two entities, what is the cardinality between the two?

• Many to One
• One to Many
• Many to Many Correct
• One to One  

Question No 25:

The basic purpose (Raise For Success) of Diamond in ER diagram is to show the _______.

• Attributes
• Relationship Correct
• Composite attribute
• Entity set

Question No 26:

The ________ specifies (Raise For Success) that an entity can be a member of only one subtype at a time.

• exclusion
• disjoint Correct
• removal
• inclusion

Question No 27:

Data about (Raise For Success) data is called meta data.

• True Correct
• False

Question No 28:

A relationship (Raise For Success) database is ________.

• One that consists of Objects
• A database that is able to process tables, queries, Forms, reports, macros and objects
• one that consists of two or more tables that are Joined in some way Correct
• The same as a flat file database

Question No 29:

An attribute that (Raise For Success) is the collection of some other attribute(s) is known as ________ attribute.

• Multi-valued
• Single-valued
• No-valued
• Composite Correct

Question No 30:

 If an entity is (Raise For Success) linked with itself, then it is called ______ relationship.

• Binary
• Ternary
• Nary
• Recursive Correct