you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

1048

Explain oracle instance.

1176

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

1695

What are the 3 modes of parameter?

1154

Explain how to use transactions efficiently : transact sql

980

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2355

What is clustered index sql?

984

What is the command or the option available in postgresql that can be used to retrieve the next SERIAL value from the sequence object?

1464

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1030

Explain oracle’s server parameter file.

992

Is postgres is free?

813

Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

4672

What is difference between index seek vs. Index scan?

1155

How can a single instance environment be converted into rac environment and how will they be different?

1

What is pragma serially_reusable and why is it used?

866