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

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)

Databases Interview Questions

Questions Answers Views Company eMail

How would you best determine why your MVIEW couldnt FAST REFRESH?

1889

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2254

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1882

How would you begin to troubleshoot an ORA-3113 error?

2077

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1911

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2051

How would you extract DDL of a table without using a GUI tool?

1 4454

Youre getting high busy buffer waits - how can you find whats causing it?

1 2600

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

Infosys,

2273

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2159

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

2007

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2324

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1932

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2123

Explain how you would restore a database using RMAN to Point in Time?

2144

Un-Answered Questions { Databases }

What are the different types of lock modes in sql server 2000?

948

What is triggers?

959

what is union, minus and interact commands? : Sql dba

1185

What is difference between join and natural join?

969

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

1630

Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');

970

what rules exist regarding format, content, flame wars, etc

What is for xml in sql server?

1073

Can we use where clause in union?

1066

How many redo logs should you have and how should they be configured for maximum recoverability?

567

What is a foreign key constraint?

1018

What is a text delimiter?

932

What is a query?

876

What is the difference between functions, procedures, and packages in pl/sql?

1049

What is postgresql?

914

For More Un-Answered { Databases } Questions Click Here