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

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

IBM, TCS,

2 8976

What is the difference between RBBMS & DBMS?

4 9333

How to get last system shutdown time in Sql server when restarted system?

1 9174

How maney row would be print after join if A table have 100 rows and B table have 50 rows...

Hewitt,

9 12181

How will you collect the date from current date to last older 6 days date in sql server 2005

4 6417

how we can store the value like that 001,003,023 etc in sql server 2005

7 9643

Selet all the data from table where last name is n of employee

2 5432

THE MAIN CONCEPT OF PROGRAMMIN TYPE?

1 4391

How to find the latest updated value in a table without sending any parameters to that query

2 5711

write a query find which rows of a table is updated on 2 days before?

TCS,

3 9253

how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?

TCS,

4 12285

how to improve the speed of SQL database server and how to avoid dead lock?

TCS,

1 6216

the process of adding a cpu in sql server is called..?

TCS,

2 5596

Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?

1 2572

Excellent job opening with one of our client in Hyderabad About Client : It is an American e-commerce company based in Seattle, Washington, a leading online retailer of products that inform, educate, entertain and inspire.

1 3147

Un-Answered Questions { Databases }

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

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

1225

This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

2545

What is clustered index

1069

How to convert character strings into numeric values?

1167

What are the source of constraints?

994

How to connect php with different port numbers?

1159

what are aggregate and scalar functions? : Sql dba

1116

what is collation? : Sql dba

1211

What is the current version of sql?

1080

What are the different types of subquery?

1222

what is the difference between openrowset and openquery?

1174

Is microsoft getting rid of access?

877

How many concurrent programs you have customized, can you name some of them?

What are the kinds of subquery?

1087

For More Un-Answered { Databases } Questions Click Here