Quiz No.1 of CS403 - Database Management Systems

[Student S]

Quiz No.1

Dated: Nov 18, 14

Dear Students,   Quiz # 1 will start from Monday, 24th November, 2014 and will remain open for two days the last day will be Tuesday, 25th November, 2014. The lectures included in this quiz will be from Lecture # 1 to Lecture # 10.   Read the following instructions carefully before attempting the Quiz.   · Quiz will be based upon Multiple Choice Questions. · You have to attempt the quiz online. · You can start attempting the quiz any time within given date(s) of a particular subject by clicking the link for Quiz in LMS. · It will be opened only for Two days (48 Hours). All overseas students should manage their quiz time according to Pakistan Standard Time (PST). · The time to attempt the Quiz is limited. Once you login to attempt the quiz, the countdown will start and you have to complete the quiz in given amount of time. So always keep an eye on the remaining time. · Attempting quiz is unidirectional. Once you move forward to the next question, you cannot come back to the previous one. Therefore before moving to the next question, make sure that you have selected the best option. · If due to any reason, access to internet is lost (like power failure or disconnection of internet), you will be able to attempt the quiz again from the position where you left in last attempt. But remember that you have to complete the quiz before expiry of the deadline.   If any student failed to attempt the quiz in given time then no re-take or offline quiz will be held.

[+ M.Tariq Malik]

Please all students related this subject Share your online Quizzes here to help each other.thanks

 

Please share the question and their answers of this quiz if anyone has done.
Thanks. 

[black]

correct really true....

[Student S]

Here are some quizez

[+ M.Tariq Malik]

Sana Malik gud keep it up & thanks for sharing 

[Student S]

Here is one more Quiz File

[+ Ahmad]

Subject: CS 403 | Quiz No 1 | Date: 25 Nov, 2014

1. Identify that which of the following is not an entity.

Employee
hoby
Child
Playground

2. User rights information is stored in

Physical database
Catalog
Buffer
Logical database

3. Which of the following describe best describe the data security in DBMS?

Efficient check on all users’ access
Multiple users accessing the data at the same time
User can access his previously stored data even if some website is hacked
Changes made to one location are automatically updated to another location

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

superkey
candidate key
primary key
secondary key

5. Suppose we have two entities department and University. What type of dependency exists between these two entities?

Integral
Referential
Existence
Identifier

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

Database
DBMS
Data model
Data

7. By hiding data from all

Through concurrent access of users
By asking users not to share things
Implementing encryption algorithms

8. Within a table, each primary key value ____.

is a minimal superkey
is always the first field in each table
must be numeric
must be unique

9. In which stage of the database development process logical design is created?

Requirement analysis
Database design
Implementation
Physical design

10. Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?

User accessible catalog
Data processing
Recovery service
Authorization service

[+ Ahmad]

11. Entities, Relationships and Processes

Entities and Relationships
Relationships
The Entity Relation Model models
Entities

12. The database deals with large amount of data. This property is called

Database design
Concurrency
Scalability
Robustness

13. Which of the following describes the job of a database administrator?

Development, implementation operation of the physical database
Creation of the system catalog
Monitoring and controlling database security and authorization: Setting up controls to ensure the quality and integrity of data
All of the above

14. Within a table, each primary key value ____.

is a minimal superkey
is always the first field in each table
must be numeric
must be unique

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

One process atleast
Two processes atleast
One process only
One process atleast

16. Which of the following is INCORRECT about naming entities?

Singular nouns are used
Write in capitals
Organization specific names can be used
Always use abbreviations as they are convenient

17. Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of

Physical data independence
Functional dependency
Logical data independence
Concurrency control

18. In Cross Reference Matrix attributes are specified on _______

X axis
y axis

19. In which stage of the database development process logical design is created?

Requirement analysis
Database design
Physical design
Implementation

20. Data about data is database

True
False

21. ___________ is most difficult to change when a database is created

Extension
Intention
Expansion
Indentation

22. Which model operates at the lowest level of abstraction?

conceptual
internal
physical
external

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

DBMS
Database
Data
Data model

24. Which of the following constraints enforces entity integrity?

PRIMAY KEY
FOREIGN KEY
CHECK
NOT NULL

25. Suppose we have two entities department and University. What type of dependency exists between these two entities?

IntegralIntegral
Existence
Referential

26. Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of

Physical data independence
Logical data independence
Functional dependency
Concurrency control

[muhammad siddique]

what is the answer of these quizes.

[muhammad siddique]

Here is the mid term papers enjoy 85% in paper is in these papers inshAllah.

[M Rizy Ramay]

The ER model is meant to
Select correct option:

replace relational design
be close to a users perception of the data
enable low level descriptions of data
enable detailed descriptions of data query processing

 

Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?
Select correct option:

User accessible catalog
Data processing
Recovery service
Authorization service

A relational database system is based on the concept(s) of:
Select correct option:

A network of data records
Nested tables
Tables, rows and columns
A tree-like structure of datas

 

Question # 1 of 10 ( Start time: 05:35:55 PM ) Total M a r k s: 1
Controlling redundancy in a database management system DOES NOT help to
Select correct option:
avoid duplication
avoid unnecessary wastage of storage space
avoid unauthorised access to data
avoid inconsistency among data

 

 

 

Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of
Select correct option:
Physical data independence
Logical data independence
Functional dependency
Concurrency control

 

 

 

A description on a particular collection of data using the given data model
Select correct option:
Database
Relation
Schema
None

 

 

 

 

Which of the following functions are NOT performed by a database administrator?
Select correct option:
Planning, designing and implementing database systems
Establishing standards and procedures for database systems
Communicating with database users
Allocation of storage locations and data structures

 

 

 

A collection of concepts that can be used to describe the structure of a database
Select correct option:
Database
DBMS
Data model
Data

 

 

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

 

ncase 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

[M Rizy Ramay]

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

hyperlink
common attribute
primary key
 superkey

 

Which of the following is INCORRECT statement concerning the 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.
Transformation of the high level data model into the implementation data model is called logical design or data model mapping.
During the logical design phase of internal storage structures, access paths and file organization for the database files are specified.

 

 

Which of the following is correct regarding Dataflow diagram?

Single DFD is required to represent a system
Created at increasing levels of detail
The dataflow must be bidirectional
Used to represent the relationships among the external entities

 

A collection of concepts that can be used to describe the structure of a database
Database
DBMS
Data model
Data

 

Who is responsible for authorizing access to the database, for coordinating and monitoring its use?
Select correct option:

Database Designer
Database Administrator
End User
Application Programmer

 

A software package designed to store and manage databases
Select correct option:

Database
DBMS
Data model
Data

 

 

The main software package that supports a database management approach is called
Select correct option:

Data Dictionary
Report Generator
Database Management System
Distributed database

 

 

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 # 6 of 10 ( Start time: 11:30:35 AM ) Total M a r k s: 1
Which of the following is NOT a component of a DFD?
Select correct option:

Dataflow
Datastore
External entities
Relationship between external entities

 

A________is used to maintain a connection between the users of the database system.
Select correct option:

mail server
file server
client-server
none of the given

 

 

An instance is
Select correct option:

a particular occurance of an entity
a special type of relation
an attribute of an entity
any particular entity

 

 

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
False
Partially True
 None of the given

 

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

One process atleast
Two processes atleast
One process only
Any number of processes

 

An entity type is

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

Data about data is database

True
False
Partially True
None of the Above

[Jinn]

Here is mine