Blog

You want to create a table named TRAVEL that is a child of the EMPLOYEES table. Which of the following statements should you issue?

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?