Oracle Oracle Certifications 1Z0-082 Questions & Answers

• Question 111:

  Which three statements are true about using SQL*Plus?

  A. It has its own commands that are separate from any SQL statements.

  B. It must be downloaded from the Oracle Technology Network (OTN).

  C. It can run scripts entered at the SQL prompt.

  D. It can run Recovery Manager (RMAN) commands.

  E. It has both command-line and graphical user interfaces (GUI).

  F. It can run scripts passed to it by a shell script.

  Correct Answer: ACF

• Question 112:

  Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)

  A. Column positions must be used in the ORDER BY clause

  B. Only column names from the first SELECT statement in the compound query are recognized

  C. The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause

  D. Each SELECT statement in the compound query must have its own ORDER BY clause

  E. Each SELECT statement in the compound query can have its own ORDER BY clause

  Correct Answer: BC

  select employee_id,last_name "Last Name" FROM employees where employee_id=101 union select employee_id EMP_NO, last_name from employees where employee_id=113; C is correct.

• Question 113:

  Which two statements are true about single row functions? (Choose two.)

  A. MOD : returns the remainder of a division operation.

  B. FLOOR : returns the smallest integer greater than or equal to a specified number.

  C. TRUNC : can be used only with NUMBER data types.

  D. CONCAT : can be used to combine any number of values

  E. CEIL : can be used for positive and negative numbers

  Correct Answer: CE

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Single-Row-Functions.html#GUID-B93F789D-B486-49FF-B0CD-0C6181C5D85C

• Question 114:

  Which three statements are true about the Automatic Diagnostic Repository (ADR)?

  A. It is held inside an Oracle database schema.

  B. The ADR base is specified in the DIAGNIOSTIC_DEST database parameter.

  C. It is only used for Oracle Database diagnostic information.

  D. It is a file-based repository held outside any database.

  E. It can be used for problem diagnosis of a database when that database's instance is down.

  Correct Answer: BDE

• Question 115:

  Examine this command and some partial output:

  

  Why does the DB01.abc.com service show unknown status?

  A. The service DB01.abc.com is dynamically registered

  B. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1

  C. The service DB01.abc.com is statically registered

  D. The listener is not listening on the default port 1521

  E. The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file

  Correct Answer: C

  An UNKNOWN status means that the instance is registered statically (with a SID_LIST) in the listener. ora file rather than dynamically with service registration. Therefore, the database status is "not known" to the listener.

• Question 116:

  Which two statements are true regarding a SAVEPOINT? (Choose two.)

  A. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement

  B. Rolling back to a SAVEPOINT can undo a TRUNCATE statement

  C. Only one SAVEPOINT may be issued in a transaction

  D. A SAVEPOINT does not issue a COMMIT

  E. Rolling back to a SAVEPOINT can undo a DELETE statement

  Correct Answer: DE

• Question 117:

  Examine these commands:

  

  Which two statements are true about the sqiidr execution?

  A. It generates a sqi script that it uses to load data from EMP.DAT TO EMP.

  B. It overwrites the data for Alan and adds data for Curl and Bob

  C. It appends data from EMP.DAT TO EMP.

  D. It overwrites all data in emp with data from emp.dat.

  E. It generates a log that contains control file entries, which can be used with normal SQL'Loader operations.

  Correct Answer: AC

• Question 118:

  You execute this command:

  

  Sufficient storage is available in filesystem /u01.

  Which two statements are true about the BIG_TBS tablespace? (Choose two.)

  A. AUTOEXTEND is possible for the datafile

  B. It must be bigger than the largest SMALLFILE tablespace

  C. Additional data files may not be added

  D. It will be a dictionary-managed tablespace by default

  E. It will always have a 32K blocksize

  Correct Answer: AC

• Question 119:

  Which two statements are true about the Oracle Data Dictionary?

  A. It is owned by the SYS user.

  B. Data dictionary base tables can be queried directly.

  C. It is owned by the SYSTEM user.

  D. Data dictionary views are always created with queries that join two or more base tables.

  E. All data dictionary view join base tables to dynamic performance views.

  Correct Answer: AB

• Question 120:

  Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.)

  A. Tablespace free space can be viewed in V$TABLESPACE

  B. V$TABLESPACE displays information that is contained in the controlfile about tablespaces

  C. V$TABLESPACE displays information about tablespaces contained in the data dictionary

  D. Tablespace free space can be viewed in DBA_TABLESPACES

  E. A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened

  Correct Answer: BE

  SQL> shutdown immediate;

  Database closed.

  E correct.

  Database dismounted.

  ORACLE instance shut down.

  SQL> startup mount;

  ORACLE instance started.

  Total System Global Area 1375731600 bytes

  Fixed Size 8896400 bytes

  Variable Size 838860800 bytes

  Database Buffers 520093696 bytes

  Redo Buffers 7880704 bytes

  Database mounted.

  SQL> alter database move datafile '/oradata/ORA19/testing1.dbf' to '/oradata/ORA19/testing01.dbf';