DROP is a statement in SQL.
Query
Embedded SQL
DDL
DCL
Correct Answer :
C. DDL
Related Questions
Which of the following is not comparison operator?
<>
<
=<
>=
The graphical representation of a query is .
B-Tree
graph
Query Tree
directed graph
The rule that a value of a foreign key must appear as a value of some specific table is called a
Referential constraint.
Index.
Integrity constraint.
Functional dependency.
The size of a data item is called its _______, which can be a field of some record or may be a larger unit such as a record.
Similarity
Granularity
Dimensionality
Arity
The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces a result of degree
m - 1
m + 1
m * m
m
The fact that all employees of a particular organization should not have salaries more than $10000 is a _____ constraint.
Schema
Tuple
Domain
Relational
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.
Manager salary details are hidden from the employee .This is
Conceptual level data hiding.
External level data hiding.
Physical level data hiding.
None of these.
_____ 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
Tree structures are used to store data in
Network model.
Relational model.
Hierarchical model.
File based system.
Which of the following relational algebraic operations is not from set theory?
Union
Intersection
Cartesian Product
Select
____ table store information about database or about the system.
SQL
System
Nested
None of these
A table can have only one
Secondary key
Alternate key
Unique key
Primary key
Relational Algebra is
Data Definition Language .
Meta Language
Procedural query Language
None of the above
As per equivalence rules for query transformation, selection operation distributes over
Union.
Set difference.
Intersection.
All of the above.
The _______ is a set of programs to use and / or modify this data.
DBMS
System
Program
Software
The metadata is created by the
DML compiler
DML pre-processor
DDL interpreter
Query interpreter
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
DBMS helps achieve
Centralized control of data
Data independence
Both A and B
Neither A nor B
DFD stands for
Data Flow Document
Data File Diagram
Data Flow Diagram
Non of the above
What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are Base union compatible and all the rows of a are common to B? Assume A has 4 columns and 10 rows; and B has 4 columns and 15 rows
4,0
0,0
4,5
8,5
Immediate database modification technique uses
Both undo and redo.
Undo but no redo.
Redo but no undo.
Neither undo nor redo.
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;
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 .
The relational model is based on the concept that data is organized and stored in two-dimensional tables called ______
Fields
Records
Relations
Keys
Which of the following is not a property of transactions?
Atomicity
Concurrency
Isolation
Durability
E-R Modeling is achieved by using ____ diagrams
DFD
Flowcharts
Gantt Charts
E-R
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
______is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
Domain Integrity Constraints
Referential Integrity Constraints
Domain Constraints
Entity Integrity Constraints
A ______ module is typically designed so that it will run on a user workstation or personal computer.
Software
Server
Program
Client