Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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)

Databases Interview Questions

Questions Answers Views Company eMail

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2183

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2878

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2325

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2183

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

2050

How do you tell what your machine name is and what is its IP address?

2169

How would you go about verifying the network name that the local_listener is currently using?

2115

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2070

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2403

What is the recommended interval at which to run statspack snapshots, and why?

2973

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2159

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2000

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

2001

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4573

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

1 3646

Un-Answered Questions { Databases }

Where is localdb stored?

998

What is the maximum size of a dimension? : sql server analysis services, ssas

1102

What is the difference between clustered and non-clustered index in sql?

1071

Explain about party and customer in ar : oracle accounts receivable

1274

What are the requirements on sql server network connections?

1047

What are the three types of database design?

1090

Can select statements be used on views in oracle?

1091

What are the different parts of a database application called in access?

854

Explain vdl (view definition language)?

1079

Is it safe to delete log files?

987

Mention what is the function of cache fusion in oracle rac?

What are the advantages of rdbms?

955

what is the difference between a having clause and a where clause? : Sql dba

1168

Which sql server table is used to hold the stored procedure scripts?

1115

What is a database connection string?

1176

For More Un-Answered { Databases } Questions Click Here