Which of the following statement returns data to the host variables one at a time?
SELECT
RETURN
FETCH
GET
Correct Answer :
C. FETCH
Related Questions
What is the result of the following SQL statement ?
SELECT A.emp_Name, B.ph_num
FROM emp A LEFT OUTER JOIN phone B
ON A. emp_ID = B.emp_ID
A list of employees phone number
A list of all employees that have spouses, with phone number included in the list
A list of all employees names, including the phone number if they have one
Two lists : One list of employees, the other of phone numbers
A fragmentation is categorized in
1 part
2 part
3 part
4 part
Datalog is
procedural query language
nonprocedural query language
scan(), write()
none of the above
DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions
Backup
Recovery
Grant
Troubleshooting
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
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
Which of the following statements is not true about two tier client server database architecture?
SQL statements are processed on tier server
SQL statements may be processed on some of the clients
Business logic is mostly processed on clients
Business logic may be processed on the server
The method of access which uses key transformation is known as
direct.
hash.
random.
sequential.
Related fields in a database are grouped to form a
data file.
data record.
menu.
bank.
Unwanted energy from source other than the transmitter.
Attenuation
Distortion
Delay
Noise
Transaction access data using two operations
read(), print()
read(), write()
scan(), write()
none of the above
The left outer join takes all tuples
in the left relation which didnt match with any tuple in right relation
in the left relation which matched with a tuple in right relation
in the right relation which didnt match with any tuple in left relation
in the right relation which matched with a tuple in left relation
In E-R diagram Generalization is represented by
Circle
Rectangle
Hyperbola
Triangle
An operation that will increase the length of a list is
insert
modify
lookup
none of the above
The privilege lists include
i) select
ii) insert
iii) update
iv) delete
only i)
only i) ii)
only i) ii) iii)
i) ii) iii) iv)
In ………… paging we make copy of the current page table.
physical
logical
shadow
duplicate
Volatile storage
loses its contents when power is switched off.
doesnt loses its contents when power is switched off.
creates backup when power is switched off.
none
The output of the Data Definition Language is stored in the
view table
schema
metadata
all of the above.
The index table has …… Columns.
1
2
3
4
Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.
Gray
White
Blue
Black
The physical path over which a message travels
Thermal
Medium
Protocol
Impulse
Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization
i and ii only
ii and iii only
i and iii only
All i, ii iii
A transaction has following states
i) Active
ii) Fail
iii) Abort
iv) Commit
i and ii only
ii and iii only
i and iii only
iii and iv only
In two-phase locking
the data items are locked in growing phase.
the data items are released in shrinking phase.
Both A and B are true
Both A and B are false
An entity set which have sufficient attributes to form a primary key
Tree structure
Subtree structure
Strong entity set
Table structure
Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
In RDBMS, Data is presented as a collection of
Relation
Table
Attribute
Entity
Tape storage is referred to as
sequential access storage
direct access storage
random access 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.
Specialization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above