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
--
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
No comments:
Post a Comment