1Z0-061 Exam Questions

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

Which two statements are true regarding the USING clause in table joins?(Choose two.)

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 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: CUST_ID. N...

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)

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

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

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?

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

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

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?

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 sub query 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.)