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 17598

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 24170

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 11614

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

IBM, TCS,

2 8943

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

TCS,

3 9223

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 12226

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

10 81096

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

8 13468

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

Exilant,

3 10343

How to remove duplicate rows from a table?.

3 8445

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 6615

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 12938

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 6987

what is data integrity

Fidelity, TCS,

3 12440

what is sql optimization

Fidelity,

1 9472

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How does sql profiler work?

1065

What happens when a trigger is associated to a view?

970

How do I count rows in sql?

1048

What are the datatypes available in pl/sql ?

1149

how to enter characters as hex numbers? : Sql dba

1102

what is recursive stored procedure? : Sql dba

1026

What are the basic sql commands?

1138

What does dml mean?

1041

Explain how can you save or place your msg in a table?

1074

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

1093

What are the two parts of design view?

1062

What is dense_rank in sql?

1036

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2609

What is cartesian join in sql?

1193

Is primary key is clustered index?

1039

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