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

Which environment variables are absolutely critical in order to run the OUI?

2 4569

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 6771

Why does Oracle not permit the use of PCTUSED with indexes?

1 3045

What would you use to improve performance on an insert statement that places millions of rows into that table?

TCS,

2 6338

What would you do with an "in-doubt" distributed transaction?

1 1966

What are the commands you'd issue to show the explain plan for "select * from dual"?

1 2293

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

1 2521

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?

1 3508

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 3600

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1 2061

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?

1 7397

Explain the concept of the DUAL table.

3 6317

What are the ways tablespaces can be managed and how do they differ?

IBM,

2 6803

From the database level, how can you tell under which time zone a database is operating?

1 4441

What's the benefit of "dbms_stats" over "analyze"?

1 5789

Un-Answered Questions { Databases }

Is microsoft getting rid of access?

881

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1021

How to remove duplicate rows from table except one?

1079

How many concurrent programs you have customized, can you name some of them?

How raid can influence database performance?

1108

What is a view in sql?

1035

Explain system functions or built-in functions? What are different types of system functions?

1056

how to use regular expression in pattern match conditions? : Sql dba

1105

what is bcp? When does it used? : Sql dba

1052

How can I check that whether automatic statistic update is enabled or not?

1108

What is temporary table in sql server? Why we use temp table?

1008

Design database draw er diagram for a certain scenario ?

4645

What is the primary use of the model database?

1144

How to start an oracle instance?

1095

How efficient you are in oracle and SQL server?

1251

For More Un-Answered { Databases } Questions Click Here