Oracle 1Z0-035 Actual Free Exam Questions & Community Discussion
The enterprise data warehouse routinely receives data from various production OLTP databases. The database block size on the data warehouse is 8192, and in the OLTP databases it may be 2048, 4096 or 8192. The current SGA is 112 MB.
Oracle9i has the ability to transport tablespaces with different block sizes.
Which two parameters are required in order to "plug in" the OLTP tablespaces into the warehouse database? (Choose two.)
Oracle9i has the ability to transport tablespaces with different block sizes.
Which two parameters are required in order to "plug in" the OLTP tablespaces into the warehouse database? (Choose two.)
Correct Answer: A,F
Vote an answer
There is more than one way to set the server to detect and affect long running operations automatically. What is the best choice if you want to reduce the impact of long running operations on other users without aborting the long running operations?
Correct Answer: D
Vote an answer
The Oracle9i LogMiner needs a data dictionary copy to display the object names.
From which three locations can LogMiner retrieve the data dictionary information? (Choose three.)
From which three locations can LogMiner retrieve the data dictionary information? (Choose three.)
Correct Answer: A,C,F
Vote an answer
Examine this fragment from a SQL*Plus session:
SQL> SELECT name, value FROM v$sysstat 2> WHERE name LIKE 'work area executions%';
NAME VALUE work area executions - optimal 1544 work area executions - onepass 11 work area executions - multipass 1038
What can you conclude about the setting of the PGA_AGGREGATE_TARGET initialization parameter?
SQL> SELECT name, value FROM v$sysstat 2> WHERE name LIKE 'work area executions%';
NAME VALUE work area executions - optimal 1544 work area executions - onepass 11 work area executions - multipass 1038
What can you conclude about the setting of the PGA_AGGREGATE_TARGET initialization parameter?
Correct Answer: B
Vote an answer
What is true regarding a transaction executed in Automatic Undo Management mode?
Correct Answer: D
Vote an answer
When enabling Flashback using a wall-clock time, within what period does the database choose a System Commit Number (SCN)?
Correct Answer: A
Vote an answer
Which two statements about optimizer plan stability are true? (Choose two.)
Correct Answer: A,D
Vote an answer
Select the five items that are supported for parallel operations. (Choose five.)
Correct Answer: A,B,C,E,F
Vote an answer
0
0
0
10