is related to
Index
Page allocation
Trigger creation
None of the above
reservepagegap can be used in any one of the following
Page deallocation
What does SQL stand for??
Strong Question Language
Structured Query Language
Structured Question Language
None of the Above
Which of the statement allows you to roll back and creates log in the transaction log?
TRUNCATE
DELETE
DELETE ALL
REMOVE
Arrange the keyword “FROM, WHERE, SELECT, HAVING,GROUP BY, ORDER BY ” in the proper ?order
SELECT, FROM , WHERE,GROUP BY, ORDER BY, HAVING?
SELECT, FROM, WHERE, ORDER BY, HAVING,GROUP BY
SELECT, FROM, WHERE, ORDER BY, GROUP BY, HAVING
SELECT, FROM , WHERE,GROUP BY, HAVING, ORDER BY
The Minimum number of tables required to establish a many to many relationships are...
2
4
3
5
What will be the default sort order if nothing is specified explicitly in the SELECT statement?
ASCENDING
DESCENDING
RANDOM
PHYSICAL
UNION vs. UNION ALL
UNION only selects distinct values, UNION ALL selects all values (excluding ?duplicates)?
UNION ALL only selects distinct values, UNION selects all values (including ?duplicates)?
UNION only selects distinct values, UNION ALL selects all values (including ?duplicates)?
UNION ALL only selects distinct values, UNION selects all values (excluding ?duplicates)?
The Query has Main and Sub Query. If the main query returns 10 records and subquery returns 5 records, then how many times the subquery gets executed?
10
1
50
Which CLAUSE is used in a SELECT statement to filter the records that a GROUP BY returns?
WHERE
HAVING
HAVING BY
ORDER BY