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.
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
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
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:
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
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
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.
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
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
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
Which model operates at the lowest level of abstraction?
Select correct option:
conceptual
internal
external
physical
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
Select correct option:
Database Designer
Database Administrator
End User
Application Programmer
A software package
designed to store and manage databases
Select correct option:
Database
DBMS
Data model
Data
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
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
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
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
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
Select correct option:
A network of data records
Nested tables
Tables, rows and columns
A tree-like structure of datas
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
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
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
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
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
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
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
Select correct option:
One process atleast
Two processes atleast
One process only
Any number of processes
SQL
stands for ______________.
I -
Structured Query Language
II –
Standard Query Language
lll- Status
Query Language
Only I
Only II
Both I and
II
Only lll
Making
a change to the conceptual schema of a database but not affecting the
existing external
schema is an example of
Physical
data independence.
Concurrency control.
Logical data independence.
Functional dependency
Concurrency control.
Logical data independence.
Functional dependency
Logical data
independence
Logical data
independence provides the independence in a way that
changes in
conceptual model do not af fect the external views. Or
simply i t can
be stated at the Immunity of external level f rom
changes at
conceptual level .
SQL
data types do not have support for storing multi-media objects directly.
True
False
Truncate
is an alternative of Delete command.
True
False
What
happens if the WHERE clause is omitted from a DELETE statement?
All records from the table are deleted
No record
from the table will be deleted
First record
of the table will be deleted
The
statement will not be executed and will give a syntax error
Query
Analyzer is used to practice SQL in MS-Access and MS-SQL Server.
True
False
Which
of the following is used to retrieve and insert information from database?
DML
DDL
DCL
Both DML and
DDL
SQL commands
that allow for the manipulation of data in the database, such as SELECT,
INSERT, DELETE, and UPDATE.
Which
of the following can not be included into CREATE TABLE statement?
Data types
Constraints
Attributes
Cardinalities
Which
of the following is NOT a DDL command?
Create DB
Create table
Delete
Drop
Which
of the following SQL statements used to control access to the data and to the
database?
GRANT
REVOKE
Both GRANT and REVOKE
SELECT
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?
Select
correct option:
conceptual
internal
external
physical
A________is
used to maintain a connection between the users of the database system.
mail server
file server
client-server
none of the
given
A f i le server
is used
to maintain a
connection between the users of the database system.
Each cl ient of
the network runs its own copy of the DBMS and the
database
resides on the f i le server .
A
collection of concepts that can be used to describe the structure of a database
Database
DBMS
Data model
Data
Data model is a
set or collection of construct used for creating a database and producing
designs for the databases
Data
about data is metadata
True
False
Database is
a data structure that stores metadata, i.e. data about data. More
generally we can say an organized collection of information.
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
False
Partially
True
None of the
given
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.
These things
are done at physical design stage not at logical design stage. At logical
design stage we are concerned about schema structures.
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
Who
is responsible for authorizing access to the database, for coordinating and
monitoring its use?
Database
Designer
Database Administrator
End User
Application
Programmer
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 orFalse?
True
False
Partially
True
None of the
given
Which
of the following describes the job of a database administrator?
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
Which
of the following is NOT a component of a DFD?
Dataflow
Datastore
External
entities
Relationship between external entities
The
Entity Relation Model models
Entities,
Relationships and Processes
Entities and Relationships
Relationships
Entities
Data
about data is database
True
False
Partially
True
None of the
Above
Database is
a data structure that stores metadata, i.e. data about data. More
generally we can say an organized collection of information
A relational database system is based on the concept(s) of:
A relational database system is based on the concept(s) of:
A
network of data records
Nested
tables
Tables, rows
and columns
A tree-like
structure of data
most commercial
DBMS are based on the record-based data models, like Hierarchical, Network or
Relational.
Data
Manipulation Language (DML) is the set of commands used to maintain and query a
database including updating, inserting, modifying and retrieving data.
True
Fasle
Fasle
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.
www.
.infowww. .info
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
Normalizing the Database table Structures
1
A __________
is established when the value of one attribute is dependent on the value of
another attribute.
A) primary
key
B) data
anomaly
C) dependency
D) transitive
relationship
Post a Comment
Don't Forget To Join My FB Group VU Vicky
THANK YOU :)