Oracle 1Z0-055 問題集

質問 1：
You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tape drives of only 10 GB each. Which method would accomplish the task quickly and efficiently?
A. parallel image copy backup
B. intrafile parallel backup
C. backup with MAXPIECESIZE configured for the channel
D. parallel backup with MAXPIECESIZE configured for the channel
正解：B

質問 2：
Evaluate the following block of code:
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (
acl => 'mycompany-com-permissions.xml',
principal => 'ACCT_MGR',
is_grant => TRUE,
privilege => 'connect');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
acl => 'mycompany-com-permissions.xml',
host => '*.mycompany.com');
END;
What is the outcome of the above code?
A. It produces an error because the range of ports associated with the hosts has not been specified.
B. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
C. It produces an error because a fully qualified host name needs to be specified.
D. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.
正解：D

質問 3：
Which three actions are required to configure the Flashback Database? (Choose three.)
A. set Flash Recovery Area
B. start the database in the NOARCHIVELOG mode
C. create FLASHBACK tablespace
D. start the database in the ARCHIVELOG mode
E. enable Flashback logging
正解：A,D,E

質問 4：
Which statement about the enabling of table compression in Oracle Database 11g is true?
A. Compression can be enabled at the table, tablespace, or partition level for conventional DML only.
B. Compression can be enabled only at the table level for both direct loads and conventional DML.
C. Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.
D. Compression can be enabled at the table, tablespace, or partition level for direct loads only.
正解：C

質問 5：
Examine the following command:
ALTER DISKGROUP data MOUNT FORCE; In which scenario can you use the above command to mount the disk group?
A. when one or more ASM files are dropped
B. when ASM disk goes offline
C. when some disks in a failure group for a disk group are rebalancing
D. when some disks in a disk group are offline
正解：D

質問 6：
Which statement is true regarding virtual private catalogs?
A. A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.
B. The virtual private catalog owner cannot create and modify the stored scripts.
C. To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.
D. The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
正解：C

質問 7：
During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?
A. The installation proceeds with the default value but a message would be generated in the alert log file.
B. The installation proceeds with the default value but it would not be an OFA-compliant database.
C. The installation proceeds with the default value without warnings and errors.
D. The installation terminates with an error.
正解：A