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
Foreign Key is
Select correct option:
A field in a table that matches a key field in another tableA 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
Vukwl- Virtual Education Solution
The Entity Relation Model models
Select correct option:
Entities, Relationships and Processes
Entities and Relationships
Relationships
Entities
Database Application is a program which is used for performing certain operations such as
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
Level of data at which entities or objects exist in reality is called
Real world data
Schema for real world data
Meta data
Data about data
Which model operates at the lowest level of abstraction?
conceptual
internal
external
physical
Data Redundancy Means
Select correct option:
Security of data
Duplication of data
Management of data
Recovery of data
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 used with INSERT command to insert values in a DB table?
Select correct option:
ONTO
INTO
UPTO
WITH
CREATE TABLE and CREATE index belongs to which type of SQL commands
Select correct option:
DML
DDL
DCL
DQL
Question # 9 of 10 ( Start time:09:55:59 PM) Total M - 1
In SQL, which command is used to modify the rows of tables.
Select correct option:
UPDATE
INSERT
BROWSE
APPEND
Which of the following is a correct way of selecting all the columns from a table called PERSONS?
Select correct option:
SELECT FROM * Persons
SELECT * FROM Persons
SELECT * WHERE Persons
SELECT WHERE * Persons
Question # 3 of 10 ( Start time:09:53:51 PM) Total M - 1
The ________ operator allows to use wild cards in the where clause of an SQL statement.
Select correct option:
IN
FROM
LIKE
None of the above.
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 table can be logically connected to another table by defining a ____.
hyperlink
common attribute
primary key
superkey
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
Vukwl- Virtual Education Solution
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
ncase of Context-level Diagram, the system is represented by
One process atleast
Two processes atleast
One process only
Any number of processes
An entity type is
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
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
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?
conceptual
internal
external
physical
An entity type is
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
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.
Vukwl- Virtual Education Solution
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
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
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
Vukwl- Virtual Education Solution
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
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
Question # 1 of 10 ( Start time: 05:35:55 PM ) Total M a r k s: 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
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
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
User rights information is stored in
Select correct option:
Physical database
Catalog
Logical database
Buffer
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
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 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
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
In a three-level DBMS architecture, the ______ level interacts directly with the users.
Select correct option:
external
conceptual
internal
physical
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 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
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.
User rights information is stored in
Select correct option:
Physical database
Catalog
Logical database
Buffer
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
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 of the following statements creates a database named IMDB.
Select correct option:
CREATE DATABASE IMDB;
Question # 2 of 10
Which of the following is a correct way of selecting all the columns from a table called PERSONS?
Select correct option:
SELECT FROM * Persons
SELECT * FROM Persons
Question # 3 of 10
Which of the following is not a part of an INSERT statement?
Select correct option:
INTO
VALUES
INSERT
MODIFY
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
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________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
What happens if the WHERE clause is omitted from a DELETE statement?
Select correct option:
All records from the table are deleted
Question # 8 of 10
What does the abbreviation DBMS stand for?
Select correct option:
Database Manipulation Software.
Data Borrowing and Movement Software
Digital Base Mapping System.
Database Management System.
Within a table, each primary key value __.
is a minimal superkey
is always the first field in each table
must be numericmust be unique
Question # 3 of 10 ( Start time: 11:20:08 AM ) Total M - 1
Which levels are mostly used for Detailed DFD?Level-0, Level-1
Level-1, Level-2
Level-2, Level-3
Level-3, Level-4
Question # 10 of 10 ( Start time: 11:26:04 AM ) Total M - 1
Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?
User accessible catalog
Data processingRecovery service
Authorization service
False
Partially True
None of the given
Question # 9 of 10
Which of the following is used to filter rows according to some condition(s)?
Select correct option:
SELECT
FROM
WHERE
Question # 10 of 10
REATE TABLE and CREATE index belongs to which type of SQL commands
Select correct option:
DML
DDL
DCL
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
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
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
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
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
ncase of Context-level Diagram, the system is represented by
One process atleast
Two processes atleast
One process only
Any number of processes
An entity type is
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
Data about data is database
True
False
Partially True
None of the Above
A collection of concepts that can be used to describe the structure of a database
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
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
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:
User accessible catalog
Data processing
Recovery service
Authorization service
Select correct option:
A network of data records
Nested tables
Tables, rows and columns
A tree-like structure of datas
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
Select correct option:
Physical data independence
Logical data independence
Functional dependency
Concurrency control
Select correct option:
Database
Relation
Schema
None
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:
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
User rights information is stored in
Select correct option:
Physical database
Catalog
Logical database
Buffer
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
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 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
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
In a three-level DBMS architecture, the ______ level interacts directly with the users.
Select correct option:
external
conceptual
internal
physical
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 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
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.
User rights information is stored in
Select correct option:
Physical database
Catalog
Logical database
Buffer
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
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 of the following statements creates a database named IMDB.
Select correct option:
CREATE DATABASE IMDB;
CREATE DB IMDB;
ADD DATABASE named IMDB;
CREATE IMDB DATABASE;
Question # 2 of 10
Which of the following is a correct way of selecting all the columns from a table called PERSONS?
Select correct option:
SELECT FROM * Persons
SELECT * FROM Persons
SELECT * WHERE Persons
SELECT WHERE * Persons
Question # 3 of 10
Which of the following is not a part of an INSERT statement?
Select correct option:
INTO
VALUES
INSERT
MODIFY
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
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________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
What happens if the WHERE clause is omitted from a DELETE statement?
Select correct option:
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
Question # 8 of 10
What does the abbreviation DBMS stand for?
Select correct option:
Database Manipulation Software.
Data Borrowing and Movement Software
Digital Base Mapping System.
Database Management System.
Within a table, each primary key value __.
is a minimal superkey
is always the first field in each table
must be numericmust be unique
is a minimal superkey
is always the first field in each table
must be numericmust be unique
Question # 3 of 10 ( Start time: 11:20:08 AM ) Total M - 1
Which levels are mostly used for Detailed DFD?Level-0, Level-1
Level-1, Level-2
Level-2, Level-3
Level-3, Level-4
Which levels are mostly used for Detailed DFD?Level-0, Level-1
Level-1, Level-2
Level-2, Level-3
Level-3, Level-4
Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?
User accessible catalog
Data processingRecovery service
Authorization service
User accessible catalog
Data processingRecovery 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?True
False
Partially True
None of the given
False
Partially True
None of the given
Question # 9 of 10
Which of the following is used to filter rows according to some condition(s)?
Select correct option:
SELECT
FROM
WHERE
UPDATE
Question # 10 of 10
REATE TABLE and CREATE index belongs to which type of SQL commands
Select correct option:
DML
DDL
DCL
DQL
Select correct option:
superkey
candidate key
primary key
secondary key
Select correct option:
One process atleast
Two processes atleast
One process only
Any number of processes
common attribute
primary key
superkey
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.
Created at increasing levels of detail
The dataflow must be bidirectional
Used to represent the relationships among the external entities
Database
DBMS
Data model
Data
Select correct option:
Database Designer
Database Administrator
End User
Application Programmer
Select correct option:
Database
DBMS
Data model
Data
Select correct option:
Data Dictionary
Report Generator
Database Management System
Distributed database
Select correct option:True
False
Partially True
None of the given
Select correct option:
mail server
file server
client-server
none of the given
Select correct option:
a particular occurance of an entity
a special type of relation
an attribute of an entity
any particular entity
False
Partially True
None of the given
Two processes atleast
One process only
Any number of processes
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
False
Partially True
None of the Above
Vukwl- Virtual Education Solution
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
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 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 100%
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 100%
A tree-like structure of datas
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
Which feature of database provides conversion from inconsistent state of DB to a
Vukwl- Virtual Education Solution
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 100%
Functional dependency
Concurrency control
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 100%
secondary key
Which model operates at the lowest level of abstraction?
Select correct option:
conceptual
internal
external
physical 100%
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
Data Redundancy Means
Select correct option:
Security of data
Duplication of data 100%Management of data
Recovery of 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
User rights information is stored in
Select correct option:
Physical database
Catalog
Logical database
Buffer
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
User rights information is stored in
Which levels are mostly used for Detailed DFD?
Vukwl- Virtual Education Solution
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
In a three-level DBMS architecture, the ______ level interacts directly with the users.
Select correct option:
external
conceptual
internal
physical
Revoke is a __________ Statement
Data Definition
Control Access
Data Manipulation
Data Description
Which of the following is not true regarding clustering ?
It increases the efficiency since related records are placed close to each other.
Clustering makes records, difficult to access
Suitable to relatively static situations
It is a process, which means to place record from different tables to places in adjacent physical locations.
DML does not used to :
Select correct option:
add new rows to tables
retrieve rows from table
modify the rows of tables
alter a table definition
The ________ operator allows to use wild cards in the where clause of an SQL statement.
Select correct option:
IN
FROM
LIKE
None of the above.
Identify the basic part(s) of a SELECT statement?
SELECT
FROM
Both SELECT and FROM
DISTINCT
What happens if the WHERE clause is omitted from a DELETE statement?
Select correct option:
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
Truncate is an alternative of Delete command.
Select correct option:
True
False
SQL data types do not have support for storing multi-media objects directly. Select correct option:
True
False
Query Analyzer is used to practice SQL in MS-Access and MS-SQL Server. Select correct option:
True
False
Identify the language which is used to specify database schema.
DCL
DML
DDL
None of the above
Value of a function in SQL is always determined by the input parameters
True
False
Which of the following clauses allows to sort the records in result set?
Where
Order by
From
Having
Which of the following cannot be included into CREATE TABLE statement?
Select correct option:
Data types
Constraints
Attributes
Cardinalities
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
What does the abbreviation DBMS stand for?
Database Manipulation Software.
Data Borrowing and Movement Software
Digital Base Mapping System.
Database Management System.
The ____________ keyword is used in SELECT statement to return different values. Select correct option:
LIKE IN DISTINCT WHERE
DML stands for _____________. Select correct option:
Dynamic Modeling Language Data Manipulation Language
Data Management Language Domain Modeling Language
Functions in SQL return a single value Select correct option:
True
False
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
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
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
ncase of Context-level Diagram, the system is represented by
One process atleast
Two processes atleast
One process only
Any number of processes
An entity type is
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
Data about data is database
True
False
Partially True
None of the Above
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
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
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
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
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
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
In a three-level DBMS architecture, the ______ level interacts directly with the users.
Select correct option:
external
conceptual
internal
physical
Within a table, each primary key value ____.
In a three-level DBMS architecture, the ______ level interacts directly with the users.
Select correct option:
external
conceptual
internal
physical
Revoke is a __________ Statement
Data Definition
Control Access
Data Manipulation
Data Description
Which of the following is not true regarding clustering ?
It increases the efficiency since related records are placed close to each other.
Clustering makes records, difficult to access
Suitable to relatively static situations
It is a process, which means to place record from different tables to places in adjacent physical locations.
DML does not used to :
Select correct option:
add new rows to tables
retrieve rows from table
modify the rows of tables
alter a table definition
The ________ operator allows to use wild cards in the where clause of an SQL statement.
Select correct option:
IN
FROM
LIKE
None of the above.
Identify the basic part(s) of a SELECT statement?
SELECT
FROM
Both SELECT and FROM
DISTINCT
What happens if the WHERE clause is omitted from a DELETE statement?
Select correct option:
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
Truncate is an alternative of Delete command.
Select correct option:
True
False
SQL data types do not have support for storing multi-media objects directly. Select correct option:
True
False
False
Query Analyzer is used to practice SQL in MS-Access and MS-SQL Server. Select correct option:
True
False
False
Identify the language which is used to specify database schema.
DCL
DML
DDL
None of the above
DML
DDL
None of the above
Value of a function in SQL is always determined by the input parameters
True
False
False
Which of the following clauses allows to sort the records in result set?
Where
Order by
From
Having
Which of the following cannot be included into CREATE TABLE statement?
Select correct option:
Data types
Constraints
Attributes
Cardinalities
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
What does the abbreviation DBMS stand for?
Database Manipulation Software.
Data Borrowing and Movement Software
Digital Base Mapping System.
Database Management System.
The ____________ keyword is used in SELECT statement to return different values. Select correct option:
LIKE IN DISTINCT WHERE
DML stands for _____________. Select correct option:
Dynamic Modeling Language Data Manipulation Language
Data Management Language Domain Modeling Language
Data Management Language Domain Modeling Language
Functions in SQL return a single value Select correct option:
True
False
False
A table can be logically connected to another table by defining a __.
hyperlink
common attribute
primary key
superkey
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.
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
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
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
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
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
False
Partially True
None of the given
ncase of Context-level Diagram, the system is represented by
One process atleast
Two processes atleast
One process only
Any number of processes
Two processes atleast
One process only
Any number of processes
An entity type is
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
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
Data about data is database
True
False
Partially True
None of the Above
False
Partially True
None of the Above
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
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
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
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?
Who is responsible for authorizing access to the database, for coordinating and monitoring its use?
Incase of Context-level Diagram, the system is represented by
In a three-level DBMS architecture, the ______ level interacts directly with the users.
Vukwl- Virtual Education Solution
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 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
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.
User rights information is stored in
Select correct option:
Physical database
Catalog
Logical database
Buffer
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
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
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
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________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
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 100%
Authorization service
Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?
Which of the following describes a database system?
Which of the following is INCORRECT statement concerning the database design process?
User rights information is stored in
The Entity Relation Model models
Which of the following is NOT a component of a DFD?
Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of
Incase of Context-level Diagram, the system is represented by
An instance is
A________is used to maintain a connection between the users of the database system.
Vukwl- Virtual Education Solution
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 100%
A tree-like structure of datas
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
Data redundancies produce unusual and undesirable data management problems caused by __________.
A) transitive requirements
B) dependencies
C) normalization
D) data anomalies
5
Removing the __________ is part of the database design process.
A) foreign keys
B) primary key dependencies
C) recursive relationships
D) partial and transitive dependencies
1
In a POS system, what do the major transaction modules define?
A) Inventory management, shipping, invoice calculations, and product returns
B) Sales, inventory management, shipping, back ordering, and product returns
C) Sales, invoice calculations, back ordering, and product returns
D) Inventory management, shipping, invoice calculations, back ordering, and product returns
2
What are the fourth and fifth steps in developing a POS?
A) Define the entities, attributes, relationships, connectivities, cardinalities, and constraints. Create the initial ERD segments.
B) Develop business rules. Create the initial ERD segments.
C) Develop business rules. Define the entities, attributes, relationships, connectivities, cardinalities, and constraints.
D) Define the major transaction modules. Create the initial ERD segments.
3
After creating the initial ERD segments, the next step is to
A) define the major transaction modules.
B) perform the appropriate normalization checks based on the data dictionary contents.
C) create a basic data dictionary for all the components found in each ERD segment.
D) define the entities, attributes, relationships, connectivities, cardinalities, and constraints.
4
What will the following questions help you define? What types of transactions take place? How many different types of transactions are there?
A) Available resources
B) Data environment
C) Current operations
D) Business objectives
5
Which of the following is an advantage of having a precisely written set of current operations.
A) It clarifies the assignment of data types.
B) It highlights the best possible way to perform each task.
C) It forces careful assessment of the procedures.
D) It makes the creation of the data dictionary much easier.
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 100%
Functional dependency
Concurrency control
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 100%
secondary key
Which model operates at the lowest level of abstraction?
Select correct option:
conceptual
internal
external
physical 100%
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
Data Redundancy Means
Select correct option:
Security of data
Duplication of data 100%Management of data
Recovery of data
There are ---- ways to create a new view in your database.
Three
Two
Five
Six
GRANT belongs to which type of SQL commands classification
DML (Data Manipulation Language)
DDL (Data Definition Language)
DQL (Data Query Language)
DCL (Data Controlling Language) Ans
There are ---- ways to create a new view in your database.
Three
Two
Five
Six
GRANT belongs to which type of SQL commands classification
DML (Data Manipulation Language)
DDL (Data Definition Language)
DQL (Data Query Language)
DCL (Data Controlling Language) Ans
Vukwl- Virtual Education Solution
An effective user interface minimizes the----------- users require to learn and implement the system.
Space
Time Ans
Complexity
Efficiency
Truncate command response time is ______ as compared to Delete command.
Poor
Same
Better I choose it, but not sure
Worst
UPDATE command belongs to which type of Classification
DML (Data Manipulation Language) Ans
DDL (Data Definition Language)
DQL (Data Query Language)
DCL (Data Controlling Language)
When the power is turned off content of ________________ is lost.
Volatile storage
Non-Volatile storage
Permanent storage
Hard disk storage
Which of the following is not DML command?
SELECT
TRUNCATE Ans
DELETE
UPDATE
Forms are used in application programs, how many types of forms are
available------------?
Four
Five Ans
One
Two
_______ User Interface is preferred over ________ User Interface with respect to user.
Easy to understand, efficient
Hard to understand, efficient
Easy to understand, effective Ans
Hard to understand, effective
Browser Based & Non-Browser/Simple are two different types of-------------------.
Forms Ans
Language
Program
Interface
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
Foreign Key is
Select correct option:
A field in a table that matches a key field in another tableA 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
The Entity Relation Model models
Select correct option:
Entities, Relationships and Processes
Entities and Relationships
Relationships
Entities
Database Application is a program which is used for performing certain operations such as
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
Level of data at which entities or objects exist in reality is called
Real world data
Schema for real world data
Meta data
Data about data
Which model operates at the lowest level of abstraction?
conceptual
internal
external
physical
An effective user interface minimizes the----------- users require to learn and implement the system.
Space
Time Ans
Complexity
Efficiency
Truncate command response time is ______ as compared to Delete command.
Poor
Same
Better I choose it, but not sure
Worst
UPDATE command belongs to which type of Classification
DML (Data Manipulation Language) Ans
DDL (Data Definition Language)
DQL (Data Query Language)
DCL (Data Controlling Language)
When the power is turned off content of ________________ is lost.
Volatile storage
Non-Volatile storage
Permanent storage
Hard disk storage
Which of the following is not DML command?
SELECT
TRUNCATE Ans
DELETE
UPDATE
Forms are used in application programs, how many types of forms are
available------------?
Four
Five Ans
One
Two
_______ User Interface is preferred over ________ User Interface with respect to user.
Easy to understand, efficient
Hard to understand, efficient
Easy to understand, effective Ans
Hard to understand, effective
Browser Based & Non-Browser/Simple are two different types of-------------------.
Forms Ans
Language
Program
Interface
Within a table, each primary key value __.
Select correct option:
Select correct option:
is a minimal super key
is always the first field in each table
must be numeric
must be unique
Foreign Key is
Select correct option:
A field in a table that matches a key field in another tableA 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
The Entity Relation Model models
Select correct option:
Entities, Relationships and Processes
Entities and Relationships
Relationships
Entities
Database Application is a program which is used for performing certain operations such as
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
Level of data at which entities or objects exist in reality is called
Real world data
Schema for real world data
Meta data
Data about data
Which model operates at the lowest level of abstraction?
conceptual
internal
external
physical
Vukwl- Virtual Education Solution
A table can be logically connected to another table by defining a ____.
hyperlink
common attribute
primary key
superkey
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
ncase of Context-level Diagram, the system is represented by
One process atleast
Two processes atleast
One process only
Any number of processes
An entity type is
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
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
A table can be logically connected to another table by defining a ____.
hyperlink
common attribute
primary key
superkey
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
ncase of Context-level Diagram, the system is represented by
One process atleast
Two processes atleast
One process only
Any number of processes
An entity type is
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
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
Vukwl- Virtual Education Solution
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?
conceptual
internal
external
physical
An entity type is
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
Data about data is database
True
False
Partially True
None of the Above
1: Incase of Context-level Diagram, the system is represented by
- One process atleas
2:Two processes atleast
3: One process only
4: Any number of processes
Ans:3
2 Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of
Physical data independence
Logical data independence
Functional dependency
Concurrency control
Ans: 2
3 Within a table, each primary key value __.
is a minimal superkey
is always the first field in each table
must be numeric
must be unique
ans:4
4 An entity type is
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
ans: 3
5 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.
ans: 2
6 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
ans: 4
7 Each table must have a __ key.
primary
secondary
logical
foreign
ans: 1
8 An instance is
a particular occurance of an entity
a special type of relation
an attribute of an entity
any particular entity
ans: 3
9 A table can be logically connected to another table by defining a __.
hyperlink
common attribute
primary key
superkey
ans: 2
10 Which of the following is NOT a component of a DFD?
Dataflow
Datastore
External entities
Relationship between external entities
ans: 4
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
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?
conceptual
internal
external
physical
An entity type is
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
Data about data is database
True
False
Partially True
None of the Above
1: Incase of Context-level Diagram, the system is represented by
- One process atleas
2:Two processes atleast
3: One process only
4: Any number of processes
Ans:3
2 Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of
Physical data independence
Logical data independence
Functional dependency
Concurrency control
Logical data independence
Functional dependency
Concurrency control
Ans: 2
3 Within a table, each primary key value __.
is a minimal superkey
is always the first field in each table
must be numeric
must be unique
is always the first field in each table
must be numeric
must be unique
ans:4
4 An entity type is
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
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
ans: 3
5 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.
ans: 2
6 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
ans: 4
7 Each table must have a __ key.
primary
secondary
logical
foreign
secondary
logical
foreign
ans: 1
8 An instance is
a particular occurance of an entity
a special type of relation
an attribute of an entity
any particular entity
a special type of relation
an attribute of an entity
any particular entity
ans: 3
9 A table can be logically connected to another table by defining a __.
hyperlink
common attribute
primary key
superkey
common attribute
primary key
superkey
ans: 2
10 Which of the following is NOT a component of a DFD?
Dataflow
Datastore
External entities
Relationship between external entities
Datastore
External entities
Relationship between external entities
ans: 4
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
Vukwl- Virtual Education Solution
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
- Data redundancies produce unusual and undesirable data management problems caused by __________.
A) transitive requirements
B) dependencies
C) normalization
D) data anomalies
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
- Data redundancies produce unusual and undesirable data management problems caused by __________.
A) transitive requirements
B) dependencies
C) normalization
D) data anomalies
Vukwl- Virtual Education Solution
5
Removing the __________ is part of the database design process.
A) foreign keys
B) primary key dependencies
C) recursive relationships
D) partial and transitive dependencies
1
In a POS system, what do the major transaction modules define?
A) Inventory management, shipping, invoice calculations, and product returns
B) Sales, inventory management, shipping, back ordering, and product returns
C) Sales, invoice calculations, back ordering, and product returns
D) Inventory management, shipping, invoice calculations, back ordering, and product returns
2
What are the fourth and fifth steps in developing a POS?
A) Define the entities, attributes, relationships, connectivities, cardinalities, and constraints. Create the initial ERD segments.
B) Develop business rules. Create the initial ERD segments.
C) Develop business rules. Define the entities, attributes, relationships, connectivities, cardinalities, and constraints.
D) Define the major transaction modules. Create the initial ERD segments.
3
After creating the initial ERD segments, the next step is to
A) define the major transaction modules.
B) perform the appropriate normalization checks based on the data dictionary contents.
C) create a basic data dictionary for all the components found in each ERD segment.
D) define the entities, attributes, relationships, connectivities, cardinalities, and constraints.
4
What will the following questions help you define? What types of transactions take place? How many different types of transactions are there?
A) Available resources
B) Data environment
C) Current operations
D) Business objectives
5
Which of the following is an advantage of having a precisely written set of current operations.
A) It clarifies the assignment of data types.
B) It highlights the best possible way to perform each task.
C) It forces careful assessment of the procedures.
D) It makes the creation of the data dictionary much easier.
5
Removing the __________ is part of the database design process.
A) foreign keys
B) primary key dependencies
C) recursive relationships
D) partial and transitive dependencies
1
In a POS system, what do the major transaction modules define?
A) Inventory management, shipping, invoice calculations, and product returns
B) Sales, inventory management, shipping, back ordering, and product returns
C) Sales, invoice calculations, back ordering, and product returns
D) Inventory management, shipping, invoice calculations, back ordering, and product returns
2
What are the fourth and fifth steps in developing a POS?
A) Define the entities, attributes, relationships, connectivities, cardinalities, and constraints. Create the initial ERD segments.
B) Develop business rules. Create the initial ERD segments.
C) Develop business rules. Define the entities, attributes, relationships, connectivities, cardinalities, and constraints.
D) Define the major transaction modules. Create the initial ERD segments.
3
After creating the initial ERD segments, the next step is to
A) define the major transaction modules.
B) perform the appropriate normalization checks based on the data dictionary contents.
C) create a basic data dictionary for all the components found in each ERD segment.
D) define the entities, attributes, relationships, connectivities, cardinalities, and constraints.
4
What will the following questions help you define? What types of transactions take place? How many different types of transactions are there?
A) Available resources
B) Data environment
C) Current operations
D) Business objectives
5
Which of the following is an advantage of having a precisely written set of current operations.
A) It clarifies the assignment of data types.
B) It highlights the best possible way to perform each task.
C) It forces careful assessment of the procedures.
D) It makes the creation of the data dictionary much easier.
Vukwl- Virtual Education Solution
CS403 Database Management Systemmcqs solved CS403 Database Management Systemquiz mega file CS403 Database Management Systemmidterm solved papers 2017 CS403 Database Management Systemsolved mcqs mega file CS403 Database Management Systemmidterm solved papers 2016 CS403 Database Management System midterm papers CS403 Database Management Systemfinal term solved mcqs mega file CS403 Database Management System handouts CS403 Database Management Systemlectures CS403 Database Management System assignment CS403 Database Management Systemhandouts CS403 Database Management System assignment solution 2018 CS403 Database Management Systemppt slides CS403 Database Management Systemassignment no 2 solution 2018 CS403 Database Management Systemmidterm solved papers by moaaz CS403 Database Management Systemfinal term solved mcqs by moaaz
CS403 Database Management Systemmcqs solved CS403 Database Management Systemquiz mega file CS403 Database Management Systemmidterm solved papers 2017 CS403 Database Management Systemsolved mcqs mega file CS403 Database Management Systemmidterm solved papers 2016 CS403 Database Management System midterm papers CS403 Database Management Systemfinal term solved mcqs mega file CS403 Database Management System handouts CS403 Database Management Systemlectures CS403 Database Management System assignment CS403 Database Management Systemhandouts CS403 Database Management System assignment solution 2018 CS403 Database Management Systemppt slides CS403 Database Management Systemassignment no 2 solution 2018 CS403 Database Management Systemmidterm solved papers by moaaz CS403 Database Management Systemfinal term solved mcqs by moaaz