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


Databases Interview Questions
Questions Answers Views Company eMail

Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')

 2 6762

I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access

 4 4806

I'm need to prepare Month Over Month Sales Growth report. Is there any function available in OBIEE to perform this task.

Infosys,

1766

how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?

Infosys,

1 3479

how to produce numbers from 1 to 10 using dual table

Genpact,

4 9380

I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

 1649

two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)

2 4055

how may join possible between (requisition with purchase order)

 1695

I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????

 1 3941

default triggers available for reports

 1757

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

 1896

i want run a sql query query? which phases are run in a back ground? pls tell me the answer

 1 4533

what is Equity join?

ADP,

2 5807

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

TCS,

1 8048

How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?

Pitney Bowes,

1 5319

Un-Answered Questions { Databases }

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

552

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

901

Define Primary key, Foreign key, Weak key in your own words.

2687

how to display nth highest salary from a table in a mysql query? : Mysql dba

574

What is field in database give an example?

436




Explain index covering? List its merits.

495

What is self contained scalar sub query?

533

Explain top-n analysis in DBMS.

1042

What is difference between mysql_connect and mysql_pconnect?

552

Tell me step by step to enable Journalization?

319

How to pipe multiline string to isqi?

1

Explain optimistic and pessimistic concurrency?

539

Data structure used to implements a menu:

627

What is the difference between osql and query analyzer?

541

How to run sql server 2005 books online on your local system?

512

For More Un-Answered { Databases } Questions Click Here