Oracle 1Z0-052 問題集

質問 1：
You are working on a database that must be functioning 24 hours a day, 7 days a week.
The database is configured in ARCHIVELOG mode.
Which two options do you have for performing user-managed backups? (Choose two.)
A. You can perform consistent backups only.
B. You can perform a complete database backup without shutting down the database instance.
C. You can back up data files only when all data files have the same SCN recorded in the control file.
D. You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGIN BACKUP or ALTER DATABASE BEGIN BACKUP commands.
正解：B,D

質問 2：
SQL> CREATE BIGFILE TABLESPACE MRKT
2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING
3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;
Database altered.
Which two statements are true regarding the MRKT tablespace? (Choose two.)
A. The tablespace can be dropped with the current setting with segments present in it.
B. Segment space is managed by free lists in the tablespace.
C. No more data files can be added to the tablespace.
D. A user created without being assigned a default tablespace uses this tablespace.
正解：C,D

質問 3：
You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer (OUI) prompts you to enter the path of the inventory directory and also prompts you to specify an operating system group name.
Which statement is true in this case?
A. The ORACLE_BASE parameter is not set.
B. The operating system group that will be specified should have root user as its member.
C. The installation is being performed without the "Create Starter Database" option selected.
D. The operating system group that will be specified must have permission to write to the inventory directory.
E. The installation is being performed by the root user.
正解：D

質問 4：
A database instance was terminated due to a lost data file and has not been restarted.
You wish to restore database availability by using the Data Recovery Advisor.
Examine this list of RMAN commands:

What are the minimum required commands and in what order must they be executed to achieve this?
A. 1, 2, 3, and 4
B. 1, 3, 4, and 5
C. 1 and 4
D. 1, 3, and 4
E. 1, 2, 3, 4, and 5
正解：D

質問 5：
Which two can be exported by a non-administrative account by using Data Pump? (Choose two.)
A. tables
B. schemas
C. database
D. tablespaces
E. directory objects
正解：A,B
解説: (Topexam メンバーにのみ表示されます)