Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
What is the difference between Datapump & export/import?
What is checkpoint?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what is the use of ocr?
When a user process fails, what background process cleans up after it?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
How can you gather statistics on a table?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How to start SQL Server in minimal configuration mode?
How would you go about generating an EXPLAIN plan?