1Z0-182無料問題集「Oracle Database 23ai Administration Associate」

質問 1

You must create a tablespace of nonstandard block size in a new file system and plan to use this command: CREATE TABLESPACE ns_tbs DATAFILE '/u02/oracle/data/nstbs_f01.dbf' SIZE 100G BLOCKSIZE 32K; The standard block size is 8K, but other nonstandard block sizes will also be used. Which two are requirements for this command to succeed?

（A）The /u02 file system must have at least 100G space for the datafile.

（B）DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE.

（C）DB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE.

（D）DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA.

（E）The operating system must use a 32K block size.

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

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

質問 2

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

（A）Subsequent instance startup performs media recovery.

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

（C）Data files are closed normally.

（D）A checkpoint is written.

（E）Subsequent instance startup performs instance recovery.

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

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

質問 3

How do you validate that the database was migrated to Unified Auditing?

（A）By querying V$OPTION for parameter Unified Auditing.

（B）By querying the DBA_UNIFIED_AUDIT_OPTION view.

（C）By executing DBMS_AUDIT_MGMT PL/SQL package in Verify mode.

（D）By using the LSINVENTORY Command to query the Oracle Database Software Library.

正解：A 解答を投票する

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

質問 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）Execute DML statements in the HR schema.

（B）Revoke the CREATE SESSION privilege from user HR.

（C）Log in to the database instance.

（D）Revoke the CREATE SESSION privilege from other users.

（E）Execute DDL statements in the HR schema.

（F）Grant the CREATE SESSION privilege with ADMIN OPTION to other users.

正解：C、D、F 解答を投票する

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

質問 5

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

（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 fails because the script must refer to the full path name.

正解：C 解答を投票する

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

質問 6

Which two tasks can be performed in the NOMOUNT state?

（A）Renaming data files.

（B）Re-creating control files.

（C）Enabling online redo log archiving.

（D）Full database recovery.

（E）Creating a database.

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

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

質問 7

Examine this command: SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT; Which two statements are true?

（A）Only queries are allowed on ORDERS while SHRINK is executing.

（B）The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERS segment.

（C）Queries and DML statements are allowed on ORDERS while the SHRINK is executing.

（D）The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERS segment.

（E）Dependent indexes become UNUSABLE.

（F）The high-water mark (HWM) of ORDERS is adjusted.

正解：C、D 解答を投票する

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

質問 8

You start your database instance in NOMOUNT state. Which two actions are performed?

（A）The control files are opened.

（B）SYS can access the database.

（C）Memory is allocated for the SGA.

（D）The consistency of the database is checked.

（E）All required background processes are started.

正解：C、E 解答を投票する

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

質問 9

Which two are true about shrinking a segment online?

（A）To shrink a table it must have a PRIMARY KEY constraint.

（B）To shrink a table it must have row movement enabled.

（C）It must be in a tablespace that uses Automatic Segment Space Management (ASSM).

（D）It is not possible to shrink either indexes or Index Organized Tables (IOTs).

（E）To shrink a table it must have a UNIQUE KEY constraint.

正解：B、C 解答を投票する

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

質問 10

Which two Oracle database space management features require the use of locally managed tablespaces?

（A）Automatic data file extension (AUTOEXTEND).

（B）Online segment shrink.

（C）Server-generated tablespace space alerts.

（D）Free space management with bitmaps.

（E）Oracle Managed Files (OMF).

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

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

1Z0-182 無料問題集「Oracle Database 23ai Administration Associate」

弊社を連絡する

関連リンク

トップ試験