Oracle Database 11g: New Features for Administrators - 1Z1-050 FREE EXAM DUMPS QUESTIONS & ANSWERS
View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has undergone workloads of different capacities:
SQL> SELECT substr(component, 0,10) COMP, current_size CS,
user_specified_size US
FROM v$memory_dynamic_components
WHERE current_size!=0;
What do you infer from this?
SQL> SELECT substr(component, 0,10) COMP, current_size CS,
user_specified_size US
FROM v$memory_dynamic_components
WHERE current_size!=0;
What do you infer from this?
Correct Answer: A
Vote an answer
Which three statements are true regarding persistent lightweight jobs? (Choose three.)
Correct Answer: A,B,D
Vote an answer
Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)
Correct Answer: A,B
Vote an answer
Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)
Correct Answer: A,D
Vote an answer
You executed the following commands in an RMAN session for your database instance that has failures:
RMAN> LIST FAILURE;
After some time, you executed the following command in the same session:
RMAN> ADVISE FAILURE;
But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?
RMAN> LIST FAILURE;
After some time, you executed the following command in the same session:
RMAN> ADVISE FAILURE;
But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?
Correct Answer: D
Vote an answer
Evaluate the following command:
SQL> CREATE TABLE design_data (id NUMBER,
doc CLOB)
LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);
Which statement is true regarding the above command?
SQL> CREATE TABLE design_data (id NUMBER,
doc CLOB)
LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);
Which statement is true regarding the above command?
Correct Answer: D
Vote an answer
You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?
Correct Answer: B
Vote an answer
USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methods would you use to achieve this? (Choose all that apply.)
Correct Answer: A,C,D
Vote an answer
You are managing an Oracle Database 11 g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective? (Choose all that apply.)
Correct Answer: B,C,D
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file? (Choose two.)
Correct Answer: C,D
Vote an answer
A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?
Correct Answer: B
Vote an answer
You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?
Correct Answer: D
Vote an answer
You want to take the backup of the USERS tablespace. It has a single data file of 900 MB.. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup, you issued the following RMAN command:
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;
Which two statements are true regarding the execution of the above command? (Choose two.)
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;
Which two statements are true regarding the execution of the above command? (Choose two.)
Correct Answer: B,D
Vote an answer
You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process? (Choose all that apply.)
Correct Answer: A,C,D
Vote an answer