______is a preferred method for enforcing data integrity
Constraints
Triggers
Stored procedure
Cursors
Correct Answer :
A. Constraints
Related Questions
Tree structures are used to store data in
Network model.
Relational model.
Hierarchical model.
File based system.
Which of the following is not a consequence of non-normalized database?
Update Anomaly
Insertion Anomaly
Redundancy
Lost update problem
____ table store information about database or about the system.
SQL
System
Nested
None of these
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)
Relations produced from an E-R model will always be
First normal form.
Second normal form.
Third normal form.
Fourth normal form.
Checkpoints are a part of
Recovery measures.
Security measures.
Concurrency measures.
uthorization measures.
The full form of GUI is _________
Government Union Internet
Graphical Unit Interface
Graphical User Interface
Graphical University Interface
Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
Create table Employee(EMPNO int, EMPNAME char(10));
Create table Employee(EMPNO integer, EMPNAME String(10));
Create table Emplo(EMPNO number, EMPNAME string);
Create table Emp(EMPNO int, EMPNAME char(10));
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 data models defined by ANSI/SPARC architecture are
Conceptual, physical and internal
Conceptual, view and external
Logical, physical and internal
Logical, physical and view
The _____ category includes storage media that can be operated on directly by the computers central processing unit.
Primary storage
Secondary Storage
All
Tertiary Storage
A data type or format is specified for each _________
Relation
Tuple
Database
Domain
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
Processed data is called _____
Raw data
Source
Information
Useful data
The clause alter table in SQL can be used to
add an attribute
delete an attribute
alter the default values of an attribute
all of the above
Which of the following concurrency control schemes is not based on the serializability property?
Two - phase locking
Graph-based locking
Time-stamp based locking
None of these .
Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
Functional dependency
Multi-valued dependency
Transitive dependency
Partial dependency
DROP is a statement in SQL.
Query
Embedded SQL
DDL
DCL
______ keyword is used to find the number of values in a column.
TOTAL
ADD
COUNT
SUM
In SQL, testing whether a subquery is empty is done using
DISTINCT
UNIQUE
NULL
EXISTS
_____ is a utility to capture a continuous record of server activity and provide auditing capability.
SQL server Profile
SQL server wizard.
SQL server service manager
SQL server setup
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.
Which of the following is a reason to model data?
Understand each user's perspective of data
Understand the data itself irrespective of the physical representation
Understand the use of data across application areas
All of the above
Wait-for graph is used for
detecting view serializability.
detecting conflict serializability.
deadlock prevention
deadlock detection
The drawback of shadow paging technique are
Commit overhead
Data fragmentation
Garbage collection
All of these
An advantage of views is
Data security
Derived columns
Hiding of complex queries
All of the above
In E-R Diagram total participation is represented by
Double lines
Single line
Dashed lines
Triangle
In multiple granularity of locks SIX lock is compatible with
IX
IS
S
SIX
For using a specific database …………… command is used.
use database
database name use
Both A & B
None of them
Isolation of the transactions is ensured by
Transaction management
Application programmer
Concurrency control
Recovery management