Blog

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

Below find the structure of the CUSTOMERS and SALES_ORDER tables: CUSTOMERS:CUSTOMER_ID NUMBER NOT NULL, Primary KeyCUSTOMER_NAME VARCHAR2 (30) CONTACT_NAME VARCHAR2 (30)CONTACT_TITLE VARCHAR2 (20)ADDRESS VARCHAR2 (30)CITY VARCHAR2 (25)REGION VARCHAR2 (10)POSTAL_CODE VARCHAR2 (20)COUNTRY_ID NUMBER Foreign key to COUNTRY_ID column of the COUNTRY table PHONE VARCHAR2 (20)FAX VARCHAR2 (20) CREDIT_LIMIT NUMBER(7,2)SALES_ORDER:ORDER_ID NUMBER NOT NULL, Primary KeyCUSTOMER_ID NUMBER Foreign key to CUSTOMER_ID column of the CUSTOMER tableORDER_DT DATE ORDER_AMT NUMBER (7,2) SHIP_METHOD VARCHAR2 (5) You need to create a report that displays customers without a sales order. Which statement could you use?

You need to display all the players whose salaries are greater than or equal to John Brown’s salary. Which comparison operator should you use?