Online Access Free 1Z0-055 Exam Questions

ENCRYPT_TS is an encrypted tablespace that contains tables with data.
Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

• A.The data remains encrypted when it is stored in the redo logs.
• B.The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.
• C.The data is decrypted during SORT and JOIN operations.
• D.The data remains encrypted when it is read into memory.

You are managing an Oracle Database 11g instance. You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication? (Choose all that apply.)

• A.The source database backup must be copied over the net for test database.
• B.The source database must be run in ARCHIVELOG mode if the database is open.
• C.The source database must be shut down cleanly if the database is in mounted state.
• D.A net service name should be set up and a listener configured with the target as well as the source database.

Evaluate the following command and its output:
SQL>SELECT * FROM dba_temp_free_space; TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
LMTEMP 250609664 101048576 149561088
Which two statements correctly interpret the output? (Choose two.)

• A.FREE_SPACE indicates only the space that is currently allocated and available for reuse.
• B.ALLOCATED_SPACE indicates only the space currently allocated and in use.
• C.FREE_SPACE indicates only the space that is currently unallocated.
• D.FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.
• E.ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.

View the following SQL statements:
Transaction T1
INSERT INTO hr.regions VALUES (5,'Pole');
COMMIT; Transaction T2
UPDATE hr.regions SET region_name='Poles' WHERE region_id = 5; COMMIT;
Transaction T3
UPDATE hr.regions SET region_name='North and South Poles' WHERE region_id = 5;
You want to back out transaction T2. Which option would you use?

• A.It is not possible because it has conflicts with transaction T3.
• B.It is possible with the NONCONFLICT_ONLY option.
• C.It is possible with the NOCASCADE_FORCE option.
• D.It is possible, but transaction T3 also backs out.

View the Exhibit to examine the output for the V$DIAG_INFO view.
Which statements are true regarding the location of diagnostic traces? (Choose all that apply.)

• A.The location of the text alert log file is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.
• B.The location of the XML-formatted version of the alert log is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.
• C.The location of the trace file for the current session is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.
• D.The path to the location of the background as well as the foreground process trace files is
  /u01/oracle/diag/rdbms/orclbi/orclbi/trace.