최신Oracle Database 12c: Installation and Administration - 1z1-062무료샘플문제

A. The preupgrade_fixups.sql script is created to list and describe issues in the source database.

B. A log file, preupgrade.log, is created that contains the output of the Pre-Upgrade Information tool.

C. It generates a script to recompile invalid objects post-upgrade.

D. It checks for required tablespaces and if they are not available, creates them automatically.

E. The postupgrade_fixups.sql script is created to address issues that can be fixed after a database has been upgraded.

F. The preupgrade_fixups.sql script is executed automatically to fix issues in the source database.

A. Oracle Net Configuration Assistant

B. Oracle Enterprise Manager Cloud Control

C. Listener Control Utility (LSNRCTL)

D. Oracle Net Manager

E. Oracle Enterprise Manager Database Express

A. The values assigned to the resource limits and password parameters in the default profile can be altered.

B. it must be explicitly assigned to the user.

C. It can be dropped and recreated.

D. A different DEFAULT profile can be created before each user in a database.

A. The ADDM analysis provides only diagnostics information but does not provide recommendations

B. The ADDM calls other advisors if required, but does not provide recommendations about the advisors

C. The ADDM runs after each AWR snapshot is collected automatically by MMON

D. The ADDM requires at least four AWR snapshots for analysis

E. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)

A. A committed delete to the SALES table was made more than 12 minutes before the query began

B. An update to the SALES table was committed after the query began

C. An update was made to the SALES table after the query began

D. A committed update to the SALES table was made more than 12 minutes before the query began

E. An uncommitted delete to the SALES table was made more than 12 minutes before the query began

F. An uncommitted update to the SALES table was made more than 12 minutes before the query began

G. An update was made to the SALES table before the query began

A. A database destination must exist or be created for the remote database

B. A database destination group must exist or be created for a job to run on multiple remote databases

C. A destination is optional for a remote database job because DB links can be used instead

D. A credential must be created to define the remote user

E. A credential is optional for a remote database job

F. Remote database jobs always run as the same user who submits the job on the local database

G. It must run as a user that is defined on the remote database

A. It fails because no SQL *Loader control file location is specified.

B. It fails because no SQL *Loader data file location is specified.

C. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

D. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

A. In each user session, the limit for LOGICAL_READS_PER_SESSION in the same as defined in the DEFAULT profile.

B. These users can never reuse a password

C. The CPU_PER_CALL is ignored in the user sessions because of the unlimited value of CPU_PER_CALL

D. The PASSWORD_LIFE_TIME value is ignored because of the unlimited value of PASSWORD_REUSE_MAX.

A. You can detach from a data pump export job and reattach later.

B. You can detach from a data pump import job and reattach later.

C. The master table is the last object to be exported by the data pump.

D. Data pump import requires the import file to be in a directory owned by the oracle owner.

E. Data pump uses parallel execution server processes to implement parallel import.

A. performing database services registration with the default listener

B. applying online redo during instance recovery

C. cleaning up temporary segments that are no longer needed

D. restarting a server or a dispatcher process that terminated abnormally

E. cleaning up the database buffer cache and freeing resources that a client process was using

F. recovering failed transactions that were skipped during instance recovery because of file-read or tablespace offline errors

A. SQL Access Advisor

B. Memory Advisor for the PGA

C. SQL Tuning Advisor

D. Memory Advisor for the shared pool

A. A resource plan can have multiple resource plan directives, each of which controls resource allocation for a different consumer group.

B. It can be used to control the usage of the undo tablespace by consumer groups.

C. It can be used to enable resumable timeout for user sessions.

D. A resource plan change can be automated by using the Oracle Scheduler.

E. It can be used to control the consumption of only physical I/Os where excessive physical I/Os can trigger an automatic session termination but excessive logical I/Os cannot.

F. It can be used to control the usage of the temp tablespace by consumer groups.

A. The DBMS_DATAPUMP PL/SQL package can be used independently of Data Pump clients to perform export and import operations.

B. IMPDP can be used to change target data file names, schemas, and tablespaces during import.

C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

D. IMPDP always use the conventional path insert method to import data.

E. EXPDP and IMPDP are the client components of Oracle Data Pump.

A. 1 and 3

B. 2, 5, and 6

C. 1, 2, and 3

D. 2, 3, 4, and 5