If you're unsure in which script a sys or system-owned
object is created, but you know it's in a script from a
specific directory, what UNIX command from that directory
structure can you run to find your answer?
Explain the use of setting GLOBAL_NAMES equal to TRUE.
How would you go about increasing the buffer cache hit ratio?
orra 1555 what is this error,why it is occur?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
What are the different types of indexes available in sql server? : sql server DBA
How can you enable a trace for a session?
I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........
What is the recommended interval at which to run statspack snapshots, and why?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What would you do with an "in-doubt" distributed transaction?
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)