Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
No Answer is Posted For this Question
Be the First to Post Answer
how can you get actual data change values from previous transactions in oracle?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility
How does Oracle guarantee data integrity of data changes?
How would you force a log switch?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
How to make a replica of existing oracle server to another server?
Which autogrowth database setting is good? : sql server DBA
what are the performance views in an oracle rac environment?
What is transparent data encryption? : sql server DBA
How would you determine what sessions are connected and what resources they are waiting for?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)