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

Civil Engineering Interview Questions - 7

1. Give some conventional signs & symbols used in drawing. Ans: 2. What is the standard range of tread and risers for staircase? Ans:  a. The tread for staircase range from 230 mm to 300 mm          b. The riser for staircase range from 150 mm to 165 mm 3. What is a site plan?    Ans: Location of the facility within the plot area indicating the...

Read More

Civil Engineering Interview Questions - 6

1. What is scale? What are the different scales adopted for drawings?      Ans: Scale is defined as Drawing measurement / Actual measurement. The different scales adopted are    1:100, 1:50, 1:20. 2. What are the different sheet sizes you adopt for drawings?     Ans: Different drawing paper sizes adopted are: ISO A1, ISO A2, ISO A0 etc. 3. How do you make revision...

Read More

Civil Engineering Interview Questions - 5

1. What are the advantages offered by trees if planted surrounding the building?      Ans: The trees will prevent the noise and air pollution to a maximum extent. 2. Which is the type of lift that doesn’t need a machine room on top of the last floor?      Ans: The Hydraulic Lift doesn’t need a machine room on top of the last floor. 3. What are the types of arches used...

Read More