Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
No Answer is Posted For this Question
Be the First to Post Answer
What command would you use to encrypt a PL/SQL application?
Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?
11 Answers FA, GE, Wipro,
how can you record information about current session?
What is the difference between clustered and non-clustered index? : sql server DBA
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
How would you determine the time zone under which a database was operating?
How can you gather statistics on a table?
WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.
How does Oracle guarantee data integrity of data changes?
What is blocking and how would you troubleshoot it?
Where would you look for errors from the database engine?
What are the different types of indexes available in sql server? : 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)