SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

how to find 5th row ?

10 17313

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 23702

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 11366

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

IBM, TCS,

2 8815

write a query find which rows of a table is updated on 2 days before?

TCS,

3 9105

how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?

TCS,

4 12039

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 80680

How can I create a table from another table without copying any values from the old table?

8 13190

in table there r so many rows write a query which two rows r updated last two day befor?

Exilant,

3 10203

How to remove duplicate rows from a table?.

3 8281

There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

Cognizant,

1 6546

Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

IBM, Metric Stream,

4 12724

I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu

Adea,

4 6801

what is data integrity

Fidelity, TCS,

3 12281

what is sql optimization

Fidelity,

1 9343

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What does t sql mean?

940

what is meant by nl2br()? : Sql dba

1031

what is the bond code in materialized view?

2999

Explain two easy sql optimizations.

1008

What are the types of triggers in sql?

1087

What is bind variable in pl sql?

1051

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

969

Why do we go for stored procedures?

1050

What are the popular database management systems in the it industry?

995

What is the difference between rollback and rollback to statements?

1060

What is the usage of nvl function?

1031

What is sql injection vulnerability?

940

Does sql backup shrink transaction log?

977

How do you update a sql procedure?

1022

What is a constraint?

1013

For More Un-Answered { SQL PLSQL } Questions Click Here