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
by issuing "alter tablespace begin backup;" what happens to tablespace?
Give the reasoning behind using an index.
How to start SQL Server in minimal configuration mode?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How would you go about verifying the network name that the local_listener is currently using?
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?
What are the different ways you can create databases in sql server? : sql server DBA
Where in the Oracle directory tree structure are audit traces placed?
How do you open a cluster administrator? : sql server DBA
Explain how you would restore a database using RMAN to Point in Time?
Compare and contrast TRUNCATE and DELETE for a table.
Give two methods you could use to determine what DDL changes have been made.
Oracle (3253)
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)