A transaction is in state after the final statement has been executed.
partially committed
active
committed
none of the above
Correct Answer :
C. committed
Related Questions
Which one is correct statement?
Logical data independence provides following without changing application programs:
(i) Changes in access methods.
(ii) Adding new entities in database
(iii) Splitting an existing record into two or more records
(iv) C
(i) and (ii)
(iv) only
(i) and (iv)
(ii) and (iii)
………………… 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
When an E-R diagram is mapped to tables, the representation is redundant for
weak entity sets
weak relationship sets
strong entity sets
strong relationship sets
In an ER model,_____ is described in the database by storing its data.
Entity
Attribute
Relationship
Notation
Relations produced from an E-R model will always be
First normal form.
Second normal form.
Third normal form.
Fourth normal form.
Grant and revoke are _____ statements.
TCL
DCL
DDL
DML
Which normal form is considered adequate for normal relational database design?
2NF
5NF
4NF
3NF
A list consists of last names, first names, addresses and pin codes. If all people in the list have the same last name and same pin code a useful key would be
the pin code
the last name
the compound key first name and last name
Tr from next page
A transaction is in state after the final statement has been executed.
partially committed
active
committed
none of the above
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
Instance
Program
Schema
Super Key
Change Staff table by removing default of Assistant for position column
ALTER TABLE Staff ALTER position DROP DEFAULT;
ALTER TABLE Staff ALTER position DEFAULT;
ALTER TABLE Staff ALTER DROP DEFAULT;
MODIFY Staff ALTER position DROP DEFAULT;
According to the levels of abstraction, the schema at the intermediate level is called
Logical schema.
Physical schema.
Subschema.
None of the above.
An outstanding functionality of SQL is its support for automatic_____ to the target data.
programming
navigation
functioning
notification
The transactions like adding an employee, enrolling a student in a course are examples of _______
Logical
Physical
None
Theoretical
What are the desirable properties of a decomposition
Partition constraint.
Dependency preservation.
Redundancy.
Security.
As per equivalence rules for query transformation, selection operation distributes over
Union.
Set difference.
Intersection.
All of the above.
Data items grouped together for storage purposes are called a
record
string
title
list
Which of the following is not comparison operator?
<>
<
=<
>=
Relational Algebra does not have
Selection operator.
Projection operator.
Aggregation operators.
Division operator.
For using a specific database …………… command is used.
use database
database name use
Both A & B
None of them
In SQL the word natural can be used with
inner join
full outer join
right outer join
all of the above
The ______ indexes are forced to store only record IDs in the data structure and require at least one additional I/O Operation to retrieve the actual record.
Clustered
Hashed
Un-clustered
Collision
Relationships among relationships can be represented in an-E-R model using
Aggregation
Association
Weak entity sets
Weak relationship sets
The statement that is executed automatically by the system as a side effect of the modification of the database is
backup
assertion
recovery
trigger
The fact that all employees of a particular organization should not have salaries more than $10000 is a _____ constraint.
Schema
Tuple
Domain
Relational
The relational model is based on the concept that data is organized and stored in two-dimensional tables called ______
Fields
Records
Relations
Keys
Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum and minimum size of the join respectively are
m+n and 0
m+n and |m-n|
mn and 0
mn and m+n
In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
Oval; An oval with an underlined attribute
Circle; A circle with bolded attribute inside it
Diamond; A bolded attribute
Square; An attribute within the square
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
A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and ON DELETE.
Direct
Indirect
Existence
No