Exam information

Exam 1Z0-055, Oracle Database 11g: New Features for 9i OCPs (December 9th, 2013)

Other

Which two statements regarding the above command are correct?


You executed the following command to drop a user:DROP USER scott CASCADE;Which two statements regarding the above command are correct? (Choose two.)

Which client requests to the database can be captured as a part of the workload capture?

Which client requests to the database can be captured as a part of the workload capture? (Chooseall that apply.)

Which statement is correct in this scenario?

You executed the following SQL statement to shrink the EMPLOYEES table segment stored in theEXAMPLE tablespace:ALTER TABLE employees SHRINK SPACE CASCADE;Which statement is correct in this scenario?

Which method or command would you use to accomplish this task?

You want to convert your existing non-ASM files to ASM files for the database PROD. Whichmethod or command would you use to accomplish this task?

What is the result of executing this command?

You have three production databases, HRDB, FINDB and ORGDB that use the same ASMinstance. At the end of the day, while all three production database instances are running, youexecute the following command on the ASM instance.SQL> shutdown immediate;What is the result of executing this command?


Which two statements are in this scenario for the features enabled for ASM?

You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLEinitialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attributefor the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1. Which twostatements are in this […]

Which statement regarding the above command is correct?

You have three temporary tablespace groups named G1, G3 and G3 in you database.You are creating a new temporary tablespace as follows:CREATE TEMPORARY TABLESAPCE TEMP1 TEMPFILE ‘/u1/data/temp1.dbf’ SIZE 10MTABLESPACE GROUP";Which statement regarding the above command is correct?

Which method would help you perform the above checks automatically?

You have the following requirements in relation to the detection of block corruption for yourdatabase instance:1. Check for logical self-consistency of data blocks when modified in memory2. Checksums are calculated before and after the block change3. Checks are performed for the lost writes to […]

Which client requests to the database can be captured as a part of the workload capture?

Which client requests to the database can be captured as a part of the workload capture? (Chooseall that apply.)

Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

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



Page 1 of 1512345...10...Last »