1Z1-083 무료 덤프문제 온라인 액세스

Which three are true about performing an Oracle Database install on Linux? (Choose three.)

• A.The Oracle database administrator must be granted access to the root operating system account to tun root privileged scripts.
• B.The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.
• C.It can be done before installing Grid Infrastructure for a Standalone Server.
• D.The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.
• E.It allows you to select the languages supported by the Oracle database server.
• F.The runfixup.sh script can install missing RPMs.
• G.It can be done after installing Grid Infrastructure for a Standalone Server.

Which three are true about the SQL Tuning Advisor? (Choose three.)

• A.It builds SQL profiles for each poorly performing SQL statement to prevent regressions.
• B.It checks each query being analyzed for missing statistics.
• C.It only recommends syntactic changes to SQL statements.
• D.It considers all SQL statements being analyzed by the advisor task as a group.
• E.It checks each query being analyzed for stale statistics.
• F.It can recommend semantic changes to SQL statements.

Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases? (Choose three.)

• A.A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.
• B.A PDB snapshot depends on an existing storage snapshot of the source PDB.
• C.A PDB snapshot can be a sparse copy of a source PDB.
• D.A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.
• E.A PDB snapshot can be a full copy of a source PDB.
• F.A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.
• G.A snapshot copy PDB can be a full copy of a source PDB.

Which three are performed by Oracle Automatic Storage Management (ASM) instances?
(Choose three.)

• A.managing Allocation Units (AUs) for disk group content
• B.managing space allocation for Oracle ASM files
• C.acting as an I/O server to read data file blocks from ASM disks on behalf of database server processes
• D.managing extent allocation for Oracle database segments
• E.acting as an I/O server to write data file blocks to ASM disks on behalf of Database Writer processes (DBWn)
• F.mounting disk groups

Which two restrictions apply when the RMAN BACKUP AS COPY command is used to create a backup?

• A.Backups can be taken only for data files.
• B.Binary compression cannot be applied to the backup.
• C.Backups can be written only if checksums are stored for each block.
• D.Backups can be taken only if a fast recovery area is configured.
• E.Backups can be written only to disk.
• F.Backups can be written only to media.