Civil Engineering Interview Questions - 8

1. What are the tools used during construction?     Ans: Tools used during Construction are Dumpy Level, Spirit Level, Square, Plumb, Trowel, Spade, Shovel, Crowbar, Steel Bowl, Measuring Tape, Measuring Box etc. 2. What are the tools used in Carpentry?     Ans: The tools used in Carpentry are Chisel, Hammer, Plain, Sand Paper, Nails, Wedge, Screws, Saw, Square, Boring Tools etc. 3. What...

Read More

Oracle DBA Interview Questions - 7

1. Define Transaction?     A Transaction is a logical unit of work that comprises one or more SQL statements executed by a single user. 2. When does a Transaction end?     When it is committed or Roll backed. 3. What does COMMIT do?     COMMIT makes permanent the changes resulting from all SQL statements in the transaction. The changes made by the SQL statements of a transaction become visible to other user...

Read More

Oracle DBA Interview Questions - 6

  1. What are the different types of PL/SQL program units that can be defined and stored in ORACLE database?    Procedures and Functions, Packages and Database Triggers. 2. What is a Procedure?     A Procedure consist of a set of SQL and PL/SQL statements that are grouped together as a unit to solve     a specific problem or perform a set of related tasks. 3. What is difference between Procedures and...

Read More

Oracle DBA Interview Questions - 5

1. What Does DBWR do?      Database writer writes modified blocks from the database buffer cache to the data files. 2. When Does DBWR write to the database?      DBWR writes when more data needs to be read into the SGA and too few database buffers are free. The least recently used data is written to the data files first. DBWR also writes when CheckPoint occurs. 3. What does LGWR do?      Log...

Read More

Oracle DBA Interview Questions - 4

1. What constitute an ORACLE Instance?       SGA and ORACLE background processes constitute an ORACLE instance. (Or) Combination of memory structure and background process. 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 are the components of SGA?      Database buffers, Redo...

Read More