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

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 7619

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 4667

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 6329

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 5218

What is the diff between Dynamic queries and static queries

CGG, ICS Integrated Computer Solutions,

1 11067

Store procedure will return a value?

eMids,

4 11571

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

HCL,

2 5246

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

Apollo,

3 8553

wht's the differece between sqlserver05 and sqlserver2000

3 5990

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?

1 2267

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

HCL, Virtusa,

7 14674

what is meant by deafult in sql server?

2 5924

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

Virtusa,

16 31352

any one can explain Self mapping Delegation Remote Credentials

1 5439

wht is the difference between sqlaserver2000 and 2005

ABC, IBM,

1 6073

Un-Answered Questions { Databases }

how to use regular expression in pattern match conditions? : Sql dba

1108

Is there some bulk load or other way to import a lot of data fast?

931

What versions of clipper does netlib support?

1089

What is self contained sub query?

1138

What kind of problems occurs if we do not implement proper locking strategy?

1495

1. Tell me about your self? 2. Latest Project Introduction? 3. Difference between server jobs and parallel jobs? 4. Seq-Seq Explain its behavior and execution mode and which parallelism technique is used? 5. What is padding characters? 6. Seq-Seq, Seq-Copy-Seq which one is the best and efficient? 7. How many reject links do we have to a transformer? 8. How many reject links to join stage? 9. Difference between join and lookup? 10. How to design PX routine? 11. How can we call job in another job? 12. Difference between batch and sequencer? 13. Which Database is used? 14. What is change capture? Give briefing of that? 15. What is change Code? Explain? 16. How you call UNIX in Ds? 17. How do you call JCL in UNIX? 18. How do you pass the job status of one job to another job? Have designed any job sequencer? 19. How do you find a file in existed directory? 20. How can you call parallel jobs in transformer? 21. Execution of jobs in command line? 22. Tuning of sql queries? 23. What is orchestrating metadata? 24. What are junk dimension? 25. What are the third party tools you are used? 26. What are the system variables you have used?

1909

what are the advantages of sql ? : Sql dba

1140

Can we do dml on views?

1032

What is the current version of postgresql?

1174

List out the different types of locks available in sql server?

1046

How did mongodb get its name?

what are aggregate and scalar functions? : Sql dba

1124

How raid can influence database performance?

1114

Why should you use or avoid select * statements?

1108

What is clustered index

1083

For More Un-Answered { Databases } Questions Click Here