1Z0-182問題集、Oracle実際の試験問題

質問 1

Which of the following is true about the status of a PDB that has been unplugged from a CDB?

A. The STATUS column in CDB_PDBS of the unplugged PDB will be REMOVED.

B. The STATUS column in CDB_PDBS of the unplugged PDB will be DISABLED.

C. The STATUS column in CDB_PDBS of the unplugged PDB will be UNAVAILABLE.

D. The STATUS column in CDB_PDBS of the unplugged PDB will be UNPLUGGED.

正解: D

解説: (PassTest メンバーにのみ表示されます)

質問 2

You have connected to the CDB root as a common user with the CREATE PLUGGABLE DATABASE system privilege and issued the following command: SQL> CREATE PLUGGABLE DATABASE pdb1 ADMIN USER admin1 IDENTIFIED BY p1 ROLES = (CONNECT) FILE_NAME_CONVERT = ('PDB$SEEDdir', 'PDB1dir'); Which three are results of the CREATE command?

A. The PDB must be opened Read Only to complete the integration of the PDB into the CDB.

B. It creates a new local user ADMIN with restricted privileges.

C. After the PDB is created, it is automatically opened Read/Write.

D. It creates new default schemas for the PDB.

E. It creates tablespaces to store metadata.

F. It creates a new local user ADMIN with SYSDBA privileges.

正解: B,D,E

解説: (PassTest メンバーにのみ表示されます)

質問 3

Which resource plan is used to manage the resources for the predefined maintenance window?

A. The resources used by the predefined maintenance window can only be adjusted if you create a new resource plan in Resource Manager ...

B. The SYS_GROUP consumer resource group policies define the resources assigned ...

C. The predefined maintenance window starts automatically with 20% of the system resources ...

D. By default, all predefined maintenance windows use the DEFAULT_MAINTENANCE_PLANresource plan, and automated maintenance tasks run under subplan called ORA$AUTOTASK.

正解: D

解説: (PassTest メンバーにのみ表示されます)

質問 4

In one of your databases, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO hr WITH ADMIN OPTION; Which three actions can HR perform?

A. Grant the CREATE SESSION privilege with ADMIN OPTION to other users.

B. Log in to the database instance.

C. Execute DDL statements in the HR schema.

D. Revoke the CREATE SESSION privilege from other users.

E. Revoke the CREATE SESSION privilege from user HR.

F. Execute DML statements in the HR schema.

正解: A,B,D

解説: (PassTest メンバーにのみ表示されます)

質問 5

Which statement is true about database links?

A. A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.

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

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

D. A database link created in a database allows a connection from that database's instance to the target database's instance, but not vice versa.

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

正解: D

解説: (PassTest メンバーにのみ表示されます)

質問 6

In which two ways would you disable timing information collected for wait events and much of the performance monitoring capability of the database?

A. By executing the PL/SQL procedure DBMS_TIME_STATISTIC.DISABLE(TRUE).

B. By setting the STATISTICS_LEVEL parameter to BASIC.

C. By executing the PL/SQL procedure DBMS_TIME_STATISTIC.LEVEL(BASIC).

D. By setting the TIMED_STATISTICS system parameter to FALSE.

E. By setting the TIMED_STATISTICS_LEVEL system parameter to FALSE.

正解: B,D

解説: (PassTest メンバーにのみ表示されます)

質問 7

You want to apply the principle of least privilege in all your live databases. One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis. Which two types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?

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

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

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

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

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

正解: B,C

解説: (PassTest メンバーにのみ表示されます)

質問 8

Examine this command: ALTER DATABASE MOVE DATAFILE '\u01/sales1.dbf' TO '\u01/sales01.dbf' REUSE; Which two statements are true?

A. The file is renamed and stored in the same location.

B. DML may be performed on tables with one or more extents in this data file during the execution of this command.

C. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.

D. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.

E. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.

正解: A,B

解説: (PassTest メンバーにのみ表示されます)

質問 9

You execute the SHUTDOWN ABORT command. Which two statements are true?

A. Subsequent instance startup performs instance recovery.

B. Data files are closed normally.

C. Uncommitted transactions are not rolled back by the shutdown.

D. A checkpoint is written.

E. Subsequent instance startup performs media recovery.

正解: A,C

解説: (PassTest メンバーにのみ表示されます)

質問 10

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 and after logging out to the abc database.

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

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 and reports an error because @ is used twice.

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

正解: E

解説: (PassTest メンバーにのみ表示されます)

Oracle Database 23ai Administration Associate - 1Z0-182 模擬練習