An outstanding functionality of SQL is its support for automatic_____ to the target data.
programming
navigation
functioning
notification
Correct Answer :
B. navigation
Related Questions
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
The concept of mapping of ______ entity types is the concept in which the for each strong entity type E in the ER schema, create a relation R that includes all the simple attributes of E.
Regular
Irregular
None
Weak
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
If an entity can belong to only one lower level entity then the constraint is
disjoint
partial
overlapping
single
If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
left outer join
right outer join
full outer join
inner join
The normalization was first proposed by .
Code
Codd
Boyce Codd
Boyce
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
The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify a given tuple.
Primary
Foreign
Candidate
Alternate
Which of the following relational algebraic operations is not from set theory?
Union
Intersection
Cartesian Product
Select
Which of the following is not a property of transactions?
Atomicity
Concurrency
Isolation
Durability
Grant and revoke are _____ statements.
TCL
DCL
DDL
DML
The transactions like adding an employee, enrolling a student in a course are examples of _______
Logical
Physical
None
Theoretical
The default level of consistency in SQL is
repeatable read
read committed
read uncommitted
serializable
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));
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.
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
Which is the best file organization when data is frequently added or deleted from a file?
Sequential
Direct
Index sequential
None 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 .
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
The common column is eliminated in
theta join
outer join
natural join
composed join
Processed data is called _____
Raw data
Source
Information
Useful data
A relational database developer refers to a record as
an attribute
a tuple
a criteria
a relation
What is data integrity?
It is the data contained in database that is non redundant.
It is the data contained in database that is accurate and consistent.
It is the data contained in database that is secured.
It is the data contained in database that is shared.
The drawback of shadow paging technique are
Commit overhead
Data fragmentation
Garbage collection
All of these
Key to represent relationship between tables is called
primary key
secondary key
foreign key
none of the above
Relationships among relationships can be represented in an-E-R model using
Aggregation
Association
Weak entity sets
Weak relationship sets
______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
Instance
Program
Schema
Super Key
Which of the following is not a logical database structure?
Chain
Network
Tree
Relational
The full form of GUI is _________
Government Union Internet
Graphical Unit Interface
Graphical User Interface
Graphical University Interface
Protection of data from unauthorized Disclosure results in loss of _______
Integrity
Availability
Confidentiality
Discretionary Security