Database Management System
Questions 291 to 300
291.
|
What does the following
SQL statement do?
Select * From Customer
Where Cust_Type = "Best";
|
||||||||||
In an SQL statement,
which of the following parts states the conditions for row selection?
|
|||||||||||
Which of the following
questions is answered by the SQL statement?
Select Count
(Product_Description) from Product_T;
|
|||||||||||
All of the following
are advantages of SQL-invoked routines EXCEPT
|
|||||||||||
A type of query that is
placed within a WHERE or HAVING clause of another query is called
|
|||||||||||
Which of the following
is a procedure for acquiring the necessary locks for a transaction where all
necessary locks are acquired before any are released?
|
|||||||||||
Out
of the following activities, which is the one that normally
performed by DBMS, without the interference of the DBA?
|
|||||||||||
Horizontal Fragmentation is
|
|||||||||||
An index record appears for every search key value in the file
is
|
|||||||||||
Which of the following type of index is
automatically created when we do not specify?
| |||||||||||
Answers
291.
|
Answer : (a)
Reason: Select
|
Answer : (e)
Reason: In
an SQL statement where clause states the conditions for row selection
|
|
Answer : (b)
Reason: How many different product descriptions are in the Product Table?
|
|
Answer : (d)
Reason: Security
|
|
Answer : (b)
Reason: Sub-query
that is placed within a WHERE or HAVING clause of another query
|
|
Answer : (d)
Reason: Two-phase
lock is a procedure for acquiring
the necessary locks for a transaction where all necessary locks are acquired
before any are released
|
|
Answer : (e)
Reason: Recovery
is the one that normally is performed by DBMS, without the interference of
the DBA
|
|
Answer : (a)
Reason: Divide the data up by logical groups of records.
|
|
Answer : (b)
Reason: Dense Index record
appears for every search key valued in the file.
|
|
Answer : (b)
Reason: Balanced
Tree Index is automatically created when we do not specify.
|
<< Prev 1... 2... 3... 4... 5... 6... 7... 8... 9... 10... 11... 12... 13... 14... 15... 16... 17... 18... 19... 20... 21... 22... 23... 24... 25... 26... 27... 28... 29... 30... 31... 32... 33... 34... 35... 36... Next >>
Really nice
ReplyDeletedbms interview questions
spring interview questions