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

how to create a database in oracle?

3 7106

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

4 7730

what are corelated subqueries

Global Infotech,

1 2828

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

Teledata,

2 6330

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

1 3818

who is the father of oracle and send chodd rules

ME,

4 19031

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

6 7783

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

Sollet Soft,

1 7175

what is data access layer?

2412

what is the difrence between sql and pl/sql

Wipro,

21 28263

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

2 10635

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

1 4821

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

4 7051

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 4929

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 22586

Un-Answered Questions { Databases }

What is data set in report?

143

What is scrollable cursor?

1052

How to write text literals in oracle?

1082

How do you know if sql server is running on your local system?

1057

How many databases can sql express handle?

998

Can we take the full database backup in log shipping?

968

How to enforce security in sql server? : sql server security

1122

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

960

How do I download mysql?

903

explain what is raid and what are different types of raid configurations? : Sql server database administration

1018

What does rownum mean in sql?

1041

What are the tools provided in oracle enterprise manager?

Does google use postgresql?

911

Why is the cursor important?

1054

What do you understand by a database object?

1083

For More Un-Answered { Databases } Questions Click Here