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

Explain the ways to controlling cursor behavior?

968

Explain the steps to use transact-sql cursor?

1158

Do you know the cursor types?

1207

What is forward - only cursors / read only cursor?

1136

Do you know the capabilities of cursors?

1229

What is cursor in ms sql server?

1206

What is implicit cursors?

1137

What is explicit cursors?

1134

Explain forward - only cursors?

1132

What is scrollable cursor?

1082

Explain the disadvantages of cursors?

1213

What is key set driven?

1011

Explain the cursor lock types?

1101

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

997

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

1005

Un-Answered Questions { Databases }

Explain the truncate in oracle?

1015

What is regex in mysql?

1151

How would you design a database for an online site, which would average a million hits a day?

1056

how to return query output in html format? : Sql dba

1121

How replication works in mongodb?

Is sql and mysql same?

997

What is the difference between stored procedure and functions?

1206

What is 2nf and 3nf?

1004

Is mysql is a programming language?

1042

What is report rendering ?

162

What is materialized view. What are different methods of refresh?

1445

What is the use of commit?

1065

What is the maximum no of columns a table can have?

970

How to generate create procedure script on an existing stored procedure?

1073

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

2097

For More Un-Answered { Databases } Questions Click Here