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

How can we overcome recursive triggers in SQL?

iFlex,

1 7803

how to create user in sql and how to set password for that?

3 7955

what eliminate duplicate without using roenum and not

Matrix,

5 7099

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?

HCL,

3 8623

How One can easily select all even, odd, or Nth rows from a table using SQL queries?

4 17133

What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.

Polaris,

5 8200

What is a REF CURSOR? Compare strong and week ref cursor types.

6 23943

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS

Polaris,

7 13180

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

Virtusa,

2053

write a qurey for finding the length of the sting.

Infosys, TCS,

5 9108

how to create a database in oracle?

3 4687

In a package if we have 10 procedures or functions,How to know which will execute first?

Sollet Soft,

1 5748

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

Oracle, TCS,

13 14717

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

IBM,

2 6363

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

1584


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

Is sql between inclusive?

111


What is the difference between an inner join and an outer join?

113


What is sql lookup?

100


When you have to use a default "rollback to" savepoint of plvlog?

175


Does sql require a server?

112






how many sql ddl commands are supported by 'mysql'? : Sql dba

132


Can we create view in stored procedure?

111


What are the different types of database management systems?

141


State few characteristics of pl/sql?

137


What is trigger in pl sql?

107


What is exception? What are the types of exceptions?

151


what are all the common sql function? : Sql dba

135


Why do we use procedures in pl sql?

103


What is self-join and what is the requirement of self-join?

171


What are inner and outer joins examples of both?

114