A SQL*Loader control file a text that defines how data files should be loaded into the database. It allows you to specify:
â–º Where is the input data file.
â–º The format of the input date file.
â–º The target table where the data should be loaded.
â–º How input data fields should be mapped to target table columns.
â–º Select criteria to select input records for loading.
â–º Where to output errors.
Which RMAN command is used to create an exact replica of a database in new host?
How do you install Statspack?
Process you follow to start looking into Performance issue at database level (If the application is running very slow, at what points do you need to go about the database in order to improve the performance?)
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?
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
