1Z1-182試験無料問題集（96題）「Oracle Database 23ai Administration Associate 認定」

出題：1

You unplugged a PDB to plug it into another CDB with the following command: SQL> ALTER PLUGGABLE DATABASE pdb1 UNPLUG INTO '/tmp/pdb1.pdb'; Which statement is true prior to plugging the PDB into the other CDB?

A. The PDB archive file must be copied to the target CDB.

B. PDB archive file and only the user-defined tablespaces must be copied to the target CDB.

C. The PDB manifest and all the datafiles must be copied to the target CDB.

D. The PDB manifest, the data files, and the PDB archive file must be copied to the target CDB.

正解：D 解答を投票する

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

出題：2

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

A. Data files are closed normally.

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

C. A checkpoint is written.

D. Subsequent instance startup performs instance recovery.

E. Subsequent instance startup performs media recovery.

正解：B,D 解答を投票する

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

出題：3

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 succeeds and HR will be connected to the orcl database instance, and the abc script will be executed.

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

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 解答を投票する

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

出題：4

Which two statements describe how Optimizer Statistics are collected?

A. Optimizer Statistics can be manually collected at multiple levels using DBMS_STATS.GATHER_*_STATS PL/SQL procedures.

B. Optimizer Statistics are collected in real-time as data is inserted, deleted, or updated.

C. Optimizer Statistics are collected by the Statistics Advisor.

D. Optimizer Statistics are collected automatically by an automatic maintenance job that runsduring predefined maintenance windows.

E. Optimizer Statistics are collected automatically by Automatic Workload Repository (AWR) Snapshot.

正解：A,D 解答を投票する

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

出題：5

What are Optimizer Statistics?

A. Optimizer Statistics are table, column, index, and system statistics used for generating efficient SQL execution plans.

B. Optimizer Statistics are statistics about data distribution within Oracle Datafiles.

C. Optimizer Statistics are a set of data distribution statistics collected in real time as data is inserted, deleted, or updated, which are stored in AWR and used for generating SQL execution plans.

D. Optimizer Statistics are part of system performance statistics stored in AWR required for calculating SQL execution plans.

正解：A 解答を投票する

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

出題：6

Which three statements are true about dynamic performance views?

A. They are owned by the SYSTEM user.

B. Read consistency is not guaranteed.

C. Data displayed by querying dynamic performance views is derived from metadata in the data dictionary.

D. They can be queried only when the database is open.

E. V$FIXED_TABLE can be queried to display the names of all dynamic performance views.

正解：B,C,E 解答を投票する

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

出題：7

You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE '/u01/app/oracle/sales01.dbf' SIZE 5G SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES tablespace?

A. Any data files added to the tablespace must have a size of 5 gigabytes.

B. It uses the database default block size.

C. Free space is managed using freelists.

D. It must be smaller than the smallest BIGFILE tablespace.

E. It is a locally managed tablespace.

正解：B,E 解答を投票する

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

出題：8

Which two tasks can you perform using DBCA for databases?

A. Register a new database with an available Enterprise Manager Management server.

B. Enable flashback database for an existing database.

C. Configure incremental backups for a new database.

D. Change the standard block size of an existing database.

E. Configure a nonstandard block size for a new database.

正解：A,E 解答を投票する

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

出題：9

As the DBA, you execute this command: GRANT CREATE VIEW TO usr1 WITH ADMIN OPTION; USR1 then executes: GRANT CREATE VIEW TO usr2 WITH ADMIN OPTION; USR2 then executes: GRANT CREATE VIEW TO usr3; Which statement is true?

A. When the DBA revokes the CREATE VIEW privilege from USR1, it is revoked from USR2 but not USR3.

B. The DBA can revoke only ADMIN OPTION from USR1.

C. USR1 can revoke the CREATE VIEW privilege from USR3.

D. When the DBA revokes the CREATE VIEW privilege from USR1, it is neither revoked from USR2 nor USR3.

E. When the DBA revokes the CREATE VIEW privilege from USR2, it is revoked from USR3.

正解：D,E 解答を投票する

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

出題：10

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. Only in memory

B. In the SPFILE and memory

C. In the SPFILE, PFILE, and memory

D. Only in the SPFILE

E. In the SPFILE and PFILE

正解：B 解答を投票する

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

1Z1-182試験無料問題集「Oracle Database 23ai Administration Associate 認定」