What are statistics, under what circumstances they go out
of date, how do you update them?
No Answer is Posted For this Question
Be the First to Post Answer
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
How do you add a data file to a tablespace?
Give two methods you could use to determine what DDL changes have been made.
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?
What is the difference between the SQL Loader and IMPORT utilities?
what is the purpose of catlaog in oracle rman?
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
What type of index should you use on a fact table?
what is the difference between off-line back up and on-line back up in ibm db2 udb?
What are the different ways you can create databases in sql server? : sql server DBA
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)