Denormalization is used when there is a lot of tables involved in retreiving data.Denormalization is done in dimentional modelling used to construct a data ware house.This is not usually done for data bases of transactional systems.
When creating a user, what permissions must you grant to allow them to connect to the database?
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
What is difference between UNIQUE constraint and PRIMARY KEY constraint?
What does coalescing a tablespace do?
How would you force a log switch?
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?
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
