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 8101

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

TCS,

3 7924

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

Wells Fargo,

11 21001

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

Value Labs,

2 5937

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 4758

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 7674

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

1 3600

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 4652

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 8740

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

TCS,

1 6443

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

3 5031

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

1890

Un-Answered Questions { Databases }

What are sql objects?

1085

How many control files should you have? Where should they be located?

585

What is the insert?

899

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2370

What are snapshots? What are materialized views & where do we use them? What is a materialized view?

In a distributed database system, can we execute two queries simultaneously?

1098

What are the different authentication modes in sql server? How can it be changed?

1097

What are the restraints imposed on the table design by a merge replication?

1040

what is the use of double ampersand (&&) in sql queries?

1178

Mention in rac what files should be created on shared storage?

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2446

what are the differences between char and varchar? : Sql dba

1077

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1006

What is triggers and its types?

1011

Write a SQL queries on Self Join and Inner Join.

1050

For More Un-Answered { Databases } Questions Click Here