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 would you best determine why your MVIEW couldnt FAST REFRESH?

1937

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

2311

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

1940

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

2132

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

1964

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

2112

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

1 4527

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

1 2678

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

Infosys,

2347

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

2218

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.

2064

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

2378

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

1983

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.

2184

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

2193

Un-Answered Questions { Databases }

Can we use rowid as primary key?

1051

difference between global n context sensitive segments?

2733

How to create percentile function?

161

Is it possible to call a stored procedure within a stored procedure?

1037

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1089

What are the differences between char and varchar in ms sql server?

1132

What is ase database?

1061

What are the constraints available in sql?

1098

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

3278

Explain indexed views?

1035

Does table partitioning require user-defined segments in sybase?

858

What are window functions in sql server?

1072

What is sql catalog?

1071

Can you get microsoft access for free?

924

Is database a hardware or software?

1053

For More Un-Answered { Databases } Questions Click Here