What view(s) do you use to associate a user's SQLPLUS
session with his o/s process?
No Answer is Posted For this Question
Be the First to Post Answer
In oracle 10g export, import if we declare rows=y/n what would be the output?
Name a tablespace automatically created when you create a database.
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
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.
what do you understand by flashback feature of oracle?
how will you see when the database was started using sql prompt?
What are the steps you will take to improve performance of a poor performing query?
Give two examples of how you might determine the structure of the table DEPT.
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
Oracle 11g new features?
when does an alert gets signaled?
what is a user-defined lock?
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)