Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
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 9927

What is your daily office routine?

Data Vision,

2006

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

Cap Gemini, Data Vision,

2 8292

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

TCS,

1 3068

How did you export data from database to excel file.

TCS,

1 5072

Difference between global and parameter variables?

TCS,

1690

What is extent clause in table space?

TCS,

1 3109

What is the use of time stamp in select statement?

TCS,

1 3419

Which data type doesn't allow null data type?

TCS,

6 8416

What is window clause?

TCS,

1 3815

Can you alter start with clause?

TCS,

1 4181

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 9885

write a query to find 4th max salary

 7 6983

How global cursor can be declare with dynamic trigger ?

 1968

how view used for security purposes?

Glam India,

3 5084

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How to select all records from the table?

841

Can a composite key be null?

738

How do I debug a stored procedure?

856

What is %rowtype in pl sql?

727

What is the use of sql trace?

721

Explain how exception handling is done in advance pl/sql?

757

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

728

What is sql scripting?

772

How does sql store data?

687

What are the different dcl commands in sql?

801

Who is the owner of mysql database?

781

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1025

Why indexing is needed?

761

What is cursor explain with example?

752

what are the advantages and disadvantages of views in a database? : Sql dba

795

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