Category: Oracle Exam

QUESTION 1 You have assigned rights profiles directly to the uses frank and now you want to add another profile. Which command enables you to list profiles directly assigned to frank? A.    userattr profiles frank […]

QUESTION 1 What determines which bits in an IP address represent the subnet, and which represent the host? A.    Subnet B.    unicast C.    netmask D.    multicast E.    broadcast Answer: C

QUESTION 1 What can you do with the DBMS_LOB package? A.    Use the DBMS_LOB.WRITE procedure to write data to a BFILE. B.    Use the DBMS_LOB.BFILENAME function to locate an external BFILE. C.    Use the DBMS_LOB.FILEEXISTS […]

QUESTION 1 Examine the parameters for your database instance: NAMETYPE VALUE ————————– ——————————- ————————— undo_management string AUTO undo_retentioninteger 12 00 undo_tablespace string UNDOTBS1 You execute the following command: SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE; Which […]

QUESTION 1 You need to create a table for a banking application. One of the columns in the table has the following requirements: 1) You want a column in the table to store the duration […]

QUESTION 1 You notice that the performance of your production 24/7 Oracle database significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the […]

QUESTION 1 Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two.) A.    An extent cannot spread across data files. B.    A segment cannot spread across data […]

QUESTION 1 Evaluate the following CREATE TABLE commands: CREATE TABLE orders (ord_no NUMBER(2) CONSTRAINT ord_pk PRIMARY KEY, ord_date DATE, cust_id NUMBER(4)); CREATE TABLE ord_items (ord_no NUMBER(2), item_no NUMBER(3), qty NUMBER(3) CHECK (qty BETWEEN 100 AND […]