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 is host string in sql plus? how does it related to database?

1 6592

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 8277

Query processing is slow(eg select query)how will u solve that

TCS,

3 8051

I want to know last five transactions or records from emp table, from now?

Wells Fargo,

11 21349

how can we write trigger in trigger???????? can we write one trigger on two table???

Value Labs,

2 6039

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 4826

Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.

JPMorgan Chase,

4 7820

What is the maximun sixes of .mdf in sql server 2005

1 3673

why do we give pctfree and pctused in create table statement?

CTS,

1 5486

i want to know rdbms certification details and syallabus and for whom i contact for rdbms certification in bangalore i need answer very urgent please mail to aniltelkar50@gmail.com please as soon as possible

Canara Bank,

2391

i want to know real time experience on oracle dba anybody help me please mail me aniltelkar50@gmail.com

IBM,

1 4758

i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID

IBM,

7 8955

counting the no.of characters occurs in a string by using pl/sql function

TCS,

1 6536

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 5142

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1943

Un-Answered Questions { Databases }

For synchronizing the logins from lower version to higher version, just take the 11.9.2 syslogins structure, go to 12.5 higher version server?

857

what systems can odi extract and load data into?

659

What is a checkpoint and When does it occur?

819

What is the importance of sqlcode and sqlerrm?

1394

How to display employee records who gets more salary than the average salary in the department?

1128

What does count (*) mean in sql?

1658

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2320

What are the difference between “where” and “having” clause in sql server?

1135

You need to multiply all values of a single column. How would you do that?

927

What is Cross Join and in which scenario do we use Cross Join?

1064

What is built-in function?

1064

What is the user of Primary key?

1032

What exactly does a dba do?

624

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

1036

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1153

For More Un-Answered { Databases } Questions Click Here