What are the commands you'd issue to show the explain plan
for "select * from dual"?
No Answer is Posted For this Question
Be the First to Post Answer
How would you force a log switch?
what are the differences of where and if in SAS?
what is rebuild index??
How many memory layers are in the shared pool?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
how can you process messages in order asynchronously?
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
how can you create a user-defined lock?
Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
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)