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 7461

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 4576

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 6149

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 5108

What is the diff between Dynamic queries and static queries

CGG, ICS Integrated Computer Solutions,

1 10934

Store procedure will return a value?

eMids,

4 11369

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

HCL,

2 5123

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

Apollo,

3 8365

wht's the differece between sqlserver05 and sqlserver2000

3 5821

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?

2207

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

HCL, Virtusa,

7 14418

what is meant by deafult in sql server?

2 5791

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

Virtusa,

16 30713

any one can explain Self mapping Delegation Remote Credentials

1 5354

wht is the difference between sqlaserver2000 and 2005

ABC, IBM,

1 5986

Un-Answered Questions { Databases }

what authentication modes does sql server support? : Sql server database administration

1127

What is the need of merge statement?

1052

How we can get distinct columns values in mysql?

1093

How do I start microsoft access on my computer?

885

How to avoid duplicate records in a query?

1019

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1026

What are triggers? Why do we use them? Diff types of triggers? What are magic tables?

963

Why mysql is so popular?

981

Does mysql scale well?

905

how node connect with cpu?

2146

What is co-related sub query?

1042

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2114

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2162

How does a database partition work?

1011

How do we create privileges in oracle?

1063

For More Un-Answered { Databases } Questions Click Here