Grant and revoke are _____ statements.
TCL
DCL
DDL
DML
Correct Answer :
B. DCL
Related Questions
The middleware databases in which the business rules act are applicable to _______ tier architectures
Single
Three
Two
None
____specifies a search condition for a group or an aggregate.
GROUP BY Clause
HAVING Clause
FROM Clause
WHERE Clause
Which of the following is not a consequence of concurrent operations?
Lost update problem.
Update anomaly.
Unrepeatable read.
Dirty read.
A table can have only one
Secondary key
Alternate key
Unique key
Primary key
Maximum height of a B+ tree of order m with n key values is
Logm(n)
(m+n)/2
Logm/2(m+n)
None of these
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));
______is a preferred method for enforcing data integrity
Constraints
Triggers
Stored procedure
Cursors
Which of the following is not a logical database structure?
Chain
Network
Tree
Relational
For correct behaviour during recovery, undo and redo operation must be
Commutative
Associative
idempotent
distributive
_____ database is used to provide statistical information or summaries of values based on various criteria.
Statistical
Mathematical
Normalized
Un normalized
_____clause is an additional filter that is applied to the result.
Select
Order by
Group-by
Having
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
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
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
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.
Grant and revoke are _____ statements.
TCL
DCL
DDL
DML
______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
DROP is a statement in SQL.
Query
Embedded SQL
DDL
DCL
Which of the following addressing modes permits relocation without any change over in the code?
Indirect addressing
Indexed addressing
PC relative addressing
Base register addressing
In an E-R diagram double lines indicate
Total participation.
Multiple participation.
Cardinality N.
None of the above.
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 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
Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
Functional dependency
Multi-valued dependency
Transitive dependency
Partial dependency
Which of the following is not a property of transactions?
Atomicity
Concurrency
Isolation
Durability
The common column is eliminated in
theta join
outer join
natural join
composed join
In multiple granularity of locks SIX lock is compatible with
IX
IS
S
SIX
_____ command can be used to modify a column in a table
alter
update
set
create
____ table store information about database or about the system.
SQL
System
Nested
None of these
Protection of data from unauthorized Disclosure results in loss of _______
Integrity
Availability
Confidentiality
Discretionary Security
An advantage of views is
Data security
Derived columns
Hiding of complex queries
All of the above