Blog

Which of the following SQL statements will display the index name, table name, and the uniqueness of the index for all indexes on the EMPLOYEES table?

Which of the following keywords cannot be used when creating a view?

You cannot modify data in a view if the view contains ______.

Which statement about decreasing the width of a column is true?

Which statement about table and column names is true?

Which type of constraint by default requires that a column be both unique and not null?

What will the following SQL Statement do? SELECT job_id, COUNT(*) FROM employees GROUP BY job_id;

The CUSTOMERS and SALES tables contain these columns: CUSTOMERS:CUST_ID NUMBER(10) PRIMARY KEY COMPANY VARCHAR2(30) LOCATION VARCHAR2(20) SALES:SALES_ID NUMBER(5) PRIMARY KEY CUST_ID NUMBER(10) FOREIGN KEY TOTAL_SALES NUMBER(30) Which SELECT statement will return the customer ID, the company and the total sales?

You want to create a report that displays all orders and their amounts that were placed during the month of January. You want the orders with the highest amounts to appear first. Which query should you issue?

Examine the following EMPLOYEES table: EMPLOYEES:EMPLOYEE_ID NUMBER(9)LAST_NAME VARCHAR2(25)FIRST_NAME VARCHAR2(25)DEPARTMENT_ID NUMBER(9)SUPERVISOR_ID NUMBER(9) You need to produce a report that contains all employee-related information for those employees who have Brad Carter as a supervisor. However, you are not sure which supervisor ID belongs to Brad Carter. Which query should you issue to accomplish this task?