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
What is blocking and how would you troubleshoot it?
What are the different ways you can create databases in sql server? : sql server DBA
What type of index should you use on a fact table?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
What is the default port no on which sql server listens? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
how can you communicate with operating system files from oracle?
Is it possible to update the multiple field values in a single query? If possible then write the actual query.
Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What is the importance of a recovery model? : sql server DBA
Which environment variables are absolutely critical in order to run the OUI?
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)