Blog

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?

You need to delete a record in the EMPLOYEES table for Tim Jones, whose unique employee identification number is 348. The EMPLOYEES table contains these columns:EMPLOYEE_ID NUMBER(5) PRIMARY KEYLAST_NAME VARCHAR2(20)FIRST_NAME VARCHAR2(20)ADDRESS VARCHAR2(30)PHONE NUMBER(10)Which DELETE statement will delete the appropriate record without deleting any additional records?

The PRICE table contains this data: PRODUCT_ID MANUFACTURER_ID 86950 59604 You query the database and return the value 95. Which SQL script did you use?

Which SELECT statement will NOT return a date value?

Using Oracle Proprietary join syntax, which two operators can be used in an outer join condition using the outer join operator (+)?