최신 1Z0-182 무료덤프 - Oracle Database 23ai Administration Associate

문제1

Your data center uses Oracle Managed Files (OMF) for all databases. All tablespaces are smallfile tablespaces. SALES_Q1 is a permanent user-defined tablespace in the SALES database. The following command is about to be issued by a DBA logged in to the SALES database: ALTER TABLESPACE sales_q1 ADD DATAFILE; Which two actions independently ensure that the command executes successfully?

A. Specify a path in the DATAFILE clause of the command specifying a location with at least 100 MB of available space.

B. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 MB of available space.

C. Add the AUTOEXTEND ON clause with NEXT set to 100M.

D. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space.

E. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space.

정답: B,D

설명: (DumpTOP 회원만 볼 수 있음)

문제2

Script abc.sql must be executed to perform a certain task. User HR with password HR exists in the target database and the account is unlocked. The TNSNAMES.ORA file is up to date. Examine this command attempted by the user: $ sqlplus hr/hr@orcl @abc. What will happen and why?

A. The command succeeds and HR will be connected to the orcl database instance, and the abc script will be executed.

B. The command fails and reports an error because @ is used twice.

C. The command succeeds and HR will be connected to the orcl database instance, and the abc script will be executed.

D. The command fails because the script must refer to the full path name.

E. The command succeeds and HR will be connected to the orcl database and after logging out to the abc database.

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제3

Which two statements are true about advanced connection options supported by Oracle Net for connection to Oracle?

A. Load Balancing requires the use of a name server.

B. Connect Time Failover requires the connect string to have two or more listener addresses configured.

C. Connect Time Failover requires the use of Transparent Application Failover (TAF).

D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration.

E. Source Routing requires the use of encrypted connections.

정답: B,D

설명: (DumpTOP 회원만 볼 수 있음)

문제4

Your database instance is started with an SPFILE. A PFILE is also available. You execute this command: ALTER SYSTEM SET DB_CACHE_SIZE=100K; Where does the value change?

A. In the SPFILE and memory

B. In the SPFILE, PFILE, and memory

C. Only in memory

D. Only in the SPFILE

E. In the SPFILE and PFILE

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제5

Which two statements are true about the tools used to configure Oracle Net Services?

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

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

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

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

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

정답: A,B

설명: (DumpTOP 회원만 볼 수 있음)

문제6

Which statement is true about database links?

A. A database link created in a database allows a connection from that database's instance to the target database's instance for selecting schema data.

B. A database link can be created only between two Oracle databases.

C. A public database link can be created only by SYS.

D. Private database link creation requires the same user to exist in both the local and the remote databases.

E. A public database link can be used by any user allowing remote database instance connection for selecting schema data.

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제7

Which three are benefits of using temp UNDO when performing DML on global temporary tables?

A. It reduces I/Os to the SYSTEM tablespace.

B. It reduces the amount of redo generated.

C. It reduces I/Os to the SYSAUX tablespace.

D. It reduces the amount of UNDO stored in the UNDO tablespace.

E. It permits DML on global temporary tables even if the database is opened read-only.

정답: A,B,D

설명: (DumpTOP 회원만 볼 수 있음)

문제8

Which statement is true about the PDB_DBA role granted to a local user during the creation of a new PDB?

A. The role has the privileges to create and manage users within the PDB.

B. The role has the privileges to perform DDL operations on all local schema objects.

C. No privileges are provided with the PDB_DBA role.

D. The role has the privileges to administer the PDB.

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제9

Which two statements are true about the UNLIMITED TABLESPACE system privilege and space quota?

A. By default, users have no quota on 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. It is overridden by a space quota specified for the user.

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

정답: C,D

설명: (DumpTOP 회원만 볼 수 있음)

문제10

Which two statements are true about database instances and Real Application Clusters (RAC)?

A. Two RAC databases can share their instances.

B. A RAC database must have three or more instances.

C. A RAC database can have one instance.

D. A RAC database can have instances on separate servers.

E. A RAC database must have two or more instances.

정답: C,D

설명: (DumpTOP 회원만 볼 수 있음)

최신 1Z0-182 무료덤프 - Oracle Database 23ai Administration Associate

우리와 연락하기

유용한 링크

최신 업데이트