Oracle 1Z0-082 Online Practice Questions and Exam Preparation

Oracle 1Z0-082 Online Questions & Answers

• Question 161:

  You execute this command:

  

  During the export operation, you detach from the job by using CTRL+C and then execute this command:

  Export> STOP_JOB=immediate

  Are you sure you wish to stop the job ([yes]/no): yes

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

  A. You can no longer monitor it
  B. You can reattach to it and monitor it
  C. It is paused and can be resumed
  D. It continues to run in the background
  E. It terminates
  B. You can reattach to it and monitor it
  C. It is paused and can be resumed

  ---

  Explanation/Reference:

  see the example which is done on 12c version

  B. You can reattach to it and monitor it

  C. It is paused and can be resumed

  Reference: https://blog.oracle48.nl/killing-and-resuming-datapump-expdp-and-impdp-jobs/

• Question 162:

  Which statement is true about database links?

  A. Private database link creation requires the same user to exist in both the local and the remote databases.
  B. A public database link can be created only by SYS.
  C. A database link can be created only between two Oracle databases.
  D. A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.
  E. A database link created in a database allows a connection from that database's instance to the target database's Instance, but not vice versa.
  E. A database link created in a database allows a connection from that database's instance to the target database's Instance, but not vice versa.

  ---

  Explanation/Reference:

• Question 163:

  TBS1 is a permanent user-defined tablespace. Oracle Managed Files (OMF) is not used in this database.

  Examine this command:

  DROP TABLESPACE TBS1;

  Which two actions will ensure that TBS1 is dropped and its data files are deleted from the file system? (Choose two.)

  A. TBS1 must not contain any temp files.
  B. There must be no uncommitted transactions involving segments stored in TBS1.
  C. TBS1 must be READ WRITE.
  D. The INCLUDING CONTENTS AND DATAFILES clause must be added to the command.
  E. TBS1 must be altered READ ONLY.
  B. There must be no uncommitted transactions involving segments stored in TBS1.
  D. The INCLUDING CONTENTS AND DATAFILES clause must be added to the command.

• Question 164:

  While one of your databases was in mount state, the datafiles were renamed because they had been moved to a new file system. The database was then opened.

  Which two statements are true?

  A. DBA_DATA_FILES displays the original name for the data files.
  B. V$DATAFILE displays the new names for the data files.
  C. DBA_DATA _FILES displays both the new name and the old name for the data files.
  D. DBA_DATA_FILES displays the new name for the data files.
  E. DBA_DATA_FILES must be resynchronized manually with the control file an order to have it display the new file names.
  A. DBA_DATA_FILES displays the original name for the data files.
  C. DBA_DATA _FILES displays both the new name and the old name for the data files.

• Question 165:

  Examine this command:

  CREATE UNDO TABLESPACE undotbs01

  DATAFILE `undotbs_01.dbf'

  SIZE 100M

  AUTOEXTEND ON;

  Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

  A. Add the SEGMENT SPACE MANAGEMENT AUTO clause
  B. Set UNDO_TABLESPACE to UNDOTBS01
  C. Add the NOLOGGING clause
  D. Make certain that the database operates in automatic undo management mode
  E. Add the ONLINE clause
  B. Set UNDO_TABLESPACE to UNDOTBS01
  D. Make certain that the database operates in automatic undo management mode

  ---

  Explanation/Reference:

  SQL>alter system set undo_management=manual scope=spfile; Bounce instance.

  SQL> show parameter undo NAME TYPE VALUE

  temp_undo_enabled boolean FALSE

  undo_management string MANUAL

  undo_retention integer 900

  undo_tablespace string UNDOTBS1

  SQL> alter system set undo_tablespace='UNDOTBS2';

  alter system set undo_tablespace='UNDOTBS2'

  *

  ERROR at line 1:

  ORA-02097: parameter cannot be modified because specified value is invalid

  ORA-30014: operation only supported in Automatic Undo Management mode

• Question 166:

  You must create a tablespace of non-standard block size in a new file system and plan to use this command:

  

  The standard block size is 8k but other non-standard block sizes will also be used. Which two are requirements for this command to succeed?

  A. DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE.
  B. DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA.
  C. DB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE.
  D. The /u02 file system must have at least 100g space for the datafile.
  E. The operating system must use a 32k block size.
  F. DB_CACHE_SIZE must be set to a size that is smaller than DB_32K_CACHE_SIZE.
  B. DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA.
  D. The /u02 file system must have at least 100g space for the datafile.

  ---

  Explanation/Reference:

• Question 167:

  Which statement is true about aggregate functions?

  A. Aggregate functions can be nested to any number of levels
  B. The AVG function implicitly converts NULLS to zero
  C. Aggregate functions can be used in any clause of a SELECT statement
  D. The MAX and MIN functions can be used on columns with character data types
  D. The MAX and MIN functions can be used on columns with character data types

• Question 168:

  You execute this command:

  CREATE SMALLFILE TABLESPACE sales DATAFILE `/u01/app/oracle/sales01.dbf SIZE 5G SEGMENT SPACE MANAGEMENT AUTO;

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

  A. It must be smaller than the smallest BIGFILE tablespace
  B. Free space is managed using freelists
  C. Any data files added to the tablespace must have a size of 5 gigabytes
  D. It uses the database default blocksize
  E. It is a locally managed tablespace
  D. It uses the database default blocksize
  E. It is a locally managed tablespace

  ---

  Explanation/Reference:

  Incorrect segment management clause It lets you specify whether Oracle Database should track the used and free space in the segments in the tablespace using free lists or bitmaps. This clause is not valid for a temporary tablespace. AUTO :Specify AUTO if you want the database to manage the free space of segments in the tablespace using a bitmap. MANUAL :Specify MANUAL if you want the database to manage the free space of segments in the tablespace using free lists

  E - Correct https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces002.htm#ADMIN11360 Create a locally managed tablespace by specifying LOCAL in the EXTENT MANAGEMENT clause of the CREATE TABLESPACE statement. This is the default for new permanent tablespaces,

  D - Correct https://docs.oracle.com/cd/B28359_01/server.111/b28310/create005.htm#ADMIN11105 The most commonly used block size should be picked as the standard block size. In many cases, this is the only block size that you need to specify. Typically, DB_BLOCK_SIZE is set to either 4K or 8K. If you do not set a value for this parameter, the default data block size is operating system specific.

• Question 169:

  Which two statements are true about the SET VERIFY ON command? (Choose two.)

  A. It can be used only in SQL*Plus
  B. It displays values for variables used only in the WHERE clause of a query
  C. It can be used in SQL Developer and SQL*Plus
  D. It displays values for variables created by the DEFINE command
  E. It displays values for variables prefixed with andand
  C. It can be used in SQL Developer and SQL*Plus
  E. It displays values for variables prefixed with andand

• Question 170:

  Which two statements are true regarding indexes? (Choose two.)

  A. A non-unique index can be altered to be unique.
  B. An update to a table can result in no updates to any of the table's indexes.
  C. The RECYCLE BIN never contains indexes.
  D. An update to a table can result in updates to any or all of the table's indexes.
  E. A table belonging to one user cannot have an index that belongs to a different user.
  B. An update to a table can result in no updates to any of the table's indexes.
  D. An update to a table can result in updates to any or all of the table's indexes.

  ---

  Explanation/Reference: