Which of the following extracts its data from the result of an SQL SELECT statement.
View
Synonym
Sequence
Transaction
Correct Answer :
A. View
Related Questions
FDDI protocol operates in
i) Transport layer
ii) Network layer
iii) Datalink layer
iv) Physical layer
i and ii only
ii and iii only
i and iii only
iii and iv only
In this data model each record can hae more than one parent
Hierarchical model
E-R model
Network based model
none of these
The command used to delete a particular column in a relation
UPDATE
DROP
ALTER
DELETE
Encoding method which does not provide for synchronization
B8ZS
Manchester
RZ
NRZ-L
Range variables are designed using the
TO clause
FROM clause
RANGE clause
none of the above
A composite attribute is converted to individual attributes in which of the following normal form ?
first
Second
third
fourth
Which of the following file organization provides very fast access to any arbitrary record of a file?
Ordered file
Unordered file
Hashed file
B-tree
Mail services are available to network users through the
Session layer
Presentation layer
Application layer
Transport layer
Datalog is
procedural query language
nonprocedural query language
scan(), write()
none of the above
If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.
Noise
Delay
Dispersion
Attenuation
Select the incorrect statement
View is derived from other tables.
Once a transaction has executed commit work its effect cant be undone by rollback work .
The input to the aggregate function avg can be non numeric data types
A primary key can never be null.
Which of the following is not a constraint on a single relation?
check
unique
not null
is duplicate
Which of the following normalization is needed, if an attribute of a composite key is dependent on an attribute of the other composite key?
BCNF
Second
Third
Fourth
In an Entity-Relationship Diagram Ellipses represents
Attributes
Weak entity set
Relationship sets
Multi-valued attributes
The index table has …… Columns.
1
2
3
4
Cross Product is a:
Unary Operator
Binary Operator
Ternary Operator
none of the above
View never contains derived columns.
True
False
Cant say
none
The attribute that can be divided into other attributes is called
Simple Attribute
Composite Attribute
Multi-valued Attribute
Derived Attribute
In a Hierarchical model records are organized as
Graph.
List.
Links.
Tree.
QBE
Query By Execution
Query By Example
Query By Extraction
None of the above.
Functional dependencies are generalization of
Relation dependencies
Data dependencies
key dependencies
none of the above
In an Entity-Relationship Diagram Diamonds represents
Attributes
Multi-valued attributes
Weak entity set
Relationship sets
In ………… paging we make copy of the current page table.
physical
logical
shadow
duplicate
Full form of CIDR
Classful Inter Domain Routing
Classless International Domain Routing
Classless Inter Domain Routing
none of these
Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.
Gray
White
Blue
Black
Database locking concept is used to solve the problem of
Lost Update
Uncommitted Dependency
Inconsistent Data
All of the above
Three SQL, DDL, CREATE commands are
Schema, Base and Table
Schema, Table and View
Base, Table and Schema
Key, Base and Table
A relation which is in 3NF is
in 1NF also
in 2NF also
free from transitive dependencies
All of these
The method by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is
Normalization
Indexing
Enforcing referential integrity
Enforcing data integrity
A transaction which may not complete its execution successfully is termed as
Failed
Aborted
Blocked
Finished