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 to connect the oracle server as sysdba?

1133

What is a cursor in oracle?

1232

How to calculate date and time differences in oracle?

1099

What is a select query statement in oracle?

1030

What is a initialization parameter file in oracle?

1088

How to unlock the sample user account in oracle?

1079

How to rollback the current transaction in oracle?

1105

What are the differences between date and timestamp in oracle?

1097

How to pass parameters to procedures in oracle?

1083

What is system global area (sga) in oracle?

1035

How to delete an existing row from a table in oracle?

1130

How to write numeric literals in oracle?

1238

How to write a query with a full outer join in oracle?

1 1550

What operating systems are supported by oracle database 10g xe?

1090

How data locks are respected in oracle?

1113

Un-Answered Questions { Databases }

What is unique key in dbms?

964

Is there a database program for mac?

986

How to implement service broker?

1074

How can you determine if the sqlnet process is running for sqlnet v1? How about v2?

636

How many null values we can have in a unique key field in sql server?

1012

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?

1691

What Are the Main Features of SQL Azure?

121

What is third normal form?

972

Can we create foreign key without primary key?

1040

What is the difference between nested table and varray?

1052

What is the difference between functions and stored procedures?

1226

What is the sql*loader? : aql loader

1103

how many sql dml commands are supported by 'mysql'? : Sql dba

1169

What are aggregate and scalar functions?

1090

What is the normalization?

634

For More Un-Answered { Databases } Questions Click Here