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

I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?

Philips,

2 7437

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

Techno Solutions,

1 4564

I have a website that allows customers to browse and place orders for certain products. I have 2 tables; Customers and Orders. The Customers table holds the customer records and the Orders table holds the orders placed by the customer. Both tables are tied based on the field Cust_ID. Example of the data is shown below: Cust_ID Cust_Name Cust_ID Product Amount Order_Date 1001 John Tan 1001 P-5211 $120.00 2/13/2006 1002 Michael Wong 1001 K-1428 $88.90 1/11/2006 1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006 1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006 Write a single SQL statement that extracts all purchase records with the following criteria: 1. Customer names starting with “M” only. 2. Orders placed within the current month only. 3. Amount does not exceed $100.00 The list must be sorted by order date with the latest order showing on top.

Techno Solutions,

3 6116

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

Techno Solutions,

2 5099

What is the diff between Dynamic queries and static queries

CGG, ICS Integrated Computer Solutions,

1 10921

Store procedure will return a value?

eMids,

4 11346

Hi..here i would like to know the Backup and Restore models?

HCL,

2 5101

wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure

Apollo,

3 8348

wht's the differece between sqlserver05 and sqlserver2000

3 5807

1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?

2199

how to find number of columns in a table in sql server 2000 and 2005 also

HCL, Virtusa,

7 14367

what is meant by deafult in sql server?

2 5770

how to find number of columns in a table in sql server 2000 and 2005 also

Virtusa,

16 30631

any one can explain Self mapping Delegation Remote Credentials

1 5340

wht is the difference between sqlaserver2000 and 2005

ABC, IBM,

1 5976

Un-Answered Questions { Databases }

what is text? : Sql dba

1075

What are locks in sql?

986

Which profile required to access solution in Designer tool?

592

When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

2224

What happens to indexes if you drop a table?

1172

Can you roll back the ddl statement in a trigger?

983

What is resource governor in sql server?

1008

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

1169

What are the 4 objects in access?

890

How can you retrieve a portion of any column value by using a select query?

924

What is command parameter in ssrs?

164

Describe the difference between homogeneous and heterogeneous distributed database.

1071

what is error ora-03113: end-of-file on communication channel?

1168

Why oracle forms required?

1045

Do you know what is sql injection?

1004

For More Un-Answered { Databases } Questions Click Here