We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More


Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

CS403 Database Management Systems Solved MCQs, CS403 Solved Online Quizzes

CS403 Database Management Systems - Virtual University of Pakistan Solve MCQs
Section 1: True/False Questions

 

1.Accurate, relevant, and timely information is the key to good decision making.

 

True False

 

2.Metadata provide the description of the data characteristics but do not describe the set relationships that link the data found within the database.

 

True False

 

3.A database that is primarily designed to support a company’s day-to-day operations is called a data warehouse.

 

True False

 

4.A record is a logically connected set of one or more fields that describes a person, place, or thing.

 

True False

5.The final outcome of a natural JOIN operation yields a table that does not include the unmatched row.

 

True False

 

6.In a relational table, each column represents an attribute and each column has a distinctive name.

 

True False

 

7.In a relational table, each value in a column must conform to the same data format.

 

True False

 

8.A key consists of one or more attributes that determine other attributes.

 

True False

 

9.A primary key can be defined as a superkey with redundancies.

 

True False

 

10.To maintain entity integrity, a null value is permitted in the primary key.

 

True False

 

Section 2: Multiple Choice Questions

Please select only one of the choices (If more than one is selected, it is considered as incorrect)

 

1.The DBMS allows you to extrapolate information from your data by using a(n) ____.

a.query language

b.table generator

c.security system

d.access control

 

2.A ____ system is composed of software, hardware, procedures, and people.

a.software

b.computer

c.file

d.database

 

3.____ are the people who run the organization’s daily operations.

a.End users

b.Managers

c.Database programmers

d.Data practitioners

 

4.Data is/are:

a.information

b.raw facts

c.processed information

d.a DBMS

5.A telephone number, a birth date, and a customer name are all examples of:

a.data

b.a record

c.a file

d.a database

 

6.A logically connected set of one or more fields that describes a person, place, or thing is a(n):

a.data

b.a record

c.a file

d.a database

 

7.Metadata is:

a.raw facts

b.data about data

c.user created data

d.warehoused data

 

 

8.SQL is:

a.a structured query language

b.a sequencing query language

c.a sequencing query listing

d.a structured query listing

 

9.A relational database is a group of ____.

a.common fields

b.field values

c.records

d.tables

 

10.Database models can be grouped into two categories: conceptual models and ____ models.

a.implementation

b.logical

c.physical

d.query

 

11.Each row in the relational table is known as an entity ____.

a.instance

b.relationship

c.attribute

d.model

 

12.Which model represents the end user’s view of the database?

a.Internal

b.Conceptual

c.Physical

d.External

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

a.Conceptual

b.Internal

c.External

d.Physical

 

14.What type of relationship is expressed with the phrase “Painter paints Painting”?

a.1:M

b.1:1

c.M:1

d.M:N

 

15.What type of relationship is expressed with the phrase “Employee manages Store”?

a.1:M

b.1:1

c.M:1

d.M:N

 

16.What type of relationship is expressed with the phrase “Student takes Class”?

a.1:M

b.1:1

c.M:1

d.M:N

 

17.Which of the following is least likely to be a business rule as relates to data modeling?

a.A customer may make many payments on an account.

b.A machine operator may not work more than 10 hours in a 24-hour period.

c.A training session cannot be scheduled for fewer than 10 employees or more than 30 employees.

d.Casual Fridays take place in the summer.

 

18.The entity integrity rule requires that ____.

a.all primary key entries are unique

b.a part of the key may be null

c.foreign key values do not reference primary key values

d.duplicate object values are allowed

 

19.The referential integrity rule requires that ____.

a.every null foreign key value must reference an existing primary key value

b.an attribute have a corresponding value

c.every non-null foreign key value reference an existing primary key value

d.you delete a row in one table whose primary key does not have a matching foreign key value in another table

 

 

20.Each table must have a ____ key.

a.primary

b.secondary

c.foreign

d.logical

 

21.A primary key ____.

a.is a minimal superkey

b.is always the first field in each table

c.must be numeric

d.must be unique

 

22.A relational operator that yields values from all rows in a table is known as the ____ operator.

a.DIFFERENCE

b.PRODUCT

c.SELECT

d.PROJECT

 

23.A relational operator that yields all values from selected attributes is known as the ____ operator.

a.DIFFERENCE

b.PRODUCT

c.SELECT

d.PROJECT

 

24.A relational operator that allows for the combination of information from two or more tables is known as the ____ operator.

a.SELECT

b.PROJECT

c.JOIN

d.DIFFERENCE

 

25.In a relationship, when a primary key from one table is also defined in a second table, the field is referred to as a ____ in the second table.

a.combined key

b.redundant field

c.primary key

d.foreign key

 

26.A relational operator that yields all possible pairs of rows from two tables is known as the ____ operator.

a.UNION

b.INTERSECT

c.DIFFERENCE

d.PRODUCT

 

27.Which of the following statements concerning the primary key is true?

a.All primary key entries are unique.

b.The primary key may be null.

c.The primary key is not required for all tables.

d.The primary key data do not have to be unique.

 

28.In the context of a database table, the statement “A determines B” indicates that ____.

a.knowing the value of attribute A, you cannot look up the value of attribute B

b.you do not need to know the value of attribute A in order to look up the value of attribute B

c.knowing the value of attribute B, you can look up the value of attribute A

d.knowing the value of attribute A, you can look up the value of attribute B

 

29.A ____ is any key that identifies each entity uniquely. It functionally determines all of the entity’s attributes.

a.superkey

b.primary key

c.foreign key

d.combined key

 

30.A superkey that does not contain a subset of attributes that is itself a superkey is called a ____.

a.candidate key

b.primary key

c.superkey

d.secondary key

 

 

Section 3: Fill up the empty space with most appropriate word

 

1.A collection of programs that manages the database structure and controls access to the data stored in the database is called a ______________________________.

DBMS

 

2.A DBMS that supports more than one user is classified as a ____________________ user.

Multi

 

3.____________________, or data about data, through which the end-user data and are integrated and managed.

MetaData

 

4.____________________ exists when different versions of the same data appear in different places.

Data inconsistency

 

5.____________________ refers to the activities that focus on the design of the database structure that will be used to store and manage end-user data.

Database design

 

6.The relationship described by the phrase “the Customer generates the Invoice” is ____________________.

one-to-many

 

7.A(n) ____________________ is a brief, concise, and unambiguous description of a policy.

business rule

 

 

8.The query language for a relational database is _________________________.

SQL, structured query language

 

 

9.A(n) ____________________ consists of one or more attributes that determine other attributes.

key

 

10.Another form of JOIN, known as ____________________, links tables on the basis of an equality condition that compares columns of each table.

 

equijoin

 

Section 4:

Answer the following questions.

 

1.Explain why DBMSs are important in our information-based society.

 

Since data are important, we must have good ways of managing such data. Additionally, a DBMS creates an environment with better access to more and better data, makes it possible for end users to respond quickly to changes in their environment, and makes available data that can be easily transformed into usable information.

 

 

 

2.Explain data redundancy and what it sets the stage for.

 

Data redundancy occurs when the same data is stored in different locations; Redundancy creates data inconsistency, which results from different and conflicting versions of the same data in different places, and data anomalies, as a result of the need to modify the same data in different locations.

 

 

 

3.List the different types of relationships and provide an example of each.

 

There are three types of relationships:

1) One-to-One (1:1) relationships: Employee manages Store

2) One-to-Many (1:M) relationships: Painter paints Painting

3) Many-to-Many (M:N or M:M) relationships: Student takes Class

+ How to Follow the New Added Discussions at Your Mail Address?

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?


See Your Saved Posts Timeline

Views: 171

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

Replies to This Discussion

Question # 4 of 10
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

 

Question # 3 of 10 ( Start time: 11:20:08 AM ) Total M - 1
Which levels are mostly used for Detailed DFD?
Level-0, Level-1
Level-1, Level-2
Level-2, Level-3
Level-3, Level-4

Question # 10 of 10 ( Start time: 11:26:04 AM ) Total M - 1

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

 

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

Question # 6 of 10 ( Start time: 11:22:28 AM ) Total M - 1
Who is responsible for authorizing access to the database, for coordinating and monitoring its use?
Database Designer
Database Administrator

End User
Application Programmer

 

Question # 8 of 10 ( Start time: 11:24:50 AM ) Total M - 1
Incase of Context-level Diagram, the system is represented by
One process atleast
Two processes atleast
One process only

Any number of processes

Question # 3 of 10 ( Start time: 11:29:11 AM ) Total M - 1
User rights information is stored in
Physical database
Catalog

Logical database
Buffer

Question # 4 of 10 ( Start time: 11:30:04 AM ) Total M - 1
The Entity Relation Model models
Entities, Relationships and Processes
Entities and Relationships

Relationships
Entities

Question # 6 of 10 ( Start time: 11:30:35 AM ) Total M - 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

Incase 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

 A software package designed to store and manage databases

Database
DBMS

Data model
Data

A relational database is

one that consists of two or more tables
a database that is able to process tables, queries, forms, reports and macros
one that consists of two or more tables that are joined in some way
the same as a flat file database

 

Which model operates at the lowest level of abstraction?

conceptual
internal
external
physical

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

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

Question # 1 of 10 ( Start time: 03:56:32 PM ) Total M - 1
A relational database is
Select correct option:


one that consists of two or more tables
a database that is able to process tables, queries, forms, reports and macros
one that consists of two or more tables that are joined in some way
the same as a flat file database

Quiz Start Time: 03:56 PM
Time Left 87
sec(s)
Question # 3 of 10 ( Start time: 
03:58:44 PM ) Total M - 1
Which one of the following is NOT a characteristic of meta data?
Select correct option:
Data about data
Describes a data dictionary
Self-describing
Includes user data

 

 

An entity type is

a. defined when the database is actually constructed
b. a specific type such as an integer, text, date, logical etc
c. a coherent set of similar objects that we want to store data on (e.g. STUDENT, COURSE, CAR)
d. defined by the database designer

 

Question # 4 of 10 ( Start time: 05:08:26 PM ) Total M - 1
Which of the following is INCORRECT statement concerning the database design process?
Select correct option:
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.

 

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

 

 

Question # 7 of 10 ( Start time: 05:11:48 PM ) Total M - 1
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

 

 


Quiz Start Time: 03:56 PM
Time Left 89
sec(s)
Question # 9 of 10 ( Start time: 05:13:37 PM ) Total M - 1
A Foreign Key is
Select correct option:
A field in a table that matches a key field in another table
A field in a table that contains data that is also contained elsewhere in another table
A field in a table that has the same name as a key field in another table
A field in a table that has the same name as a key field in another table

 

 

Question # 10 of 10 ( Start time: 05:15:08 PM ) Total M - 1
Which model operates at the lowest level of abstraction?
Select correct option:
conceptual
internal
external
physical

Question # 1 of 10 ( Start time: 05:35:55 PM ) Total M - 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

CS403 100% Solved MCQ from Book

1         

Which of the following is a service provided by a DBMS?

 

            A)        It ensures and enforces data integrity at all levels

            B)        It maintains an environment in which security is created and enforced

            C)        It manages the metadata in the data dictionary

            D)        All of the above are services of a DBMS

 

2         

What is the difference between a DBMS and an RDBMS?

 

            A)        A RDBMS uses metadata while a DBMS does not.

 

            B)        A DBMS is used for data warehousing.

 

            C)        Because a relational database is more complicated than a conventional database, the RDBMS requires much more computing power than the conventional DBMS requires.

 

            D)        Because a conventional database is less complicated than a relational database, the DBMS is used more often for transactional databases.

 

3                     

Which of the following statements best describes a data warehouse?

 

            A)        A data storage facility dedicated to using the existing data to generate information.

         B)        Frequent and complex transactions characterize its use.

            C)        The most common type of database in use today.

            D)        Generally used in environments with large inventories, thus the term warehouse.

 

 

4         

Which of the following justifies the inclusion of derived attributes in a database?

 

            A)        Inclusion of derived attributes is a standard procedure and does not require justification.

            B)        Derived attributes should be used when they add to design elegance.

            C)        Query speed is enhanced by not computing derived attributes.

            D)        Poor design is the only excuse for the inclusion of derived attributes.

 

 

5         

Select the statement that best defines a candidate key.

 

            A)        An attribute or combination of attributes that allows the user to search for non-unique data.

            B)        An attribute or combination of attributes that is calculated from existing data.

            C)        An attribute or combination of attributes that establishes relationships between tables.

            D)        An attribute or combination of attributes that could be, but is not, used as a PK

RSS

© 2020   Created by +M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service

.