advanced pl sql interview questions and answers Page4

Below are some important PLSQL interview questions which are asked in most MNC company interviews for beginners or professionals.

31. How would you determine what sessions are connected and what resources they are waiting for? | PL/SQL Questions
Use of V$SESSION and V$SESSION_WAIT

32. Describe what redo logs are. | PL/SQL Questions
Redo logs are logical and physical structures that are designed to hold all the changes made to a database and are intended to aid in the recovery of a database.

33. How would you force a log switch? | PL/SQL Questions
ALTER SYSTEM SWITCH LOGFILE;

34. Give two methods you could use to determine what DDL changes have been made.
You could use Log miner or Streams

35. What does coalescing a table space do?
Coalescing is only valid for dictionary-managed table spaces and de-fragments space by combining neighboring free extents into large single extents.

36. What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
A temporary tablespace is used for temporary objects such as sort structures while permanent tablespaces are used to store those objects meant to be used as the true objects of the database.

37. Name a tablespace automatically created when you create a database.
The SYSTEM tablespace.

38. When creating a user, what permissions must you grants to allow them to connect to the database?
Grant the CONNECT to the user.

39. How do you add a data file to a tablespace?
ALTER TABLESPACE ADD DATAFILE SIZE

40. How do you resize a data file?
ALTER DATABASE DATAFILE RESIZE ;
More Questions & Answers :-
Page1  Page2  Page3  Page4  Page5