1Z0-007 Exam Questions

Which /SQL*Plus feature can be used to replace values in the WHERE clause?

You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less then $500 or greater than $900 You want to sort the results...

Examine the structures of the EMPLOYEES and TAX tables. You need to find the percentage tax applicable for each employee. Which SQL statement would you use?

Which are DML statements? (Choose all that apply)

Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option...

Examine the structure of the EMPLOYEES table: You issue these statements: CREATE table new_emp ( employee_id NUMBER, name VARCHAR2(30)); INSERT INTO new_emp SELECT employee_id , la...

Which two are attributes of iSQL*Plus? (Choose two)

In which scenario would index be most useful?

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

Examine the structure of the EMPLOYEES table: What is the correct syntax for an inline view?

Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000?

When should you create a role? (Choose two)

Which three statements about subqueries are true? (Choose three)

Examine the structure of the EMPLOYEES table: You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values speci...

In which case would you use a FULL OUTER JOIN?

Which two statements accurately describe a role? (Choose two.)

What is necessary for your query on an existing view to execute successfully?

The EMP table has these columns: Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required re...

Examine the data in the EMPLOYEES table. On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a...

Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC; Wha...

You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement should you use?

The CUSTOMERS table has these columns: Which statement finds the rows in the CUSTOMERS table that do not have a postal code?

The ORDERS table has these columns: The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retrieve orders with...

Examine the data in the EMPLOYEES and EMP_HIST tables: The EMP_HIST table is updated at the end of every year. The employee ID, name, job ID, and salary of each existing employee a...

Examine the data of the EMPLOYEES table. EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID) Evaluate this SQL statement: SELECT...

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

You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone...

Which SELECT statement will the result `ello world' from the string `Hello World'?

Evaluate this SQL statement: SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales amount * (.35 * e.bonus)) AS CALC_VALUE FROM employees e, sales s WHERE e.em...

From SQL*Plus, you issue this SELECT statement: SELECT * From orders; You use this statement to retrieve data from a data table for __________. (Choose all that apply)

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?

The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar requested a report listing the students' grade point averages (GPA...

Which describes the default behavior when you create a table?

Which four are attributes of single row functions? (Choose four.)

You need to create a table named ORDERS that contain four columns: 1. an ORDER_ID column of number data type 2. a CUSTOMER_ID column of number data type 3. an ORDER_STATUS column t...

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

The user Sue issues this SQL statement: GRANT SELECT ON sue.EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue.EMP TO reena WITH GRANT OP...

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...

The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL CUSTOMER_ADDRESS VARCHAR2(150) CUSTOMER_PHONE VARCHAR2(20) You need to pr...

What is true about sequences?

Which two are character manipulation functions? (Choose two.)

Which three statements correctly describe the functions and use of constraints? (Choose three.)

You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=". What happens when the main query is executed?

You need to calculate the total of all salaries in the accounting department. Which group function should you use?

What is true about joining tables through an equijoin?

Scott issues the SQL statements: If Sue needs to select from Scott's DEPT table, which command should she use?