Oracle

Send request to get interview tips in PDF format Personal Interview - Answers to frequently asked questions Tips to earn promotions and perks You can also get your answers published How to write a good CV? How to write a good Cover Letter? Tips to become boss's favorite CareerRide is hiring

Oracle data types interview questions

---

<<Previous  Next>>

Part 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30  | 31    NEXT>>  

Oracle data types - August 11, 2008 at 15:00 PM by Amit Satpute Explain the differences between char and varchar2 data types.  Answer The char data type accepts strings that are of fixed length. The VARCHAR2 data type is a varying length data type. Explain BLOB, CLOB, NCLOB and BFILE.   Answer These are the built in large object data types. BLOB, CLOB, NCLOB are stored internally where as BFILE is stored externally The BLOB data type stores binary large objects. The CBLOB data type stores character large objects. The NCBLOB data type stores character large objects in multibyte national character set. The BFILE data type enables access to binary file LOBs that are stored in file systems outside the Oracle database. All these data types have a capacity of 4GB What are the data types in oracle? Explain the differences between char and varchar2 data types. What is a LOB data type? Answer - The LOB datatypes includes BLOB, CLOB, NCLOB and BFILE that can store large blocks of unstructured data such as graphic images, video clips, and sound wave. LOB datatypes can be stored within a table, out-of-line within a tablespaces using a LOB locator, or in an external file (BFILE datatypes). Explain ROWID in oracle. Answer - Each table in oracle has a pseudocolumn called ROWID. Oracle uses ROWID to store address of each rows of the table. Oracle uses ROWID to maintain indexes. Each key in an index is associated with a ROWID that points to the associated row's address for fast access.   <<Previous  Next >>