1Z0-007 Exam Questions

Which statement explicitly names a constraint?

Examine the SQL statements that create ORDERS table: For which columns would an index be automatically created when you execute the above SQL statement? (Choose two)

You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID colum...

For which two constraints does the Oracle Server implicitly create a unique index? (Choose two.)

Which three SELECT statements displays 2000 in the format "$2,000.00"? (Choose three)

Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. Which two SQL statements produce the name, department name, and the city of all the employees who earn mo...

Examine the description of the EMPLOYEES table: Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only of the minimum salary is l...

Examine the structure if the EMPLOYEES table: You need to create a view called EMP_VU that allows the user to insert rows through the view. Which SQL statement, when used to create...

The STUDENT_GRADES table has these columns: The registrar has asked for a report on the average grade point average (GPA) for students enrolled during semesters that end in the yea...

Examine the structure of the EMPLOYEES and NEW EMPLOYEES tables: Which MERGE statement is valid?

Which two are true about aggregate functions? (Choose two.)

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) Which statement lists the ID, name,...

In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?

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

You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement wou...

Examine the structure of the STUDENTS table: You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in t...

Which four statements correctly describe functions that are available in SQL? (Choose four)

Examine the data from the EMP table: The COMMISSION column shows the monthly commission earned by the employee. Which three tasks would require subqueries or joins in order to perf...

The CUSTOMERS table has these columns: The CUSTOMER_ID column is the primary key for the table. Which two statements find the number of customers? (Choose two.)

Which two tasks can your perform by using the TO_CHAR function? (Choose two)

Which two statements are true regarding the ORDER BY clause? (Choose two)

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

Which four are correct guidelines for naming database tables? (Choose four)

Examine the structure of the EMPLOYEES table: You need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would y...

Which operator can be used with a multiple-row subquery?

Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables. For which situation would you use a nonequijoin query?

Examine the data from the ORDERS and CUSTOMERS tables. Evaluate the SQL statement: SELECT * FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Smith'); W...

You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results?

You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT...

Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement,...

Which clause should you use to exclude group results?

A subquery can be used to _________.

The EMPLOYEES table contains these columns: You need to write a query that will produce these results: 1. Display the salary multiplied by the commission_pct. 2. Exclude employees...

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

Which is an /SQL*Plus command?

What does the TRUNCATE statement do?

You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column ca...

Which statement creates a new user?

Which three are true regarding the use of outer joins? (Choose three.)

In which scenario would TOP N analysis be the best solution?

What is true about the WITH GRANT OPTION clause?

Which substitution variable would you use if you want to reuse the variable without prompting the user each time?

The EMPLOYEES table has these columns: LAST NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the...

The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?

Which two statements complete a transaction? (Choose two)

You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns: Which SELE...

Which statement describes the ROWID data type?

Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? (Choose four)

You are granted the CREATE VIEW privilege. What does this allow you to do?

Which two statements about creating constraints are true? (Choose two)