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

What does “select count(*) from tab” result?

IBM, Student, Wipro,

15 29720

What does “select count(1) from tab” result?

IBM,

10 21531

suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary

7 13013

I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)

Relq,

5 9821

What is the default value of CHAR type?

Bosch,

3 10221

If CPU is very slow What can u do to speed up?

1 4674

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 4105

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.

1 1820

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

1 2094

how many tupples can insert in 1 second in sql

1 5770

i have marks in table,how to find total?

1 5421

what is difference between nchar and char in Sql server ?

3 8390

How can we write or define DDL statements in Sql server and DML statements?

3 6646

How many memory layers are in the shared pool?

3 7912

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

IBM,

2 11492

Un-Answered Questions { Databases }

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2346

How to write a left outer join with the where clause in oracle?

1149

what is the difference between openrowset and openquery?

1186

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2291

What is self contained sub query?

1138

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2307

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

2207

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1946

What are the different SQL Server Versions you have worked on?

1075

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1895

What are the steps in creating a database?

1004

Why we use the openxml clause?

1066

How do I start sql server 2017?

1010

What are the kinds of subquery?

1098

Is inner join faster than left join?

1273

For More Un-Answered { Databases } Questions Click Here