Oracle Oracle Certifications 1Z0-082 Questions & Answers

• Question 61:

  Which two statements are true about User Authentication in an Oracle Database?

  A. Operating System authentication may be used for system-privileged administrative users.

  B. REMOTE_LOGIN_PASSWORDFILE must be set to exclusive to permit password changes for system-privileged administrative users.

  C. Password authentication must be used for system-privileged administrative users.

  D. Password File authentication must be used for system-privileged administrative users.

  E. Password File authentication is supported for any type of database user.

  Correct Answer: AB

• Question 62:

  Which two statements are true about Oracle synonyms?

  A. A synonym has an object number.

  B. A synonym can be created on an object in a package.

  C. A synonym can have a synonym.

  D. All private synonym names must be unique in the database.

  E. Any user can create a PUBLIC synonym.

  Correct Answer: AC

• Question 63:

  Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

  A. GLOBAL TEMPORARY TABLE space allocation occurs at session start.

  B. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

  C. A TRUNCATE command issued in a session causes all news in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.

  D. A GLOBAL TEMPORARY TABLE 's definition is available to multiple sessions.

  E. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

  F. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

  Correct Answer: CDF

  https://docs.oracle.com/javadb/10.8.3.0/ref/rrefdeclaretemptable.html

• Question 64:

  Which three are types of segments in an Oracle Database? (Choose three.)

  A. undo

  B. index

  C. stored procedures

  D. sequences

  E. tables

  F. clusters

  Correct Answer: ABE

  Reference: http://www.adp-gmbh.ch/ora/concepts/segments.html

• Question 65:

  In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.

  The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

  

  Which statement is true?

  A. Dynamic service registration cannot be used for this database instance

  B. The LREG process registers services dynamically with the LISTENER_1 listener

  C. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration

  D. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances

  E. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

  Correct Answer: B

  The listener forwards client requests to supported services. These services are dynamically registered with the listener. This dynamic registration feature is called service registration. The registration is performed by the Listener Registration (LREG) process. Dynamic service registration does not require any manual configuration in the listener.ora file.

  Reference: https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292

• Question 66:

  Evaluate these commands which execute successfully:

  

  Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

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

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

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

  D. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

  E. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

  Correct Answer: BC

• Question 67:

  Which two statements are true about UNDO and REDO? (Choose two.)

  A. The generation of UNDO generates REDO

  B. DML modifies Oracle database objects and only generates UNDO

  C. The generation of REDO generates UNDO

  D. DML modifies Oracle database objects and only generates REDO

  E. DML modifies Oracle database objects and generates UNDO and REDO

  Correct Answer: AE

  ... undo is stored in redo logs also. During roll forward phase of instance/media recovery, as changes (redo in redo logs) are applied to datafiles, undo stored in redo logs is used to generate undo segments. These segments are subsequently used to rollback uncommitted changes during rollback phase of instance/media recovery.

  https://www.experts-exchange.com/articles/13880/UNDO-AND-REDO-IN-ORACLE.html

• Question 68:

  Which three statements are true about connection strings and service names used to connect to an Oracle database instance?

  A. A single database instance can support connections for multiple service names.

  B. A service name is created by a listener.

  C. A single connection string can refer to multiple database instances.

  D. A connection string including a service name must be defined in the cnsnames.ora file.

  E. A connection string must include the SID of a database Instance.

  F. Different connection strings in the same tnsnames.ora file can contain the same service name, host and port parameters.

  Correct Answer: ACF

• Question 69:

  The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.

  You want to display the date of the first Monday after the completion of six months since hiring.

  The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the week.

  Which query can be used?

  A. SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY(`MONDAY') FROM employees;

  B. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), `MONDAY') FROM employees;

  C. SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;

  D. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;

  Correct Answer: B

  "The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day of the week."

  1 is Sunday in that case.

  ALTER SESSION SET NLS_TERRITORY = "AMERICA";

  SELECT employee_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 'MONDAY') FROM employees;

  Result = 22-DEC-03 (Monday)

  SELECT employee_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;

  Result = 21-DEC-03 (Sunday)

• Question 70:

  You currently have an active transaction in your session and have been granted select access to vstransaction.

  

  In which three situations will re-executing this query still return a row but with a different XID, indicating a new transaction has started?

  A. after successfully executing a commit or rollback followed by a select statement

  B. after successfully executing a create table as select statement followed by a select for update statement

  C. after successfully executing a commit or rollback followed by a DML statement

  D. after successfully executing a create table statement followed by a create index statement

  E. after successfully executing a DML statement following a failed DML statement

  F. after successfully executing a truncate statement followed by a DML statement

  Correct Answer: BCF