If you have data stored in external files, you can load it to database through an external table by the steps below:
► Create an external table with columns matching data fields in the external file.
► Create a regular table with the same columns.
► Run an INSERT INTO ... SELECT statement to load data from the external file to the regular table through the external table.
Explain below wait events in STATSPACK report DB SCATTERED READ, DB SEQUENTIAL REAL, ENQUEUE?
List five most important parameter in 9i affecting performance?
What is PGA_AGGREGATE_TARGET?
How do you analyze table partition using Oracle provided package?
You see a wait on LMS process in statspack, what does that mean?
Explain procedure to Change CHARACTERSET of a database.
If you had a tablespace, TEST_TABLESPACE, which consists of three files TEST01.dbf, TEST02.dbf, and TEST03.dbf, and someone accidentally used the Unix command "rm" to delete the file TEST02.dbf, what else would you need in order to recover all the data that was present in TEST_TABLESPACE at the time that TEST02.dbf was deleted?
How do you put database is ARCHIVELOG mode, explain procedure?
How can you tell if an index on particular table is USED or NOT USED in 9i?
Explain FORCE LOGGING feature in 9i.
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
