052 (38)

186.

186. YouPlan  toImplement theDistributed DatabaseSysteminchyour company. You invokeDatabaseConfiguration Assistant (DBCA) to CreateADatabase  onThe server. During the installation, DBCA prompts you toSpecify the GlobalDatabaseName.what must this Name is made up of? A. It must is made up ofADatabaseName anda domain name. B. It must is made up ofThe valueinchOracle_sid andHOSTNAME. C. It must is made up ofThe value of thatPlan  toAssign forInstance_name andHOSTNAME. D. It must is made up ofThe value of thatPlan  toAssign forOracle_sid andService_names.

187. View the Exhibit and examine the output of the query.

What does you infer fromThis ? A. The Sga_target isa static parameter. B. The instance isStarted, but theDatabase  is  notYetOpen. C. The Server parameterfile(SPFILE) was used tostart the instance. D. The Sga_target parameter does notHave anyEffect onTheDatabaseinstance until the Sga_max_size parameter isSpecified.

188. View the Exhibit and examine the output.

which statements is true regarding the LISTENER2 listener? (Choose.) A. The ORCL instance isRegistered dynamically withThe listener. B. The ORCL instance isRegistered staticallyinchThe Listener.orafile. C. the Number  of  CurrentClient connections handled byThe service Handler isBoth . D. the total Number  ofClient connections handled so far byThe service Handler isBoth.

189.

189.UserSCOTT wants toPerform aBulk InsertOperationinchThe EMP_DEPTable. SCOTT receives the following error after theINSERTStatement isIssued andfew rows are inserted:INSERT  intoEMP_DEP (emp_id,name,salary,dep_name,mgr_id)*ERROR at line1: ORA-01653: unable toExtendTableSCOTT. Emp_dep by  - inchtablespace usersidentify and the actions either ofWhich'll help you resolve this problem. (Choose.) A.GrantThe RESOURCE role toSCOTT. B.ADDData files toThe USERS tablespace. C.GrantTheCREATE  any TABLEPrivilege toSCOTT. D. Increase theSpace  forSCOTT onThe USERS tablespace. E. Increase the size ofThe datafileAssociated withThe USERS tablespace.

190.

 the.SomeNon-DBA UsersinchYourDatabasehave been granted any TABLESystemPrivileges  andthey is able toAccess data dictionary base tables. You decide to RestrictTheir access toData Dictionary objects. Which method would you adopt toachieve this objective? A.RevokeThe RESOURCE role fromThe users. B.SetThe value ofThe Os_roles parameter toTRUE. C. Use DatabaseResource Manager to Restrict UserAccess toobjects. D.Grant  any TABLESystemPrivilegesAgain without ADMINOPTION. E.SetThe value ofThe o7_dictionary_accessibility parameter toFALSE.

052 (38)