1Z1-052無料問題集「Oracle Database 11g: Administration I」

質問 1

You want to move all objects of the APPS user in the test database to the DB_USR schema of the production database. Which option of IMPDP would you use to accomplish this task?

（A）FULL

（B）REMAP_TABLESPACE

（C）REMAP_SCHEMA

（D）TRANSFORM

（E）SCHEMAS

正解：C 解答を投票する

質問 2

Which three descriptions are correct about the effects of the TRUNCATE command on a table? (Choose three.)

（A）The highwater mark (HWM) is set to point to the first usable data block in the table segment.

（B）The corresponding indexes for the table are also truncated.

（C）No undo or very little undo data is generated during the execution of the TRUNCATE command.

（D）The child table is truncated when the TRUNCATE command is applied on the parent table.

（E）Delete triggers on the table are fired during the execution of the TRUNCATE command.

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

質問 3

The instance abnormally terminates because of a power outage.
Which statement is true about redo log files during instance recovery?

（A）Inactive and current redo log files are required to accomplish recovery

（B）All redo log entries after the last checkpoint are applied from redo log files to data files

（C）Online and archived redo files are required to accomplish instance recovery

（D）All redo log entries recorded in the current log file until the checkpoint position are applied to data files

正解：B 解答を投票する

質問 4

The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity check. Given below are the steps to recover from the error in random order:
1 . Shut down the instance, if not already done.
2 . Copy one of the remaining control files to a new location.
3 . Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.
4. Start up the database instance to the NOMOUNT stage.
5. Recover the database to the point of failure of the control file.
6. Open the database.
Identify the correct sequence of steps?
Exhibit:

（A）5, 2, 3, 4; 1 and 6 not required

（B）4, 5, 6, 2, 3; 1 not required

（C）2, 4, 3, 5, 6; 1 not required

（D）1, 2, 4, 3, 5, 6

正解：D 解答を投票する

質問 5

Which two are true about AWR snapshots? (Choose two.)

（A）They can be modified by using DMLs.

（B）They can be retained forever.

（C）They are always created automatically.

（D）They are stored in the SYSAUX tablespace.

（E）They are not generated if STATISTICS_LEVEL is set to TYPICAL.

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

質問 6

Examine the following steps performed on a database instance:
1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION
2 . The SKD user creates a table
3 . The SKD user grants the CREATE TABLE system privilege to the HR user
4 . The HR user creates a table
5 . The DBA revokes the CREATE TABLE system privilege from SKD
Which statement is true after step 5 is performed?

（A）The table created by SKD is not accessible and SKD cannot create new tables

（B）The table created by HR remains and HR still has the CREATE TABLE system privilege

（C）The tables created by SKD and HR remain, but both cannot create new tables

（D）The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users

正解：B 解答を投票する

質問 7

You have two tables with referential integrity enforced between them. You need to insert data to the child table first because it is going to be a long transaction and data for the parent table will be available in a later stage, which can be inserted as part of the same transaction.
View the Exhibit to examine the commands used to create tables.
Which action would you take to delay the referential integrity checking until the end of the transaction?
Exhibit:

（A）Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction

（B）Enable the resumable mode for the session before starting the transaction

（C）Alter the constraint to NOVALIDATE state before starting the transaction

（D）Set the constraint to deferred before starting the transaction

正解：D 解答を投票する

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

質問 8

View the Exhibit to examine the error that occurred during the database startup.

You opened an RMAN session for the database. To repair the failure, you executed the following command as the first RMAN command:
RMAN> REPAIR FAILURE;
Which statement describes the consequence of this command?

（A）The command only displays the advice and the RMAN script required for recovery

（B）The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command

（C）The command executes the RMAN script to repair the failure and remove the entry from the Automatic Diagnostic Repository (ADR)

（D）The command performs the recovery and closes the failure

正解：B 解答を投票する

質問 9

Which two are true about undo tablespaces? (Choose two.)

（A）Single instance databases can have only one active undo tablespace

（B）They can be recovered only when an instance is in MOUNT state

（C）Tables can be created in undo tablespaces by SYS

（D）They must have only one data file

（E）They always retain undo for the time period defined by UNDO_RETENTION

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

質問 10

View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table:
SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code='C005';
Before user A issues a COMMIT or ROLLBACK command, user B executes the following command on the TRANS table:
SQL> ALTER TABLE trans MODIFY (tr_type VARCHAR2(3));
What would happen in this scenario?
Exhibit:

（A）The DDL operation gets higher priority and transaction for user A is rolled back

（B）The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy

（C）The ALETER TABLE command waits indefinitely until user A ends the transaction

（D）The ALTER TABLE command modifies the column successfully

正解：B 解答を投票する

質問 11

You created a profile APP_USER and assigned it to the users. After a month, you decide to drop the profile.
Some user sessions are currently connected to the database instance and are using the APP_USER profile.
This command is used to drop the profile:
SQL> DROP PROFILE app_user;
Which statement describes the result?

（A）The command produces an error.

（B）The profile is dropped, the sessions are terminated, and the subsequent user sessions use the DEFAULT profile.

（C）The profile is dropped and current user sessions use the DEFAULT profile immediately.

正解：A 解答を投票する

質問 12

Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two)

（A）A data block can spread across multiple data files as it can consist of multiple operating system (OS) blocks.

（B）A data file can belong to only one tablespace.

（C）An extent cannot spread across data files.

（D）A data file can have only one segment created in it.

（E）A segment cannot spread across data files.

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

質問 13

Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)

（A）The database is not opening because the required database files are missing

（B）The user has dropped an important table that needs to be recovered

（C）The database files are corrupted when the database is open

（D）The archived redo log files are missing for which the backup is not available

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

質問 14

Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)

（A）All AWR tables belong to the SYSTEM schema

（B）The snapshots collected by the AWR are accessible through data dictionary views

（C）The snapshots collected by the AWR are used by self-tuning components in the database

（D）The AWR contains systemwide tracing and logging information

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

質問 15

The instance abnormally terminates because of a power outage.
Which statement is true about redo log files during instance recovery?

（A）Inactive and current redo log files are required to accomplish recovery

（B）All redo log entries after the last checkpoint are applied from redo log files to data files

（C）Online and archived redo files are required to accomplish instance recovery

（D）All redo log entries recorded in the current log file until the checkpoint position are applied to data files

正解：B 解答を投票する

1Z1-052 無料問題集「Oracle Database 11g: Administration I」

弊社を連絡する

関連リンク

トップ試験