The following query is executed frequently against the EMPLOYEE table:SELECT empid, salary, bonus FROM employee ORDER BY bonus, salary;Which statement will create an index for optimal query performance?
Which item is NOT eligible for adaptive compression?
Which statement about block indexes is correct?
The following query is executed frequently against the SALES table:SELECT sales_id, sales_date, sales_person FROM sales;If data in the SALES_ID column is unique,Which statement will create an index for optimal query performance and ensure uniqueness of the SALES_ID column?
A database named TEST and a storage group named SG_1 were created with these statements:an error was produced. Why did the error occur?
When defining storage groups for multi-temperature data, storage paths are usually grouped according to their quality of service characteristics. What are three common quality of service characteristics used?
