Oracle 1Z0-083 Quiz 5 Topic 2 Questions 21-25

Question: 1

Which two are true about poorly performing SQL statements and their tuning in Oracle database instances?

(Choose two.)

ASQL statements performing many physical I/Os can always have their performance improved by creating
indexes.

BSQL statements doing only logical reads never require tuning because they do no physical I/O.

CThe solution that best optimizes one SQL statement can degrade the performance of others.

DSQL statements doing joins always do more physical I/O than single table queries.

EPoorly performing SQL statements can be tuned automatically by the Oracle server.

Show Answer

Question: 2

Which two are true about Rapid Home Provisioning of Oracle software? (Choose two.)

AIt can be used for applications and middleware.

BIt can be used only for Oracle Grid Infrastructure, excluding Oracle Restart.

CIt can be used only for Oracle Grid Infrastructure, including Oracle Restart.

DIt can be used for both Oracle Database and Oracle Grid Infrastructure, including Oracle Restart.

EIt can be used for both Oracle Database and Oracle Grid Infrastructure, excluding Oracle Restart.
Reference https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cwadd/rapid-homeprovisioning.
html#GUID-CCEC5960-EDA4-4A3F-9643-0CA308EA49AA

Show Answer

Question: 3

Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?

ASQL statements

Blog writer performance

Cgeneral operating system health

Ddatabase writer performance

Edatabase instance memory management and sizes

Show Answer

Question: 4

Which two are true about the automatic execution of operating system scripts when performing silent mode

installation starting from Oracle Database 19c? (Choose two.)

AThe response file can specify the root or sudo password.

BThe installer will prompt for the root or sudo password.

CSilent install always runs operating scripts automatically.

DThe response file must contain the root or sudo password.

EThe response file can specify the path of the sudo program.

Show Answer

Question: 5

Which two are true about an Oracle gold image-based installation in Oracle 18c and later releases? (Choose

two.)

AIt can be used for both Oracle Database and Oracle Grid Infrastructure installation.

BIt can only install and configure Oracle Database software. The database has to be created separately.

CIt does not require the setup wizard.

DIt uses a single RPM that automatically extracts and installs the Oracle Database software.

EIt can be used to install and upgrade Oracle Database for single-instance and cluster configurations.

Show Answer

Oracle 1Z0-083 Quiz:5 Topic:2 Questions:21-25