1Z0-007 Exam Questions

Which two statements are true about WHERE and HAVING clauses? (Choose two)

EMPLOYEES and DEPARTMENTS data: On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID managers and refers to the EMPLOYEE_ID. On the DEPARTMENTS table DEPARTMENT...

Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition?

Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed?

The CUSTOMERS table has these columns: The CUSTOMER_ID column is the primary key for the table. You need to determine how dispersed your customer base is. Which expression finds th...

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

Examine the structure of the EMP_DEPT_VU view: Which SQL statement produces an error?

You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execu...

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

The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) ENAME VARCHAR2 (25) JOB_ID VARCHAR2(10) Which SQL statement will return the ENAME, length of the ENAME, and the nu...

Which four are valid Oracle constraint types? (Choose four.)

Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?

Which is an iSQL*Plus command?

Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the num...

Top N analysis requires _____ and _____. (Choose two.)

Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?

Evaluate this SQL statement: SELECT ename, sal, 12*sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calc...

You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table. Which set of statements accomp...

Which object privileges can be granted on a view?

Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CR...

What is true of using group functions on columns that contain NULL values?

The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) Which statement finds the highest grade point average (GPA) per semester?

In which four clauses can a subquery be used? (Choose four.)

Examine this statement: SELECT student_id, gpa FROM student_grades WHERE gpa > &&value; You run the statement once, and when prompted you enter a value of 2.0. A report is produced...

Which SQL statement returns a numeric value?

What are two reasons to create synonyms? (Choose two.)

What is true about updates through a view?

You need to write a SQL statement that returns employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less tha...

The CUSTOMERS table has these columns: A promotional sale is being advertised to the customers in France. Which WHERE clause identifies customers that are located in France?

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

Examine the description of the CUSTOMERS table: The CUSTOMER_ID column is the primary key for the table. Which statement returns the city address and the number of customers in the...

What does the FORCE option for creating a view do?

A data manipulation language statement _____.

Evaluate the SQL statement: SELECT LPAD (salary,10,'*') FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?

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

Exhibit: Examine the data in the EMPLOYEES table. Examine the subquery: SELECT last_name FROM employees WHERE salary IN (SELECT MAX(salary) FROM employees GROUP BY department_id);...

Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true? (Choose two.)

Which best describes an inline view?

Examine the structure of the EMPLOYEES and DEPARTMENTS tables: You want to create a report displaying employee last names, department names, and locations. Which query should you u...

The PRODUCTS table has these columns: PRODUCT_ID NUMBER (4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8,2) Evaluate this SQL statement: SELECT * FROM PRODUCTS ORDER BY price, product_...

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

Examine the structure of the EMPLOYEES table: You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a r...

The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?

Which view should a user query to display the columns associated with the constraints on a table owned by the user?

Examine these statements: CREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar; GRANT registrar to user1, user2, user3; What does this set of SQL statements do?

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

You need to design a student registration database that contains several tables storing academic information. The STUDENTS table stores information about a student. The STUDENT_GRA...

Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? (Choose three.)

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

Which three are true? (Choose three.)