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

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

Saama Tech, TCS,

4 7625

What is your daily office routine?

Data Vision,

1364

which will default fire firstĀ  statement level trigger or row level trigger

Cap Gemini, Data Vision,

2 5547

Maximum how many triggers can we use in trigger and How to find out how many records it fetched.

TCS,

1 1941

How did you export data from database to excel file.

TCS,

1 3654

Difference between global and parameter variables?

TCS,

966

What is extent clause in table space?

TCS,

1 1860

What is the use of time stamp in select statement?

TCS,

1 2184

Which data type doesn't allow null data type?

TCS,

6 5463

What is window clause?

TCS,

1 2543

Can you alter start with clause?

TCS,

1 2975

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

JPMorgan Chase,

3 6319

write a query to find 4th max salary

7 3999

How global cursor can be declare with dynamic trigger ?

1228

how view used for security purposes?

Glam India,

3 3299


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

what is top in tsql? : Transact sql

130


How do you copy a table in sql?

110


How do you update f as m and m as f from the below table testtable?

266


How do we use distinct statement? What is its use?

158


discuss about myisam key cache. : Sql dba

145






Explain ttitle and btitle.

181


How do sql databases work?

117


What does closing a cursor do?

214


mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

146


What is a string data type in sql?

113


What is sap sql?

111


what is data integrity? : Sql dba

146


What is error ora-12154: tns:could not resolve the connect identifier specified?

184


Is postgresql a nosql database?

101


How to process query result in pl/sql?

145