Answer Posted / sujit jha
A set of Dictionary tables are created once for the entire
database.
| Is This Answer Correct ? | 25 Yes | 4 No |
Post New Answer View All Answers
Why do we need database normalization?
Explain by listing some major advantages of dbms.
Give us a non-computer example of preemptive and non-preemptive scheduling?
What are the two types of indexes and explain them in detail? Or what's the difference between clustered and non-clustered indexes?
Define join types.
What are some disadvantages of a standard language such as sql?
Enlist some commands of ddl, dml, and dcl.
1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD
Is declare cursor executable?
What is cold backup (in case of oracle)?
State some commands of ddl in dbms?
What is " group by " clause?
What are the lock types?
What does rdbms stand for?
Explain the different types of constraints in dbms?