The statement that is executed automatically by the system as a side effect of the modification of the database is
backup
assertion
recovery
trigger
Correct Answer :
D. trigger
Related Questions
Which is the best file organization when data is frequently added or deleted from a file?
Sequential
Direct
Index sequential
None of the above
SQL server stores index information in the _____system table
system indexes
syst indexes
sys indexes
sysind
What is data integrity?
It is the data contained in database that is non redundant.
It is the data contained in database that is accurate and consistent.
It is the data contained in database that is secured.
It is the data contained in database that is shared.
A _____ is used to define overall design of the database
code
data definition language
application program
schema
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 .
………………… approach reduces time and effort required for design and lesser risk in database management.
Single global database
Multiple databases
Top-down approach
None of the above
A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation R can have the same value for super key.
Sub
Parent
Candidate
Super
Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
distinct values
cannot have NULL
both (A) & (B)
same as primary key
An advantage of views is
Data security
Derived columns
Hiding of complex queries
All of the above
In b-tree the number of keys in each node is than the number of its children.
one less
same
one more
half
If both the functional dependencies : X�Y and Y�X hold for two attributes X and Y then the relationship between X and Y is
M:N
M:1
1:M
The normalization was first proposed by .
Code
Codd
Boyce Codd
Boyce
Which of the following is not a property of transactions?
Atomicity
Concurrency
Isolation
Durability
Relationships among relationships can be represented in an-E-R model using
Aggregation
Association
Weak entity sets
Weak relationship sets
A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer systems.
None
Multi
Single
Concurrent
______is a preferred method for enforcing data integrity
Constraints
Triggers
Stored procedure
Cursors
The fact that all employees of a particular organization should not have salaries more than $10000 is a _____ constraint.
Schema
Tuple
Domain
Relational
Which of the following is not a logical database structure?
Chain
Network
Tree
Relational
For using a specific database …………… command is used.
use database
database name use
Both A & B
None of them
A top-to-bottom relationship among the items in a database is established by a
Hierarchical schema
Network schema
Relational Schema
All of the above
______contains information that defines valid values that are stored in a column or data type.
Default
Index
Rule
View
A data type or format is specified for each _________
Relation
Tuple
Database
Domain
The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.
OR
AND
NOT
ALL
The common column is eliminated in
theta join
outer join
natural join
composed join
Data items grouped together for storage purposes are called a
record
string
title
list
In multiple granularity of locks SIX lock is compatible with
IX
IS
S
SIX
DBMS is a collection of _____ that enables user to create and maintain a database.
Keys
Program
Translators
Language Activity
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.
Which of the following is not a characteristic of a relational database model?
Table
Tree like structure
Complex logical relationship
Records
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