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 create a database in oracle?

3 7273

select empid empname from employee What is the result for the about query?

4 7980

what are corelated subqueries

Global Infotech,

1 2936

can you any body tell me suppose database is suspect mode. how can take to normal?

Teledata,

2 6446

can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 3909

who is the father of oracle and send chodd rules

ME,

4 19222

one table has four field id,name,design,salary. i have to find maximum salary .

6 8066

In a package if we have 10 procedures or functions,How to know which will execute first?

Sollet Soft,

1 7269

what is data access layer?

1 2467

what is the difrence between sql and pl/sql

Wipro,

21 29245

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 10785

query to find the maximum no persons with same age(age colomn) from emp table

1 4925

How to find the date and time of last updated table?

4 7213

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 5088

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

Oracle, TCS,

13 23132

Un-Answered Questions { Databases }

Can we use distinct and group by together?

1133

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1194

What are the different SQL Server Versions you have worked on?

1077

What is the current version of postgresql?

1175

What are the different types of subquery?

1233

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1043

What is self contained sub query?

1138

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1897

do you know how to configure db2 side of the application? : Sql server database administration

1119

How efficient you are in oracle and SQL server?

1255

What is a concurrency problem in dbms?

1052

What is clustered index

1083

Have you created fact table and dimension tables?

710

What is subquery? Explain the properties of a subquery?

1057

What is the difference between upgrade and migration in sql server?

1180

For More Un-Answered { Databases } Questions Click Here