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

If there is failure during updation of certain rows, what will be the state?

2 10993

What is the difference between Userdefined function and stored procedure? Explain and give the example also

5 10783

In Oracle 9i what does "i" Stands for?

MBT,

36 61266

What is OQL?

4 12048

what are the disadvantages of hierarchial database over RDBMS?

TCS,

1 13101

Can we create more than one constraint to column ?

6 11321

what is the difference between simple view and complex view?

13 53776

what is the use of rank function?

1 6395

How many different types of indexes we have in oracle?

IBM, TCS,

24 193465

what are pseudocolumns?

4 11133

what is the use of composite key constraint?

2 8634

what is a cartition product?

4 11817

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

iFlex,

2 7520

what is the use of ondelete cascade?

3 8467

what is cartesian product?

2 8286

Un-Answered Questions { Databases }

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

1045

What is sql comments?

1119

Does truncate remove indexes?

1086

How can you enter multi line operations in the mongo shell?

What are user defined functions?

1068

What is Tax Categories?

2162

Provide an explanation about write ahead logging?

855

What are the ansi data types supported in oracle?

993

What is the difference between clustered index and primary key?

975

What is a data source (ds)?

979

How do you update a sql procedure?

1092

when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1798

what's the maximum size of a row? : Sql server database administration

1167

What are the main benefits of using spfile over pfile?

680

How to how to convert numeric expression data types using the convert() function??

1099

For More Un-Answered { Databases } Questions Click Here