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

what is host string in sql plus? how does it related to database?

1 6503

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 8106

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

TCS,

3 7926

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

Wells Fargo,

11 21002

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

Value Labs,

2 5938

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 4759

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 7675

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

1 3601

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

CTS,

1 5402

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,

2353

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

IBM,

1 4653

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 8742

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

TCS,

1 6444

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

3 5033

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?)

1891

Un-Answered Questions { Databases }

How many types of literals are available in pl sql?

1123

What's the difference between file and database? Can files qualify as a database?

972

What are the three main types of models?

900

How do database connections work?

952

Is mongodb distributed database?

Is mongodb good for transactional?

What is a hint?

1002

What is match command in neo4j and why it is used?

HOW TO SPOT AHIERARCHY?

2301

How do you create a data source?

918

What is a cursor in oracle?

1182

Which are the storage engines used by mongodb?

What is sql server used for?

1058

Explain the purpose of %type and %rowtype data types?

936

Explain the properties of a relational table?

1027

For More Un-Answered { Databases } Questions Click Here