81. You want to refer the employee personal information stored in operating system(OS) files in EMPLOYEE<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

table. You plan to add a new column to EMPLOYEE table to achieve this.

Whichdatatype would you use for the new column?

A) BLOB

B) CLOB

C) BFILE

D) LONG RAW

Editor’s notes:oraclehas four big objects for lob type.it is blob，clob，nclob，bfile.

Blob Is used for storing image file.

Clob is used for storing large character data

Bfile is used for stroing external file for oracle.

Website associated:

http://www.itpub.net/viewthread.php?tid=995557&extra=&page=1

?

82. You want to monitor and control the resource usage by sessions. You want to be warned automatically

when more than 100 sessions are opened with your database. What action would you take to achieve this?

A) Use the Database Resource Manager.

B) Set the limits in the profiles used by users.