OCA OCP Oracle Certification Exam Braindumps

176. While tuning the shared server in your database, you executed the following command: How does this statement affect the shared server configuration? (Choose two.)
A.If there are currently less than five dispatchers, new dispatchers are created. 
B.If there are currently more than five dispatchers, additional dispatchers are terminated after the connected users disconnect.  C.If there are currently more than five dispatchers, Oracle server terminates additional dispatchers immediately. 
D.If there are currently less than five dispatchers, Oracle server terminates all of them and creates five new dispatchers.  ANSWER: AB 

177. Which two statements are correct guidelines regarding the process of choosing the number of dispatchers for the database? (Choose two.) 
A.Kill the dispatcher for the user at the operating system (OS) level if the user causes one of the shared servers waiting.  B.Increase the number of dispatchers when the average wait time for users   sessions is found to be steadily increasing. 
C.When a large number of clients are connected through the same dispatcher, increase the number of dispatchers so that current users get service from new dispatchers. 
D.The number of dispatchers for a protocol can be set irrespective of the value of the PROCESSES parameter. 
E.Increase the number of dispatchers when the busy rate is over 50% and the number of clients for a dispatcher is high indicating high contention. 
ANSWER: BE  

178. You created an index on the pdcost column of the PDLIST table in your database, and then executed the following command to find the total number of rows sorted until now: Execution of which two queries would increase the sorts(rows) value? (Choose two.)  A.SELECT sum(pdcost) FROM pdlist;
B.SELECT max(pdcost) FROM pdlist;
C.SELECT DISTINCT pdcost FROM pdlist; 
D.SELECT * FROM pdlist ORDER BY pdcost;  respective of the value of the PROCESSES parameter. 
E.Increase the number of dispatchers when the busy rate is over 50% and the number of clients for a dispatcher is high indicating high contention. 
ANSWER: CD  

179. You executed the following command to create an index on IPCOST column of PRODTB table: Why would it be useful to create the index with the NOSORT clause?
A.It uses one of the existing indexes for sorting.
B.It creates the index with sorting on the basis of the primary key. 
C.It creates an invalid index that needs to be rebuilt after values in the column are sorted. 
D.It cuts down the time needed to build the index and workareas space and temp tablespace I/O needed to build the index.
ANSWER: D  

180. You executed the following query: The EMPLOYEES and DEPARTMENTS tables have no indexes and the HASH_JOIN_ENABLED parameter is set to false. From the following list of actions, select the correct sequence   on the basis of the order of their execution:  
A.2, 1, 3 
B.1, 2, 3
C.2, 3, 1 
D.1, 2; 3
E.Anyone is not required 
ANSWER: A