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 6459

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

2037

query optmization techniques and quwry analyser+projects+ppts

2426

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 4503

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

10 12585

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

1 3894

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 8053

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.........

2111

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 7912

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 4967

What is the difference between local table and global table

CarrizalSoft Technologies, Polaris,

1 7483

how to find out second largest value in the table

8 9610

how to find out largest value in a table

2 4868

how to insert the image in table

2 6941

Un-Answered Questions { Databases }

Why is sql better than hql?

1002

How to start and end transact-sql statements?

1037

Can we enter data in a table in design view?

974

How do I clean up sql server transaction log?

1075

How do I connect to postgresql database using pgadmin?

851

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2331

How to reorder the table columns (fields)?

1098

What is the maximum number of index per table?

1078

How to concatenate two text values in oracle?

1118

What is the difference between an index and a unique index?

1008

What is data independence and also explain its types?

910

Where is pg_hba conf?

792

Do you know clustered and non-clustered index?

984

What are the types of sql server?

1060

Name some of the open source software that you can use in alternative to SSR?

161

For More Un-Answered { Databases } Questions Click Here