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

Can we call a trigger inside a function and function inside a trigger? Give example.

Metric Stream,

1 14629

There is a table1 with records (1,2,3,4,5,6) and table2 with records (4,5,6,7,8,9).write a query so as to get the result as 1,2,3,4,5,6,7,8,9

RBS,

12 18252

Can we create nonclustered index in a table without creating a clustered index

1 4929

can we insert any row to dual table if i got the permission from DBA

HCL, Tesco,

5 17506

How can we call UDF(User Define Function) using C# code in ASP.net ?

2 6958

what is the difference between delete and truncate?

4 7133

4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10

7 9423

explain the man feature of RDBMS ?

3 5752

Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?

1 4965

I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 10708

how to sort records in sql?

3 7316

Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance

IBM,

10 13188

How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

1 4528

what is the difference between implicit and explicit trigger

Tech Mahindra,

2 23123

can we delete the trigger in a view? if yes why if not why?

Tech Mahindra,

5 15827

Un-Answered Questions { Databases }

What is acid mean in sql server?

1218

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2089

Disadvantages of the indexes?

1205

What are wait types?

1219

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

2297

what is sql server agent? : Sql dba

1162

What kind of problems occurs if we do not implement proper locking strategy?

1479

How to provide default values to function parameters?

1235

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2691

How did mongodb get its name?

What are the source of constraints?

994

How efficient you are in oracle and SQL server?

1234

Why and when do stored procedure recompile?

1042

If a cursor is open, how can we find in a pl/sql block?

1225

How do I start sql server 2017?

1000

For More Un-Answered { Databases } Questions Click Here