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?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
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.
What column differentiates the V$ views to the GV$ views and how?
any body know about orawaves do they really provide placements in their unique placement program
Explain how you would restore a database using RMAN to Point in Time?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What is the default port no on which sql server listens? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How can we see the database version in os level
What is the default fill factor value? : sql server DBA
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
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)