📘 Free 1Z0-083 Sample Questions
Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)
A
A. All metrics are instance related.
B
B. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
C
C. A space usage management alert is automatically cleared after the underlying problem is resolved.
D
D. They are generated by SMON when a tablespace is 97% ful
E
E. Metrics are statistical counts for a specific unit.
Correct Answer:
B. B. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager
(RMAN) incremental level 0 backup is a bottleneck.
FORCE LOGGING is enabled for the database.
Which two could improve read performance? (Choose two.)
A
A. Increase the size of tape I/O buffers.
B
B. Disable FORCE LOGGING for the database.
C
C. Increase the size of the database buffer cache.
D
D. Enable asynchronous disk I/O.
E
E. Increase the level of RMAN multiplexing.
Correct Answer:
D. D. Enable asynchronous disk I/O.
For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE
database command?
A
A. to specify a default tablespace in a PDB cloned from another PDB in the same CDB.
B
B. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB
C
C. to include specific user tablespaces only when relocating a PDB
D
D. to specify the list of user tablespaces to include when moving a non-CDB to a PDB
Correct Answer:
B. B. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB
Which three are true about requirements for various FLASHBACK operations? (Choose three.)
A
A. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two
points in time.
B
B. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.
C
C. FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
D
D. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked
E
E. FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time
F
F. FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in
time
Correct Answer:
A. A. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two
points in time.
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
A.performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met
B
B.creating the oracle OS user
C
C. creating the OSDBA (dba) group
D
D. creating the oralnventory (oinstall) group
E
E. creating the grid OS user
F
F. configuring the OS for Oracle Automatic Storage Management shared storage access
Correct Answer:
B. B.creating the oracle OS user
Explanation:
BCD When installed, the Oracle Database 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 oralnventory (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 Database 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.
Which two are true about common objects? (Choose two.)
A
A. They can be created only in CDB$ROOT.
B
B. They can be only metadata-linked in an application container
C
C. They can exist in user-defined schemas only in application containers.
D
D. They can exist in CDB$ROOT and an application root
E
E. They can be extended data-linked in CDB$ROOT
F
F. They can be created only in an application root
Correct Answer:
D. D. They can exist in CDB$ROOT and an application root
Which two are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)
A
A. It analyzes a period of time corresponding to the 12 hours of activity.
B
B. It runs automatically after each AWR snapshot.
C
C. A DBA can run it manually.
D
D.Results are written to the alert log.
Correct Answer:
B. B. It runs automatically after each AWR snapshot.
Which two are true about server-generated alerts? (Choose two.)
A
A.Stateful alerts must be created by a DBA after resolving the problem.
B
B.Stateless alerts can be purged manually from the alert history.
C
C.Stateless alerts can be cleared manually
D
D.Stateless alerts are automatically cleared.
Correct Answer:
B. B.Stateless alerts can be purged manually from the alert history.
Which three are located by using environment variables? (Choose three.)
A
A. the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.
B
B. the location of Oracle Net Services configuration files
C
C. the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at
startup
D
D. default directories for temporary files used by temporary tablespaces
E
E. the temporary disk space used by Oracle Installer during installation
Correct Answer:
A. A. the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.
Which three are true about opatchauto? (Choose three.)
A
A. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and OracleDatabase home during the patching process.
B
B. It must be invoked by a user with root user privileges.
C
C. Patches are applied via opatchauto.
D
D. Users must always input patch plans to opatchauto.
E
E. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being
invoked.
F
F. It applies patches in nonrolling mode by default.
Correct Answer:
A. A. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and OracleDatabase home during the patching process.
Questions: 1-10 out of 181
Continue Full Practice..
GET ALL 181 QUESTIONS