1Z0-007 Exam Questions

Which is a valid CREATE TABLE statement?

A SELECT statement can be used to perform these three functions: 1. Choose rows from a table. 2. Choose columns from a table 3. Bring together data that is stored in different tabl...

Which four are types of functions available in SQL? (Choose 4)

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER\ SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column D...

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

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEE...

Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"?

Which one is a system privilege?

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

You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL stateme...

Which statement correctly describes SQL and /SQL*Plus?

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

Exhibit Examine the data in the EMPLOYEES and DEPARTMENTS tables. You want to retrieve all employees' last names, along with their manager's last names and their department names....

The STUDENT_GRADES table has these columns: The registrar has asked for a report on the average grade point average (GPA), sorted from the highest grade point average to each semes...

Which are /SQL*Plus commands? (Choose all that apply.)

Examine the structure of the EMPLOYEES table: Which INSERT statement is valid?

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: Which DELETE statement is valid?

User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a public synonym, and would...

Exhibit The COMMISSION column shows the monthly commission earned by the employee. Which two tasks would require subqueries or joins in order to be performed in a single step? (Cho...

Evaluate this SQL statement: SELECT e.emp_name, d.dept_name FROM employees e JOIN departments d USING (department_id) WHERE d.department_id NOT IN (10,40) ORDER BY dept_name; The s...

Examine the statement: Create synonym emp for hr.employees; What happens when you issue the statement?

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE Which UPDATE statement is valid?

What is true about sequences?

The STUDENT_GRADES table has these columns STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) Which statement finds students who have a grade point average (GPA) greater than...

Exhibit Evaluate this SQL statement: SELECT cust_id, ord_total FROM orders WHERE ord_total > ANY (SELECT ord_total FROM orders WHERE cust_id IN (SELECT cust_id FROM customers WHERE...

Examine the data from the EMP table. Evaluate this SQL statement: SELECT * FROM emp WHERE commission = (SELECT commission FROM emp WHERE emp_id=3); What is the result when the quer...

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

Examine the data in the EMPLOYEES and DEPARTMENTS tables. You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query wo...

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

You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pa...

Examine the data in the EMPLOYEES table: Which three subqueries work? (Choose three)

The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As...

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

Examine the description of the EMPLOYEES table: Which statement shows the maximum salary paid in each job category of each department?

Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: Which statement ensures that...

Which syntax turns an existing constraint on?

Examine the description of the STUDENTS table: Which two aggregate functions are valid on the START_DATE column? (Choose two)

The EMPLOYEE tables have these columns: You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_p...

Examine the data from the ORDERS and CUSTOMERS table. Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that M...

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?

Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 2 FROM employees a, 3 (SELECT dept_id, MAX(sal) maxsal 4. FROM employees 5. GROUP BY dept_id) b 6. WHERE...

Examine the data in the EMPLOYEES and DEPARTMENTS tables: Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables: CREATE TABLE departments (department_id...

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

Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table?

Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?

Which data dictionary table should you query to view the object privileges granted to the user on specific columns?

Examine the structure of the EMPLOYEES and DEPARTMENTS tables: Evaluate this SQL statement: SELECT employee_id, e.department_id, department_name, Salary FROM employees e, departmen...

The EMP table contains these columns: You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPA...

Evaluate the SQL statement: SELECT ROUND (TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?

Examine the description of the MARKS table: SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table: SELECT...