Oracle Oracle Certifications 1Z0-071 Questions & Answers

• Question 191:

  Which two statements are true about the SET VERIFY ON command?

  A. It displays values for variables created by the DEFINE command.

  B. It can be used in SQL Developer and SQL*Plus.

  C. It can be used only in SQL*plus.

  D. It displays values for variables prefixed with andand.

  E. It displays values for variables used only in the WHERE clause of a query.

  Correct Answer: BD

• Question 192:

  Examine these statements:

  

  Which is true ahout modifyIng the columns in AITER_TEST?

  A. c1 can be changed to NUMBER(10) and c2 can be changed to VARCHAN2 (10).

  B. c2 can be changed to NUMBER(5) but c1 cannot be changed to VARCHAN2 (5).

  C. c2 can be changed to VARCHAR2(10) but c1 cannot be changed to NUMBER (10).

  D. c1 can be changed to NUMBER(10) but c2 cannot be changed to VARCHAN2 (10).

  E. c1 can be changed to VARCHAR2(5) and c2 can be changed to NUMBER (12,2).

  Correct Answer: E

• Question 193:

  Evaluate these commands Which execute successfully Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

  

  A. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers.

  B. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times.explicit value is given for ORD_NO.

  C. Column ORD_NO gets the next number from sequence and ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO.

  D. If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS.

  E. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ.

  Correct Answer: CE

• Question 194:

  Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.

  Only the EMPLOYEES_ID column is indexed.

  Rows exist for employees 100 and 200.

  Examine this statement:

  

  Which two statements are true?

  A. Employees 100 and 200 will have the same SALARY as before the update command.

  B. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200.

  C. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100.

  D. Employees 100 and 200 will have the same JOB_ID as before the update command.

  E. Employee 100 will have SALARY set to the same value as the SALARY of employee 200.

  F. Employee 200 will have SALARY set to the same value as the SALARY of employee 100.

  Correct Answer: BE

• Question 195:

  Which two statements are true about * _ TABLES views?

  A. You must have SELECT privileges on a table to view it in ALL _TABLES.

  B. You must have SELECT privileges on a table to view it in DBA TABLES.

  C. USER_ TABLES displays all tables owned by the current user.

  D. ALL TABLES displays all tables owned by the current user.

  E. You must have SELECT privileges on a table to view it in USER TABLES.

  F. All users can query DBA TABLES successfully.

  Correct Answer: AC

• Question 196:

  Examine the data in the INVOICES table:

  

  Examine the data in the CURRENCIES table:

  

  Which query returns the currencies in CURRENCIES that are not present in INVOICES?

  A. SELECT currency_ code FROM currencies MINUS SELECT currency_ code FROM invoices;

  B. SELECT * FROM currencies WHERE NOT EXISTS ( SELECT NULL FROM invoices WHERE currency_ code = currency_ code);

  C. SELECT currency_ code FROM currencies INTERSECT SELECT currency_ code FROM invoices;

  D. SELECT * FROM currencies MINUS SELECT * FROM invoices;

  Correct Answer: A

• Question 197:

  Examine these statements: Which two are true? (Choose two.)

  

  A. The MGR column in the DEPT table will not be able to contain NULL values.

  B. The CREATE TABLE EMP statement must precede the CREATE TABLE DEPT statement for all threestatements to execute successfully.

  C. Both foreign key constraint definitions must be removed from the CREATE TABLE statements, andbe added with ALTER TABLE statements once both tables are created, for the two CREATE TABLEstatements to execute successfully in the order shown.

  D. The DEFT FKEY constraint definition must be removed from the CREATE TABLE DEF statement.and be added with an AITER TABLE statement once both tables are created, for the two CREATE TABLE statements to execute successfully in the order shown.

  E. The Deptno column in the emp table will be able to contain nulls values.

  F. All three statements execute successfully in the order shown

  Correct Answer: DE

• Question 198:

  Which statement is true regarding the SESSION_PRIVS dictionary view?

  A. It contains the object privileges granted to other users by the current user session.

  B. It contains the system privileges granted to other users by the current User session.

  C. It contains the current system privileges available in the user session.

  D. It contains the current object privileges available in the user session.

  Correct Answer: C

• Question 199:

  Which two statements are true about transactions in the Oracle Database server?

  A. An uncommitted transaction commits automatically if the user exits SQL*Plus

  B. Data Manipulation Language (DML) statements always start a new transaction.

  C. A user can always see uncommitted updates made by the same user in a different session.

  D. A Data Definition Language (DDL) statement does a commit automatically only for the data dictionary updates caused by the DDL

  E. A session can always see uncommitted updates made by itself.

  F. If a session has an uncommitted transaction, then a DDL statement issue a COMMIT before starting a new transaction.

  Correct Answer: AE

• Question 200:

  Examine the description of the EMPLOYEES table:

  

  NLS_DATE_FORMAT is set to DD-MON-YY. Which query requires explicit data type conversion?

  A. SELECT salary + 120.50 FROM employees;

  B. SELECT SUBSTR(join date, 1, 2)- 10 FROM employees;

  C. SELECT join date 11.'11 salary FROM employees;

  D. SELECT join date FROM employees where join date > *10-02-2018*;

  E. SELECT join date + 20 FROM employees;

  Correct Answer: D