In general all organization data bases are normalised to 3nf inorder to remove redundancy and efficent access.A data base can also be created with out normalisation.Hence it is not a mandatory that a database should be in 3nf.
What is the effect of setting the value “ALL_ROWS” for OPTIMIZER_GOAL parameter of the ALTER SESSION command?
Describe what redo logs are.
Explain materialized views and how they are used.
What are the different Parameter types?
What does a Control file Contain?
Where in the Oracle directory tree structure are audit traces placed?
Explain the use of table functions.
What are the system resources that can be controlled through Profile?
Name three advisory statistics you can collect.
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
