-
DBWn Processes
Which parameter specifies the number of DBWn processes?
-
Dictionary Management Tablespaces
How will you change the local management tablespaces into dictionary management tablespaces?
-
Dynamic SGA
What is Dynamic SGA?What is the advantage of Dynamic SGA?
-
Oracle Segments
What are the different types of segments in Oracle?
-
Execute Immediately
What is the meaning of execute immediately?
-
Types of Lock
Explain share and exclusive type of lock.
-
Intent Shared Lock
Which one of the following is descriptive of the effect of an Intent Shared Lock on other transactions? CHOICE1: A Read Lock that prevents writes CHOICE2: A Read Lock that prevents other reads CHOICE3: A Read Lock that prevents more restrictive Locks CHOICE4: A Read Lock that allows other reads CHOICE5: A Read Lock that allows writes (Dirty Reads)
-
-
-
-
-
-
-
-
-
-