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

in a package one procedure is wrong package shows valid or not

4 8588

what is cursor procedure

iGate,

1 7323

what is global variable in package

Polaris,

3 11288

is it mandatory to select all the column in a view then what columns should be selected

2 6112

difference between pl/sql table and normal pl/sql table

2 12996

will function return more than one value how

Accenture,

9 23989

can i write pl/sql code in a package

2 6735

can i give user defined exception in a package

2 7285

after tell procedure whole code he asked can i write the same way in a function

3 5718

can i use dbms_output.put_line in a function u are telling as return statement

7 18117

a procedure one in two out parameters i am waiting it in a sql query can i get the output

1 4763

difference between cursor and procedure in a package

PCS,

3 29744

difference between oracle 8i and oracle 9i

8 25774

full outer join syntax

5 8827

what is called after appearing where clause

3 6476

Un-Answered Questions { Databases }

What are the different dml commands in sql?

1185

How do you set a trace flag in sql server?

1043

Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2870

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

1593

What is difference between cartesian join and cross join?

1100

How many clustered indexes can you have?

979

What is the datatype of rowid?

931

What are the new scripting capabilities of ssms? : sql server management studio

1072

What is the difference between microsoft sql and mysql?

967

What are the lock types?

958

How do you rebuild an identity column?

957

What are the topics in pl sql?

980

What is 2-tier architecture?

950

How do you add a column to a table?

1065

What do you understand by recursive stored procedure?

943

For More Un-Answered { Databases } Questions Click Here