최신Oracle Database 23ai Administration Associate - 1Z1-182무료샘플문제

A. It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR.

B. It drops and re-creates tables that exist in both ORCL:SH and TESTDB:HR.

C. It skips only tables that exist in ORCL:SH and ORCL:OE.

D. It skips all indexes of ORCL:SH and in both ORCL:SH and TESTDB:HR.

E. It skips only indexes that exist in both ORCL:SH and TESTDB:HR.

A. Control files are read.

B. Online redo logs are opened.

C. The initialization parameter file is read.

D. The alert log has instance startup details written to it.

E. Online data files are opened.

F. Oracle shared memory structures are allocated.

A. ALTER SYSTEM CHECKPOINT

B. ALTER SYSTEM FLUSH BUFFER_CACHE

C. ALTER SYSTEM SWITCH LOGFILE

D. ALTER SYSTEM ENABLE / DISABLE RESTRICTED SESSION

A. New connection requests made to the database instance are refused.

B. Sessions remain connected even if they are not running a transaction.

C. Instance recovery occurs automatically during the shutdown.

D. Uncommitted transactions are allowed to continue to the next ROLLBACK.

E. Uncommitted transactions are allowed to continue to the next COMMIT.

A. Password File authentication must be used for system-privileged administrative users.

B. REMOTE_LOGIN_PASSWORDFILE must be set to EXCLUSIVE to permit password changes for system-privileged administrative users.

C. Operating System authentication may be used for system-privileged administrative users.

D. Password File authentication is supported for any type of database user.

E. Password authentication must be used for system-privileged administrative users.

A. It allows a user to have unlimited space only in their default permanent tablespace.

B. It allows a role to have unlimited space in any tablespace in the database.

C. It allows a user to have unlimited space in any tablespace in the database.

D. By default, users have no quota on their default permanent tablespace.

E. It is overridden by a space quota specified for the user.

A. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.

B. The lsnrctl utility requires a listener.ora file to exist before it is started.

C. The Oracle Net Configuration Assistant is only used when running the Oracle installer.

D. Oracle Net Manager can be used to centrally configure listeners on any database server target.

E. Oracle Net Manager can be used to locally configure naming methods on a database server.

A. One instance on one server mounting and opening one database.

B. One instance on one server mounting and opening multiple databases.

C. Two or more instances on separate servers all mounting and opening the same database.

D. One instance on one server mounting multiple databases.

E. One instance on one server that has no database mounted.

A. Automatic population of performance views (V$ views) from statistical data stored in AWR repository and using Automatic Database Diagnostic.

B. Automatic Application Tracing used to collect High-Load SQL statements and statistics.

C. Automatic Diagnostic Collector used to capture and store database errors and hung analysis.

D. Automatic Application Tracing used to collect High-Load SQL statements and statistics.

E. Automatic capture of statistical information from the SGA and storing it in the AWR using Automatic Database Diagnostic.

F. ADDM, a server-based expert that reviews database performance statistics captured by Snapshots to identify potential problems before system performance degrades noticeably.

A. Analysis of privileges granted directly to a role that are then used by a user who has been granted that role.

B. Analysis of privileges that a user has on their own schema objects.

C. Analysis of all privileges used by the SYS user.

D. Analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role.

E. Analysis of privileges that a user has on other schemas' objects.