-
Recent Posts
-
February 2012 M T W T F S S « Apr 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 Archives
Tag Archives: Oracle – Frequently Asked Questions
Oracle – Frequently Asked Questions
1. What is ORACLE? Oracle is a Relational Database Management System (RDBMS) which is used widely for business applications. 2. What is SGA? The System Global Area (SGA) is a shared memory region allocated by ORACLE that contains data and control information for one ORACLE instance. 3. What is the function of Checkpoint (CKPT)? The Checkpoint (CKPT) process is responsible for signaling DBWR at checkpoints and updating all the data files and control files of the database. The CKPT is also useful to get the point in time from where to begin the recovery in … More ->
Tagged advantages of using cursors with FOR LOOPS, Bind Variables, Can we write INSTEAD OF triggers on tables, firing sequence for a trigger on a table, How to create Bind Variables, Oracle - Frequently Asked Questions, Oracle FAQ, Oracle Interview questions, PL/SQL Frequently Asked Questions, PL/SQL Interview questions, RAISE NO_DATA_FOUND, Redo Log Buffers, Shared Pool, use of NO WAIT option with SELECT.... FOR UPDATE clause, use of SHOW ERRORS, What are the components of SGA?, What is ORACLE?, What is SGA?, What is SQL*PLUS, What is the function of Checkpoint (CKPT)?
Leave a comment