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

create index a on employee(dno) In this,which index was created?

2 4910

How will u get 5 years back record?

5 9939

What is a materialized view?

3 8681

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

1 2297

What is MSDE?

2 5058

How can you see what type of locks used?

1 5001

What is transcation?Plz give One example?

2 5211

Plz tell about backup&recovery?

3 5481

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

3 17771

If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

IBM,

8 12583

what is difference between table and view? where to use views? thanks in advance!

1 4909

What is WITH CHECK OPTION

Karur Vysya Bank KVB,

3 10230

what means of sybase ?? and how i can use sybase data base on my computer Iam the first use it >> any help please !

3 7855

With out using count() function. How to the find total number of rows in a table?

6 13241

why should required nested tables, Object types, partition tables and varying arrays. what is the difference between these are all. give me example with explanation.

2 6837

Un-Answered Questions { Databases }

Explain “row_number()” in sql server with an example?

1073

Why should you use or avoid select * statements?

1106

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2089

what is the command syntax for inserting a document?

List out the different types of locks available in sql server?

1045

what is spatial nonclustered index

1054

Can we shrink data file in sql server?

1123

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1856

How efficient you are in oracle and SQL server?

1252

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

1012

Can we do dml on views?

1032

What is the current mysql version?

1095

How can you append an identity column to a temporary table?

1066

How do I start sql server 2017?

1011

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2209

For More Un-Answered { Databases } Questions Click Here