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

How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

1 3772

If we shrink the Databse and Files, how much size is decreased?

TCS,

1 3761

What will you do If the low Performance occurs?

2 4228

Explain Capacity planning to create a database? and how to monitor it?

4207

hello..... i am an comp science engineering graduate planning to do ORACLE certification in PLSQL 9i. just wanted to know whats the possibility getting job is their openings???? is it worth doin that course n certification

1 2726

In PHPmysql language how can we update our previous information.when update form open then we get our previous information in textbox,checkbox,selct,radio button.How can we show the information in checkbox,select menu,radio button which is available in database?

2134

what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 8294

how we can use a database with php.

HCL, IT Solution,

2 4225

How retrieve field names from the table in SQL through JAVA code?

1915

what is the maximum size of a row in sql server 2000 and 2005

2 4912

what is bit data type? and what are the information that can be stored inside a bit column?

2 4439

what are default? Is there a column to which a default cant be bound?

1 3355

what purpose does OPENXML clause have in sql server stored procedure?

1 5606

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

1 3744

can we create relastionship bet 2 tables in ms-access

2 6155

Un-Answered Questions { Databases }

What is oracle rownum?

958

What is the current limitation of the size of SQL Azure DB?

127

What is a performance monitor?

977

Difference between CHAR and VARCHAR?

1107

How do I start sql server agent automatically?

976

how to start mysql server? : Sql dba

1206

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

884

Does view contain data?

1040

How do you declare a constant?

965

What are the reporting services components?

144

Differentiate between % rowtype and type record.

1312

How many clustered indexes can you have?

975

How to create an multi-statement table-valued function?

1004

Difference between connected and disconnected database in .net with sql server?

1104

Explain full-text indexing?

993

For More Un-Answered { Databases } Questions Click Here