Oracle 1Z0-083 Online Practice Questions and Exam Preparation

Oracle 1Z0-083 Online Questions & Answers

• Question 141:

  You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output:

  

  Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file? (Choose two.)

  A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
  B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
  C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.
  D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
  E. Re-createthepasswordfileintheOracleDatabase12cformat. Correct
  B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
  D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

  ---

  Explanation/Reference:

  * orapwd

  / You can create a database password file using the password file creation utility, ORAPWD.

  The syntax of the ORAPWD command is as follows:

  orapwd FILE=filename [ENTRIES=numusers] [FORCE={y|n}] [ASM={y|n}]

  [DBUNIQUENAME=dbname] [FORMAT={12|legacy}] [SYSBACKUP={y|n}] [SYSDG={y|n}]

  [SYSKM={y|n}] [DELETE={y|n}] [INPUT_FILE=input-fname]

  force - whether to overwrite existing file (optional),

  * v$PWFILE_users

  / 12c: V$PWFILE_USERS lists all users in the password file, and indicates whether the user has been granted the SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG, and SYSKM privileges.

  / 10c: sts users who have been granted SYSDBA and SYSOPER privileges as derived from the password file.

  ColumnDatatypeDescription USERNAMEVARCHAR2(30)The name of the user that is contained in the password file SYSDBAVARCHAR2(5)If TRUE, the user can connect with SYSDBA privileges SYSOPERVARCHAR2(5)If TRUE, the user can connect with SYSOPER privileges Incorrect: not E: The format of the v$PWFILE_users file is already in 12c format.

• Question 142:

  Which two are true about various Oracle security and auditing capabilities? (Choose two).

  A. Application-common Transparent Security Data Protection (TSDP) policies can be created only if all the PDBs in the application container are closed.
  B. Application-common TSDP policies are always container specific.
  C. Application-common OLS policies can be created only if all the PDBs in the application container are closed.
  D. Unified auditing can be automatically synchronized to all application PDBs in an application container.
  E. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container when they are updated.
  B. Application-common TSDP policies are always container specific.
  D. Unified auditing can be automatically synchronized to all application PDBs in an application container.

• Question 143:

  Which two are true about backup set compression using RMAN default compression? (Choose two.)

  A. Compressed backups can be written only to media.
  B. Binary compression adds CPU overhead to backup operations.
  C. Unused blocks below the high water mark are backed up.
  D. Compressed backups cannot have a section size defined.
  E. Compression can be done only for locally managed tablespaces.
  B. Binary compression adds CPU overhead to backup operations.
  E. Compression can be done only for locally managed tablespaces.

  ---

  Explanation/Reference:

  Reference: https://knowledge.broadcom.com/external/article/50652/rman-backup-how-does-it-treat-empty-blo.html

• Question 144:

  Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?

  A. Tracking the most recent read time for a table segment in a user tablespace
  B. Tracking the most recent write time for a table segment in a user tablespace
  C. Tracking insert time by row for table rows
  D. tracking the most recent write time for each block in a table segment
  E. Tracking the most recent read time for a table segment in the SYSTEM tablespace
  F. Tracking the most recent write time for a table segment in the SYSAUX tablespace Correct
  A. Tracking the most recent read time for a table segment in a user tablespace
  B. Tracking the most recent write time for a table segment in a user tablespace
  D. tracking the most recent write time for each block in a table segment

• Question 145:

  Your SALES_ROOT application container has two application PDBs.

  The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs.

  Examine this query and its output:

  

  Which two are true? (Choose two.)

  A. The CONTAINERS clause cannot be used in queries on the REVENUE table.
  B. The REVENUE table must be a list-partitioned table.
  C. The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.
  D. The MAPTABLE table is a metadata-linked table.
  E. A container map exists for the REVENUE table, but is not enabled.
  F. The REVENUE table partitions are not pruned across the PDBs automatically.
  C. The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.
  F. The REVENUE table partitions are not pruned across the PDBs automatically.

  ---

  Explanation/Reference:

  C and F are correct.

  Tested in lab with exact same setting like in the output shown.

  A. -> incorrect - The CONTAINERS clause can be used.

  B. -> incorrect - It can be also a range based.

  C. -> CORRECT - https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/administering-application-containers-with-sql-plus.html#GUID-AAF93A02-7C70-4024-8758-E351C213543E

  D. -> incorrect - Regular table

  E. -> incorrect - shown in the output CONTAINER_MAP = YES

  F. -> CORRECT - because CONTAINERS_DEFAULT is not enabled for the revenue table.

• Question 146:

  Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases? (Choose two.)

  A. Space is always reclaimed automatically when the retention period for Flashback logs is lowered.
  B. Space might be reclaimed proactively before space pressure occurs.
  C. Space might be reclaimed automatically when the retention period for Flashback logs is lowered.
  D. Space is only reclaimed when there is space pressure in the Fast Recovery Area. (FRA)
  E. Space is always reclaimed proactively before space pressure occurs.
  A. Space is always reclaimed automatically when the retention period for Flashback logs is lowered.
  E. Space is always reclaimed proactively before space pressure occurs.

  ---

  Explanation/Reference:

  https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-4DE9FA4A-BA27-434A-A68E-0B58D8FD686B

• Question 147:

  Examine these actions:

  1.

  Create a new database for a recovery catalog.

  2.

  Create a tablespace with sufficient space in the catalog database for the recovery catalog.

  3.

  Configure ARCHIVELOG mode for the catalog database.

  4.

  Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog.

  5.

  Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner.

  6.

  Grant the SYSBACKUP privilege to the recovery catalog schema owner.

  Which are the minimum actions that must be performed before executing the CREATE CATALOG command?

  A. 2, 4, 5, 6
  B. 1, 2, 3, 4, 5, 6
  C. 1, 2, 4, 5
  D. 2, 4, 5
  E. 1, 3, 4, 5
  D. 2, 4, 5

  ---

  Explanation/Reference:

  Example 2-70 Creating a Recovery Catalog and Registering a Database

  Assume that you start SQL*Plus and connect to the recovery catalog catdb with administrator privileges. You execute the CREATE USER statement as follows, replacing password with a user-specified password (see Oracle Database Security Guide for information on creating secure passwords). The SQL statement creates a user rco in database catdb and grant the rco user the RECOVERY_CATALOG_OWNER role.

  SQL> CREATE USER rco IDENTIFIED BY password 2 DEFAULT TABLESPACE cattbs 3 QUOTA UNLIMITED ON cattbs; SQL> GRANT recovery_catalog_owner TO rco; SQL> EXIT

  https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/CREATE-CATALOG.html#GUID-9CFE47C7-2273-48C4-8056-6A4042AF3CDC

• Question 148:

  Which three actions are performed by the Oracle Preinstallation RPM, oracle-database-server-xxxx-preinstall, for Oracle Grid Infrastructure, where xxxx is the Oracle version and release? (Choose three.)

  A. performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met
  B. creating the oracle OS user
  C. creating the OSDBA (dba) group
  D. creating thte oraInventory (oinstall) group
  E. creating the grid OS user
  F. configuring the OS for Oracle Automatic Storage Management shared storage access
  B. creating the oracle OS user
  C. creating the OSDBA (dba) group
  D. creating thte oraInventory (oinstall) group

  ---

  Explanation/Reference:

  When installed, the Oracle Preinstallation RPM does the following: Automatically downloads and installs any additional RPM packages needed for installing Oracle Grid Infrastructure and Oracle Database, and resolves any dependencies Creates an oracle user, and creates the oraInventory (oinstall) and OSDBA (dba) groups for that user As needed, sets sysctl.conf settings, system startup parameters, and driver parameters to values based on recommendations from the Oracle Preinstallation RPM program Sets hard and soft resource limits Sets other recommended parameters, depending on your kernel version Sets numa=off in the kernel for Linux x86_64 machines. Reference: https://docs.oracle.com/cd/E11882_01/install.112/e41961/prelinux.htm#CWLIN2932

• Question 149:

  The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.

  A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
  B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
  C. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;
  D. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;
  E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;
  F. BACKUP SPFILE SECTION SIZE 1M;
  G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;
  A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
  B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
  E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;
  G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

• Question 150:

  Examine this configuration:

  1.

  CDB1 and CDB2 are two container databases.

  2.

  PDB1 is a pluggable database in CDB1.

  3.

  PDB1_C1_SRV is a service for PDB1.

  4.

  CDB1_LINK is a database link in CDB2 referring to PDB1.

  5.

  CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database default service.

  You execute these commands successfully:

  $ sqlplus sys/oracle_4U@cdb2 as sysdba

  SQL> CREATE PLUGGABLE DATABASE PDB1

  FROM PDB1@CDB1_LINK SERVICE_NAME_CONVERT=('PDB1_C1_SRV','PDB1_C2_SRV'); Which two are true? (Choose two.)

  A. PDB1 will be created in CDB2 and automatically opened.
  B. PDB1 will be created in CDB2 and left in MOUNT state.
  C. PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.
  D. PDB1_C2_SRV will be created and started automatically.
  E. PDB1_C2_SRV will be created but not started.
  B. PDB1 will be created in CDB2 and left in MOUNT state.
  E. PDB1_C2_SRV will be created but not started.