DFD stands for
Data Flow Document
Data File Diagram
Data Flow Diagram
Non of the above
Correct Answer :
C. Data Flow Diagram
Related Questions
In a relational schema, each tuple is divided into fields called
Relations
Queries
Domains
All of the above
_____ command can be used to modify a column in a table
alter
update
set
create
Which one is true statement :
With finer degree of granularity of locking a high degree of concurrency is possible.
Locking prevents non-serializable schedules.
Locking cannot take place at field level.
An exclusive lock on data item X is granted even if a shared lock is already held on X.
DROP is a statement in SQL.
Query
Embedded SQL
DDL
DCL
______is a preferred method for enforcing data integrity
Constraints
Triggers
Stored procedure
Cursors
Data items grouped together for storage purposes are called a
record
string
title
list
The _____ category includes storage media that can be operated on directly by the computers central processing unit.
Primary storage
Secondary Storage
All
Tertiary Storage
_____clause is an additional filter that is applied to the result.
Select
Order by
Group-by
Having
The values of the attribute describes a particular
Entity set
File
Entity instance
Organization
Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
It will result in a deadlock situation.
It will immediately be rejected.
It will immediately be granted.
It will be granted as soon as it is released by A .
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
Instance
Program
Schema
Super Key
Tree structures are used to store data in
Network model.
Relational model.
Hierarchical model.
File based system.
The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is
Procedural DML.
Non-Procedural DML.
Procedural DDL.
Non-Procedural DDL.
The common column is eliminated in
theta join
outer join
natural join
composed join
Checkpoints are a part of
Recovery measures.
Security measures.
Concurrency measures.
uthorization measures.
_____ database is used to provide statistical information or summaries of values based on various criteria.
Statistical
Mathematical
Normalized
Un normalized
DBMS is a collection of _____ that enables user to create and maintain a database.
Keys
Program
Translators
Language Activity
Which of the following statement on the view concept in SQL is invalid?
All views are not updateable
The views may be referenced in an SQL statement whenever tables are referenced.
The views are instantiated at the time they are referenced and not when they are defined.
The definition of a view should not have GROUP BY clause in it.
In a multi-user database, if two users wish to update the same record at the same time, they are prevented from doing so by
jamming
password
documentation
record lock
Immediate database modification technique uses
Both undo and redo.
Undo but no redo.
Redo but no undo.
Neither undo nor redo.
A relation is in attribute of other composite key. if an attribute of a composite key is dependent on an
2NF
3NF
BCNF
1NF
operator is used to compare a value to a list of literals values that have been specified.
Like
COMPARE
BETWEEN
IN
In an ER model,_____ is described in the database by storing its data.
Entity
Attribute
Relationship
Notation
A logical schema
is the entire database
Describes how data is actually stored on disk.
is a standard way of organizing information into accessible parts.
All of the above
DFD stands for
Data Flow Document
Data File Diagram
Data Flow Diagram
Non of the above
Relational Algebra does not have
Selection operator.
Projection operator.
Aggregation operators.
Division operator.
The metadata is created by the
DML compiler
DML pre-processor
DDL interpreter
Query interpreter
Key to represent relationship between tables is called
primary key
secondary key
foreign key
none of the above
The part of a database management system which ensures that the data remains in a consistent state is
authorization and integrity manager
buffer manager
transaction manager
file manager
A ______ module is typically designed so that it will run on a user workstation or personal computer.
Software
Server
Program
Client