-
-
-
TCS Database Questions
1. What are the different types of joins?2. Explain normalization with examples.3. What cursor type do you use to retrieve multiple recordsets?4. State the difference between a "where" clause and a "having" clause5. What is the difference between "procedure" and "function"?6. How will you copy the structure of a table without copying the data?7. How to find out the...
-
-
How can be determine the size of the database?
You can query dba_data_files and dba_temp_files