Exam information

Exam 1z0-007: Introduction to Oracle9i: SQL

Other exams

Which SQL statement do you use?

The EMPLOYEES table contains these columns:EMPLOYEE_ID NUMBER(4)LAST_NAME VARCHAR2 (25)JOB_ID VARCHAR2(10)You want to search for strings that contain ‘SA_’ in the JOB_ID column. Which SQL statement doyou use?

What happens when you execute this DELETE statement?

You own a table called EMPLOYEES with this table structure:EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)HIRE_DATE DATEWhat happens when you execute this DELETE statement?DELETE employees;

Which statement accomplishes this?

You need to create a table named ORDERS that contains four columns:1. an ORDER_ID column of number data type2. a CUSTOMER_ID column of number data type3. an ORDER_STATUS column that contains a character data type4. a DATE_ORDERED column to contain the date the order was placedWhen a row is […]

which capabilities of a SELECT statement are performed?

Evaluate this SQL statement:SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAMEFROM EMPLOYEES e, DEPARTMENTS dWHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;In the statement, which capabilities of a SELECT statement are performed?

Which three are DATETIME data types that can be used when specifying column definitions?

Which three are DATETIME data types that can be used when specifying column definitions?(Choose three.)

Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?

Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?

Which three statements insert a row into the table?

Examine the structure of the EMPLOYEES table:EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)Which three statements insert a row into the table? (Choose three.)

Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?

Which SELECT statement should you use to extract the year from the system date and display itin the format "1998"?

Which two statements about sequences are true?

Which two statements about sequences are true? (Choose two.)

which two cases would you use an outer join?

In which two cases would you use an outer join? (Choose two.)

Page 1 of 1112345...10...Last »