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

which one will take 1st priority in case of insert statement and select statement???

HCL,

2 6469

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

2043

query optmization techniques and quwry analyser+projects+ppts

2432

Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz

2 4512

how to find the n'th highest salary from emp ?

10 12608

Is it possible to update AS400 database record while reading it with no lock

1 3900

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

Aptech,

5 8067

what is software?

1 4909

i have table as source table and flat file as target i need yo perform some logic in loading the data. is it posible? and one more thing the no of fields in source is 200+ and for target is 30+ how i can map them.........

2114

Which one of the following is the correct way to select all columns and all rows from "vtable"? Choice 1 SELECT FROM vtable SELF JOIN vtable Choice 2 SELECT ALL COLUMNS FROM vtable WHERE ALL ROWS = * Choice 3 SELECT EVERYTHING FROM vtable Choice 4 SELECT vtable.* WHERE vtable = vtable Choice 5 SELECT * FROM vtable WHERE 1 = 1

3 7917

How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

247Customer,

2 4976

What is the difference between local table and global table

CarrizalSoft Technologies, Polaris,

1 7487

how to find out second largest value in the table

8 9628

how to find out largest value in a table

2 4877

how to insert the image in table

2 6949

Un-Answered Questions { Databases }

What is a two tier wage system?

832

What is report snapshot in ssrs?

276

What is row locking in mysql?

981

How to display nth highest salary from a table in a mysql query?

1003

Is there a combination of "like" and "in" in sql?

1081

How do I create an extended event in sql server?

964

What is sql injection and why is it a problem? : sql server security

1147

Describe the three levels of data abstraction?

886

What is pl sql record in oracle?

1049

How do you display the list of all collections of current database?

What are the main features of a database?

1046

How do I completely remove mysql from windows?

986

How to convert binary strings into integers in ms sql server?

1039

Why is cluster verification utility so important in oracle rac?

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

111

For More Un-Answered { Databases } Questions Click Here