::::|| VU ||:::: Re: (VU Structure) CS403 CURRENT quizez SOlved by 4funkar bro and teAM :)

Thank you 

On Mon, Apr 23, 2012 at 3:14 PM, .·´`·.·´¯`·.›+SiD kHAN+.·´`·.·´¯`·.› <irzak93@gmail.com> wrote:

CS403 CURRENT quizez SOlved by 4funkar bro and teAM :)


User rights information is stored in
Select correct option:

Physical database
Catalog
Logical database
Buffer

description on a particular collection of data using the given data model
Select correct option:

Database
Relation
Schema
None

12:48 PM bc100400662asad: 3

 me: 3

  In a three-level DBMS architecture, the ____ level interacts directly with the users.
Select correct option:

external
conceptual
internal
physical

12:49 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

12:50 PM inconsistency means, data at one place is changed and not at other,

  it results wrong

  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

12:51 PM

  The database management system (DBMS) is used to
Select correct option:

Store the data
Access the data
Manage its users
All of above

  : Which of the following constraints enforces entity integrity?
Select correct option:

PRIMARY KEY
FOREIGN KEY
CHECK
NOT NULL

 

                Which model operates at the lowest level of abstraction?

Select correct option:

conceptual
internal
external
physical

 azahid86: 4

12:54 PM : 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

 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

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

 Entity Relation Model models
Select correct option:

Entities, Relationships and Processes
Entities and Relationships
Relationships
Entities

 
 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

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

Database
Relation
Schema
None

 
The most widely used conceptual model is the __ model.
Select correct option:

implementation
ER
Object Oriented
internal

 

1:03 PM A collection of concepts that can be used to describe the structure of a database
Select correct option:

Database

DBMS

Data model

Data

 
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

 
Which of the following describes the job of a database administrator?
Select correct option:

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

1:05 PMWhich 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 Entity Relation Model models
Select correct option:

Entities, Relationships and Processes
Entities and Relationships
Relationships
Entities

  
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.

 

  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

1:12 PM

 Data Redundancy Means
Select correct option:

Security of data
Duplication of data
Management of data
Recovery of data

 
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

1:14 PMWhich of the following is NOT a component of a DFD?
Select correct option:

Dataflow
Datastore
External entities
Relationship between external entities

 
Each table must have a __ key.
Select correct option:

primary
secondary
logical
foreign

 

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

Database

DBMS

Data model

Data

  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

1:19 P

  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

1:22 PM
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

1:23 PM
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

1:24 PM 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
a coherent set of similar objects that we want to store data on (e.g. STUDENT, COURSE, CAR)

defined by the database designer

 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

 
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

 

                  Which of the following is a feature of CHECK constraint?

Select correct option:

limit the values that can be placed in a column.
used to enforce referential integrity.
enforces the uniqueness of the values in a set of columns.
is a unique identifier for a row within a database table.

 

                       Data about data is database

Select correct option:

True
False
Partially True
None of the Above

 

--
www.vufanz.com

All about fun and entertainmnt!

created by us(vitals gruop)

--
You received this message because you are subscribed to the Google Groups "VU Structure" group.
To post to this group, send email to vu-structure@googlegroups.com.
To unsubscribe from this group, send email to vu-structure+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/vu-structure?hl=en.

--
For study materials, past papers and assignments,
Join VU School at www.vuscool.com
 
Facebook Group link
http://www.facebook.com/groups/vuCoooL
 
CoooL Virtual University Students Google Group.
To post to this group, send email to coool_vu_students@googlegroups.com
 
home page
http://groups.google.com/group/coool_vu_students?hl=en