Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Regarding joins what are the differences you observed in oracle 9i and sql server?

Choice Solutions,

3 6175

What is a bitmap index?

Choice Solutions, Infosys,

4 21331

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 5580

What are Lexical Parameters.How They are used in Reports 6i

eicc,

2 29626

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id

CGCI,

8 12794

What is the difference between RDBMS and DBMS?

Practical Viva Questions, Sapient, Stag Computers,

20 69616

what is purge command explain about oracle performance tuning

Accenture, eCentric Solutions,

2 24066

what is global table

iFlex,

7 12022

What is the use of cursor ? how cursor allocate context area for executing the sql statement?

HCL,

4 13886

what is bulk bind

TCS,

4 12794

what is mean by forward declaration and where we'll use it.

TCS,

4 22946

what is the order of pre-defined exceptions.

TCS,

6 13904

Can a table have two primary keys?

HCL, MetaCube,

44 79561

What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

Hexaware,

4 10113

check whether all the emp numbers are indeed unique.

6 14133


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Are stored procedures faster than dynamic sql?

376


Why we use stored procedure instead of query?

364


Can a select statement fire a trigger?

483


How many sql commands are there?

423


what is 'mysqld'? : Sql dba

371






Mention what are the benefits of pl/sql packages?

395


Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

1563


what is sp_pkeys? : Transact sql

448


What is the maximum number of triggers, you can apply on a single table?

384


How do you pronounce sql?

372


what is dbms? : Sql dba

374


What is the difference between inner join and natural join?

360


How to pronounce postgresql?

415


What is the difference between sql and mysql?

405


What is sql architecture?

411