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
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 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.
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
