1Z0-055 | A Review Of Accurate 1Z0-055 dumps
Q61. What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? (Choose all that apply.)
A. ORACLE_BASE should be set explicitly.
B. An Oracle base should have only one Oracle home created in it.
C. Flash recovery area and data file location should be on separate disks.
D. Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.
Answer: A,C,D
Q62. View the Exhibit to examine the error obtained during the I/O calibration process.
There are no data files on raw devices. What is the reason for this error?
A. The DISK_ASYNCH_IO parameter is set to TRUE.
B. The FILESYSTEMIO_OPTIONS parameter is set to NONE.
C. Another session runs the I/O calibration process concurrently.
D. The pending area has not been created before running the I/O calibration process.
Answer: B
Q63. View the Exhibit and examine the output.
You executed the following command to enable Flashback Data Archive on the
EXCHANGE_RATE table:
ALTER TABLE exchange_rate FLASHBACK ARCHIVE;
What is the outcome of this command?
A. The table uses the default Flashback Archive.
B. The Flashback Archive is created on the SYSAUX tablespace.
C. The Flashback Archive is created on the same tablespace where the tables are stored.
D. The command generates an error because no Flashback Archive name is specified and there is no default Flashback Archive.
Answer: D
Q64. Which three actions are required to configure the Flashback Database? (Choose three.)
A. set Flash Recovery Area
B. enable Flashback logging
C. create FLASHBACK tablespace
D. start the database in the ARCHIVELOG mode
E. start the database in the NOARCHIVELOG mode
Answer: A,B,D
Q65. You executed the following command to drop a user:
DROP USER scott CASCADE;
Which two statements regarding the above command are correct? (Choose two.)
A. All the objects of scott are moved to the Recycle Bin.
B. Any objects in the Recycle Bin belonging to scott are purged.
C. All the objects owned by scott are permanently dropped from the database.
D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
Answer: B,C
Q66. Examine the following PL/SQL block:
DECLARE
my_plans pls_integer;
BEGIN
my_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE (sql_id => ?9twu5t2dn5xd?;
END;
Which statement is true about the plan being loaded into the SQL plan baseline by the above command?
A. It is loaded with the FIXED status.
B. It is loaded with the ACCEPTED status.
C. It is not loaded with the ENABLED status.
D. It is not loaded with the ACCEPTED status.
Answer: B
Q67. In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured.
A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:
$ SQLPLUS scott/tiger@DB01 AS SYSDBA
where DB01 is the net service name.
Which authentication method would be used first?
A. authentication by password file
B. authentication by using certificates over SSL
C. authentication by using the Oracle Internet Directory
D. authentication by using the local OS of the database server
Answer: A
Q68. Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)
A. The database files are corrupted when the database is open.
B. The archived log files are missing for which backup is not available.
C. The user has dropped an important table that needs to be recovered.
D. You are not able to start up the database instance because the required database files are missing.
Answer: A,D
Q69. Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?
A. point-in-time recovery
B. execute the ROLLBACK command with transaction number
C. flashback the database to before the transaction was committed
D. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
Answer: D
Q70. Which two statements are true regarding the starting of the database instance using the following command? (Choose two.) SQL>STARTUP UPGRADE
A. It enables all system triggers.
B. It allows only SYSDBA connections.
C. It ensures that all job queues remain active during the upgrade process.
D. It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.
Answer: B,D