052 (Fri)

21. View the Exhibit and examine the privileges granted to the Sl_rep user.

The EMPTable  isOwned byThe SCOTTUser. The Sl_repUserexecutes the following command:sql> GRANT SELECT  onScott.emp tohr; Which statement describes the outcome ofThe command? A. The command executes successfully B. The command produces an error because the EMPTable  isOwned bySCOTT C. The command produces an error because Sl_rep have theGRANT  anyOBJECT PRIVILEGE without admin_option D. The command produces an error because Sl_rep does notTheSELECTPrivilege withgrant_option onThe EMPTableanswer:a

Grant any OBJECT PRIVILEGE can grant a table under any user to another user

22.

 A. You executed this command to CreateATemporary Table: SQL> CREATEGLOBALTemporary TABLEReport_work_area (startdate date,enddate date,classCHAR( -))  on COMMITPRESERVE ROWS; Which statement isTrue about the rows inserted intoThe Report_work_areaTableduring aTransaction? A. The rows StayinchTheTable  onlyuntil session termination B. The rows StayinchTheTable  onlyUntil theNext TransactionStarts onTheTableC. The rows are visible to  All  CurrentSessions after theTransaction inch committedD. The rows stay available forSubsequent sessions after theTransaction  is committedanswer:a

On COMMIT DELETE ROWS Transaction Temp Table
On COMMIT PRESERVE ROWS Session Temp Table

23.

 at. You want toAccess Employee details containedinchFlat files asPart ofThe EMPLOYEETable. YouPlan  to AddA newcolumn  toThe EMPLOYEETable  toachieve this. Which data types would you Use  forThe newcolumn? A. CLOB B. BLOB c. BFILE D.LONG RAWAnswer:c

BFILE is a database external file

24.

 -. The HRUserCreates a stand-Aloneprocedure  asFollows andGrants theEXECUTEPrivilege on theprocedure  toManyDatabaseUsers:CREATE OR REPLACE PROCEDURECreate_dept (V_deptno Number, V_dnameVARCHAR2, V_mgr Number, V_loc Number)BEGININSERT  intoHr.departmentsVALUES(V_deptno, V_dname, V_mgr, V_loc);END; The Users havingPermission to ExecuteTheprocedureis able to InsertRecords intoThe departmentsTableEven though they do notTheINSERTPrivilege onTheTable. You want onlythose users who hasPrivileges  onThe DepartmentsTable  toBe able to ExecuteTheproceduresuccessfully. What would suggest toThe PL/SQL Developers toachieve this? A.CreateTheprocedure  withDefiner's right. B. Create the procedure with Invoker'S Right. C.GrantTheEXECUTEPrivilege with GRANT OPTION  onTheprocedure  toselected users. D.CreateTheprocedure  asPart ofA PL/SQL Package and GrantTheEXECUTEPrivilege on the Package toselected users. Answer:b

Invoker Caller Permissions

25.

 -. Examine the following command that isUsed to CreateATable: SQL> CREATE TABLEOrders (OID Number(6)PRIMARY KEY, Odate Date,ccode Number(6), Oamt Number(Ten,2) ) tablespace users; Which statements is true about the effect ofThe above command? (Choose.) A. ACHECK constraint  isCreated onThe OIDcolumnB. A not NULL constraint  isCreated onThe OIDcolumnC. The ORDERSTable  isThe onlyObject createdinchThe USERS tablespace D. The ORDERSTable  andAUnique Indexis createdinchThe USERS tablespace E. The ORDERSTable  isCreatedinchThe USERS tablepsace andAUnique Index  isCreated onThe OIDcolumn inchThe SYSTEM tablespace answer:bd

Refer to question 052 (ii) 10th.

052 (Fri)