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

What are the differences between char and nchar in oracle?

1102

How to install oracle odbc drivers?

1099

What is a table index in oracle?

1135

How to grant create session privilege to a user in oracle?

1011

What are the ansi data types supported in oracle?

953

How to filter out duplications in the returning rows using oracle?

1020

How to specify default values in insert statement using oracle?

1114

What is an oracle database table?

1019

What is an oracle user account?

1000

How to change system global area (sga) in oracle?

1017

How to commit the current transaction in oracle?

1130

What is the simplest tool to run commands on oracle servers?

1014

How to check the server version in oracle?

1100

What is an oracle transaction?

1156

How to find out what privileges a user currently has in oracle?

1 1520

Un-Answered Questions { Databases }

What does the file with the extension: frm, myd, and myi contain?

928

Why we use cross join?

961

what is checksum in sql server.........???

1695

How to create new tables with "select ... Into" statements in ms sql server?

998

What is thread join () in threading?

1019

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1089

What is the purpose of a sql?

983

What are the benefits of postgresql?

859

How you can make a parameterized view?

1023

Is sql similar to mysql?

903

What are the underflow and overflow behaviors on float literals?

1119

Is sql a rdbms?

818

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.

2003

What are the different types of indexes?

1124

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

2362

For More Un-Answered { Databases } Questions Click Here