What are the system resources that can be contro

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

203. What are the system resources that can be controlled through Profile?

The number of concurrent sessions the user can establish the CPU processing time available to the user’s session the CPU processing time available to a single call to ORACLE made by a SQL statement the amount of logical I/O available to the user’s session the amount of logical I/O available to a single call to ORACLE made by a SQL statement the allowed amount of idle time for the user’s session the allowed amount of connect time for the user’s session.

(Continued on next question...)

Other Job Interview Questions

• The join defined by the default data link is an outer join yes or no?
• How can you determine if an index needs to be dropped and rebuilt?
• What are the built-in used for getting cell values?
• Give the sequence of execution of the various report triggers?
• Explain what partitioning is and what its benefit is.
• Is it possible to split the print reviewer into more than one region?
• What is the function of Optimizer?
• What are the types of SQL statement?
• Can a formula column referred to columns in higher group?
• Schema
• More...