1Z0-007 Exam Questions
196 real 1Z0-007 exam questions with expert-verified answers and explanations. Page 1 of 4.
- Question #1
Which statement explicitly names a constraint?
- Question #2
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)
- Question #3
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...
- Question #4
For which two constraints does the Oracle Server implicitly create a unique index? (Choose two.)
- Question #5
Which three SELECT statements displays 2000 in the format "$2,000.00"? (Choose three)
- Question #7
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...
- Question #8
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...
- Question #9
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...
- Question #10
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...
- Question #11
Examine the structure of the EMPLOYEES and NEW EMPLOYEES tables: Which MERGE statement is valid?
- Question #12
Which two are true about aggregate functions? (Choose two.)
- Question #13
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,...
- Question #14
In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement?
- Question #15
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...
- Question #16
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...
- Question #17
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...
- Question #18
Which four statements correctly describe functions that are available in SQL? (Choose four)
- Question #19
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...
- Question #20
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.)
- Question #21
Which two tasks can your perform by using the TO_CHAR function? (Choose two)
- Question #22
Which two statements are true regarding the ORDER BY clause? (Choose two)
- Question #23
Which two statements about sequences are true? (Choose two)
- Question #24
Which four are correct guidelines for naming database tables? (Choose four)
- Question #25
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...
- Question #26
Which operator can be used with a multiple-row subquery?
- Question #27
Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables. For which situation would you use a nonequijoin query?
- Question #28
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...
- Question #29
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?
- Question #30
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...
- Question #31
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,...
- Question #32
Which clause should you use to exclude group results?
- Question #33
A subquery can be used to _________.
- Question #34
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...
- Question #35
Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?
- Question #36
Which is an /SQL*Plus command?
- Question #37
What does the TRUNCATE statement do?
- Question #38
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...
- Question #39
Which statement creates a new user?
- Question #40
Which three are true regarding the use of outer joins? (Choose three.)
- Question #41
In which scenario would TOP N analysis be the best solution?
- Question #43
What is true about the WITH GRANT OPTION clause?
- Question #44
Which substitution variable would you use if you want to reuse the variable without prompting the user each time?
- Question #45
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...
- Question #46
The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?
- Question #47
Which two statements complete a transaction? (Choose two)
- Question #48
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...
- Question #49
Which statement describes the ROWID data type?
- Question #50
Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? (Choose four)
- Question #51
You are granted the CREATE VIEW privilege. What does this allow you to do?
- Question #52
Which two statements about creating constraints are true? (Choose two)