You can have only one clustered index per table. If you use delete command, you can rollback... it fills your redo log files.
If you do not want records, you may use truncate command, which will be faster and does not fill your redo log file.
How to enable partition support for a database?
Explain What is the advantages data mining over traditional approaches?
Explain the main differences between star and snowflake schema?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
What are the main steps to build the data warehouse?
Explain the different types of data warehousing?
Explain What are Fact, Dimension, and Measure?
Explain What is a cube in data warehousing concept?
Why fact table is in a normal form?
Explain the main difference between Inmon and Kimball philosophies of data warehousing?
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
