CS-403
Quiz Dated 14-11-2011
Within a table, each primary key value __.
Select correct option:
is a minimal superkey
is always the first field in each table
must be numeric
must be unique
reign 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
Which of the following might be represented with a single-valued attribute?
Select correct option:
person's phone number (Please Check)
car's color
employee's educational background
computer's processor speed (Please Check)
Which of the following constraints enforces entity integrity?
Select correct option:
PRIMARY KEY
FOREIGN KEY
CHECK
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
Data about data is database
Select correct option:
True Please Check)
False
Partially True
None of the Above
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
The most widely used conceptual model is the __ model.
Select correct option:
implementation
ER
Object Oriented
internal
Which model operates at the lowest level of abstraction?
Select correct option:
conceptual
internal
external
physical
MC100200808 : Irsa Anum
Question # 1 of 10 ( Start time: 08:47:14 PM ) Total Marks: 1
Which of the following describes a database system?
Select correct option:
A collection of stored operational data used by the application system of some particular enterprise
A shared collection of logically related data (and a description of this data) designed to meet the information needs of an organisation
A collection of stored data organised in such a way that all user requirements are satisfied by the database. In general there is only one copy of each item of data although there may be controlled repetition of some data.
All of the above
Question # 2 of 10 ( Start time: 08:47:42 PM ) Total Marks: 1
Data inconsistency leads to a number of problems such as
Select correct option:
loss of information and incorrect results
less secure data
redundant data
Slow database development
Question # 3 of 10 ( Start time: 08:48:15 PM ) Total Marks: 1
Which of the following constraints enforces entity integrity?
Select correct option:
PRIMARY KEY
FOREIGN KEY
CHECK
NOT NULL
Question # 4 of 10 ( Start time: 08:49:22 PM ) Total Marks: 1
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 data
Question # 5 of 10 ( Start time: 08:50:09 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 # 6 of 10 ( Start time: 08:51:30 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 # 7 of 10 ( Start time: 08:52:12 PM ) Total Marks: 1
Which of the following is correct regarding Dataflow diagram?
Select correct option:
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
Question # 8 of 10 ( Start time: 08:52:55 PM ) Total Marks: 1
The most widely used conceptual model is the __ model.
Select correct option:
implementation
ER
Object Oriented
internal
Question # 9 of 10 ( Start time: 08:53:15 PM ) Total Marks: 1
Data about data is metadata
Select correct option:
True
False
Question # 10 of 10 ( Start time: 08:54:13 PM ) Total Marks: 1
Data Redundancy Means
Select correct option:
Security of data
Duplication of data
Management of data
Recovery of data
Syed M. Umair Saulat
Cs403- Quiz Dated 14-11-2011 Time 9.00 PM
Data inconsistency leads to a number of problems such as
Select correct option:
loss of information and incorrect results
less secure data
redundant data
Slow database development
most widely used conceptual model is the __ model.
Select correct option:
implementation
ER
Object Oriented
internal
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
In an ERD, the focus is on the __ and the relationships between them.
Select correct option:
attributes
entities
keys
indexes
An entity type is
Select correct option:
defined when the database is actually constructed
a specific type such as an integer, text, date, logical etc
User rights information is stored in
Select correct option:
Physical database
Catalog
Logical database
Buffer
Which of the following might be represented with a multivalued attribute?
Select correct option:
person's name
class location (Not Confirm)
bank account balance
book title
Which of the following is correct regarding Dataflow diagram?
Select correct option:
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
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 (Please Check)
Logical data independence (Please Check)
Functional dependency
Concurrency control
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 data
Zindagi mein 2 Logo ka buhat khayal rahkoooo
2nd woh jiss ko tum ney har dukh me pukaara hoo (Mother)
--
Join us at facebook: https://www.facebook.com/VU.Study.Corner
Group Link: http://groups.google.com/group/VU-Study-Corner?hl=en
Group Rules: http://groups.google.com/group/VU-Study-Corner/web/group-rules
Unsubscribe: VU-Study-Corner+unsubscribe@googlegroups.com
Adult contents, Spamming, Immoral & Rudish talk, Cell number, Websites & Groups links specially in paper days are strictly prohibited and banned in group.
No comments:
Post a Comment