which of the following is a binary operation?
project
select
rename
none of the above
Correct Answer :
D. none of the above
Related Questions
Which of the following operator preserves unmatched rows of the relations being joined?
Inner join
Outer join
union
Intersect
An association of several structure of a data base can be expressed graphically by?
Tuple
Record
Relationship
Field
Multivalued dependency is removed in
4 NF
3 NF
2 NF
1 NF
What does a field or a combination of fields that has a unique value called ?
Foreign key
Secondary key
Primary key
Alternate key
Which of the following statement returns data to the host variables one at a time?
SELECT
RETURN
FETCH
GET
What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps
Full form of CIDR
Classful Inter Domain Routing
Classless International Domain Routing
Classless Inter Domain Routing
none of these
What is ACID properties of Transactions?
Atomicity, Consistency, Isolation, Database
Atomicity, Consistency, Isolation, Durability
Atomicity, Consistency, Inconsistent, Durability
Automatically, Concurrency, Isolation, Durability
Which of the following Key is used to represent relationship between the tables?
Primary key
Secondary Key
Foreign Key
None of these
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
An advantage of the database management approach is
data is dependent on programs.
data redundancy increases.
data is integrated and can be accessed by multiple programs.
none of the above.
When all attributes in a relation tuple are not functionally dependent only on the key attribute. Which of the following normalization is needed?
first
second
third
fourth
In E-R diagram Generalization is represented by
Circle
Rectangle
Hyperbola
Triangle
DECLARE is a(an)
executable statement.
declarative statement.
Ordered file
none of the above
A functional dependency between two or more non-key attributes is called
Transitive dependency
Partial transitive dependency
Functional dependency
Partial functional dependency
Which of the following is not a constraint on a single relation?
check
unique
not null
is duplicate
Commit operation …………… writes the changes made to the database.
temporarily
permanently
none of these
all of the above
The mode in which data item may be locked
Partner
Mutual
Exclusive
Atomic
A transaction is said to have terminated if it has
either committed or aborted
either partially committed or aborted
either committed or failed
none of these
Tape storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
Which of the following is not proper state of transaction ?
Partially aborted
Partially committed
Aborted
Committed
Size of source and destination address in IP header
4 bits
8 bits
12 bits
32 bits
An operation that will increase the length of a list is
insert
modify
lookup
none of the above
The maximum number of children in a B-tree of order m is
m+1
m
m-1
m/2
Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.
Gray
White
Blue
Black
Which of the following will NOT eliminates the ambiguities of a null value?
Define the attribute as required
Define subtypes
Define each attribute as having an initial value that is recognized as blank
Define supertypes
which of the following is a binary operation?
project
select
rename
none of the above
Technique(s) used for data recovery after any failure
Logging
Recovery manager
Both A and B are true
Both A and B are false
The number of cursors depend on the
number of queries
number of attributes
size of memory area
none of these
The output of the Data Definition Language is stored in the
view table
schema
metadata
all of the above.