Tag: databases

Index

Page allocation

Trigger creation

None of the above

Index

Page deallocation

Trigger creation

None of the above

Strong Question Language

Structured Query Language

Structured Question Language

None of the Above

TRUNCATE

DELETE

DELETE ALL

REMOVE

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

2

4

3

5

ASCENDING

DESCENDING

RANDOM

PHYSICAL

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)?

10

1

5

50

WHERE

HAVING

HAVING BY

ORDER BY