The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in tables that already exist.
Data Manipulation
Data Definition
Data Control
None
Correct Answer :
A. Data Manipulation
Related Questions
The fact that information in the data warehouse changes far less often and may be regarded as non-real-time with periodic updating; This implies that data warehouses are _______
Volatile
Non - Volatile
Logical
Physical
Grant and revoke are _____ statements.
TCL
DCL
DDL
DML
Drop Table cannot be used to drop a table referenced by a ______ constraint.
Primary Key
Local Key
Foreign Key
Composite Key
In an ER model,_____ is described in the database by storing its data.
Entity
Attribute
Relationship
Notation
The keyword to eliminate duplicate rows from the query result in SQL is
DISTINCT
NO DUPLICATE
UNIQUE
None of the above
DFD stands for
Data Flow Document
Data File Diagram
Data Flow Diagram
Non 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
The metadata is created by the
DML compiler
DML pre-processor
DDL interpreter
Query interpreter
Data independence means
data is defined separately and not included in programs.
programs are not dependent on the physical attributes of data
programs are not dependent on the logical attributes of data
both B and C
An outstanding functionality of SQL is its support for automatic_____ to the target data.
programming
navigation
functioning
notification
If a transaction T has obtained an exclusive lock on item Q, then T can
read Q
write Q
both read and write Q
write Q but not read Q
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
In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect :
Operationally, if Y is deleted, so is X
existence is dependent on Y.
Operationally, if X is deleted, so is Y.
Operationally, if X is deleted, & remains the same.
_____clause is an additional filter that is applied to the result.
Select
Order by
Group-by
Having
A ______ module is typically designed so that it will run on a user workstation or personal computer.
Software
Server
Program
Client
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
In SQL the word natural can be used with
inner join
full outer join
right outer join
all of the above
In E-R Diagram total participation is represented by
Double lines
Single line
Dashed lines
Triangle
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
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
In SQL, testing whether a subquery is empty is done using
DISTINCT
UNIQUE
NULL
EXISTS
The normalization was first proposed by .
Code
Codd
Boyce Codd
Boyce
Which of the following relational algebraic operations is not from set theory?
Union
Intersection
Cartesian Product
Select
Processed data is called _____
Raw data
Source
Information
Useful data
An advantage of the database management approach is
data redundancy increases
data is dependent on programs
data is integrated and can be accessed by multiple programs
none of the above
Union operator is a :
Unary Operator
Ternary Operator
Binary Operator
Not an operator
In multiple granularity of locks SIX lock is compatible with
IX
IS
S
SIX
If an entity can belong to only one lower level entity then the constraint is
disjoint
partial
overlapping
single
Relations produced from an E-R model will always be
First normal form.
Second normal form.
Third normal form.
Fourth normal form.
______ keyword is used to find the number of values in a column.
TOTAL
ADD
COUNT
SUM