Cs403 Quiz No.1 Nov 14, 2012

On Wed, Nov 14, 2012 at 1:39 PM, JUGNO <m.abdullah.n@gmail.com> wrote:

Jazaak Allah bahi jaan

Umair Saulat <saulat.umair@gmail.com> wrote:

>*
>**CS-403- Database Management System***
>
>*Quiz No.1 Dated 14-12-2012*
>
>
>
>Within a table, each primary key value *__*.*
>*Select correct option:
>is a minimal super key
>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           *
>
>
>
>
>
>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
>*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*
>
>
>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
>
>
>
>
>
>
>
>
>
>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
>
>
>
>Which of the following constraints enforces entity integrity?
>Select correct option:
>*PRIMARY KEY
>*FOREIGN KEY
>CHECK
>NOT NULL
>
>
>
>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
>
>
>
>
>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
>
>
>
>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*
>
>
>
>
>
>The most widely used conceptual model is the *__* model.
>Select correct option:
>implementation
>*ER
>*Object Oriented
>internal
>
>
>
>Data about data is metadata
>Select correct option:
>*True
>*False
>
>
>Data Redundancy Means
>Select correct option:
>Security of data
>*Duplication of data
>*Management of data
>Recovery of data
>
>
>
>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
>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
>
>
>
>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
>
><http://groups.google.com/group/vuZs>
>
>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
>defined when the database is actually constructed
>specific type such as an integer, text, date, logical etc
>*coherent set of similar objects that we want to store data on (e.g.
>STUDENT, COURSE, CAR)*
>defined by the database designer
>
>
>
>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.
>
><http://groups.google.com/group/vuZs>
>
>
>
>
>
>
>
>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
>
>
>
>
>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 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 a r k s: 1
>
> Which model operates at the lowest level of abstraction?
>Select correct option:
>conceptual
>internal
>external
>*physical*
>
>
>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*
>
>Question # 3 of 10 ( Start time: 11:20:08 AM ) Total M a r k s: 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
>
><http://groups.google.com/group/vuZs>
>
>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 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
>
>
>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
>
><http://groups.google.com/group/vuZs>
>
>Question # 8 of 10 ( Start time: 11:24:50 AM ) Total M a r k s: 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
>
>
>User rights information is stored in
>Select correct option:
>
>Physical database
>*Catalog*
>Logical database
>Buffer
>
><http://groups.google.com/group/vuZs>
>
>The Entity Relation Model models
>Select correct option:
>
>Entities, Relationships and Processes
>*Entities and Relationships*
>Relationships
>Entities
>
>
>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
>
>
>
>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
>
><http://groups.google.com/group/vuZs>
>
>Which model operates at the lowest level of abstraction?
>
>conceptual
>internal
>external
>*physical*
>
>
>
>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
>
>
>
>
>
>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
>
><http://groups.google.com/group/vuZs>
>
>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
>
>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 <http://groups.google.com/group/vuZs>
>
>
>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 <http://groups.google.com/group/vuZs>
>
>
>
>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:
>super key
>candidate key
>*primary key*
>secondary key
>
>
>
>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
>
>--
>To post to this group, send email to vuhelp_pk@googlegroups.com
>To unsubscribe from this group, send email to vuhelp_pk+unsubscribe@googlegroups.com
>
>
>Group Rules Vuhelp4u
>Sharing of Video songs links, movies links, dramas links are not allowed in study group. Only Islamic and general information Video links allowed.
>SPAM, Advertisement, and Adult messages are NOT allowed and that member will be behaved strictly.
>http://groups.google.com/group/vuhelp_pk?hl=en_US

--
-- 
For Virtual University of Pakistan Study Material Sharing, Discussion, etc, Come and join us at http://4e542a34.linkbucks.com
You received this message because you are subscribed to the Google
Groups "Virtual Position" group.
To post to this group, send email to virtualposition@googlegroups.com
For more options, visit this group at
http://004bbb67.any.gs