adspace


  1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?

Zensar,

5 8941

what is difference between user managed backup and rman backup?

CTS,

1 17082

what is the role of dip user in our database?

 1 2521

pl/sql testing means what ...... explain process how to find pl/sql bugs

Zensar,

1 5748

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

 1 2830

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

 1 2232

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

Microsoft, TCS, Techastrum,

3 8564

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

Adsys, Cap Gemini,

15 22226

Dept wise avrage salary

HCL, IBM, TCS,

2 6260

I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.

 1 4093

How do I apply a custom Ribbon after a user logs into the database? I want to use a different ribbon based upon the users level of security. I have 3 levels.

 1 2482

in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query

 1 3364

We have a CURSOR then we need BULK COLLECT?

 1 3763

What is the Difference beween sql server 2005 and sql server 2008

CMC, Hitech,

3 7108

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

 1 2422

Un-Answered Questions { Databases }

Is microsoft getting rid of access?

897

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2103

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

1060

How to define array in mongoose schema?

86

What is the current version of sql?

1108

what are all the common sql function? : Sql dba

1146

What are different types of constraints?

1009

How to rebuild the master database?

1176

Design database draw er diagram for a certain scenario ?

4670

How efficient you are in oracle and SQL server?

1270

What is the primary use of the model database?

1163

What are the types of database explain each of them briefly?

1074

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2189

what are the advantages of sql ? : Sql dba

1155

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1867

For More Un-Answered { Databases } Questions Click Here