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 9203

What is your daily office routine?

Data Vision,

1792

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

Cap Gemini, Data Vision,

2 7640

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

TCS,

1 2743

How did you export data from database to excel file.

TCS,

1 4624

Difference between global and parameter variables?

TCS,

1441

What is extent clause in table space?

TCS,

1 2755

What is the use of time stamp in select statement?

TCS,

1 3027

Which data type doesn't allow null data type?

TCS,

6 7506

What is window clause?

TCS,

1 3358

Can you alter start with clause?

TCS,

1 3799

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 9214

write a query to find 4th max salary

 7 6044

How global cursor can be declare with dynamic trigger ?

 1738

how view used for security purposes?

Glam India,

3 4498

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

605

What is mutating error?

502

What is sqlite format?

618

what is heap table? : Sql dba

596

Can we insert data into materialized view?

495




What does the argument [or replace] do?

566

Define a temp table?

542

What are the popular database management systems in the it industry?

550

How do I view tables in mysql?

532

How to display the current date in sql?

587

What is a dirty read sql?

468

Why do we use %rowtype & %type in plsql?

589

How to make a copy values from one column to another in sql?

561

What is triggering circuit?

588

how to concatenate two character strings? : Sql dba

542

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