If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?

291

What is a system tablespace?

586

What is the difference between count (*), count (expression), count (distinct expression)?

547

Is oracle a language?

511

What is background process in Oracle?

620

What is difference between co-related sub query and nested sub query?

291

what are actual and formal parameters?

585

 What are the oracle DML commands possible through an update strategy?

572

difference between global n context sensitive segments?

2193

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1250

What do you understand by lov and how can it be used?

569

Difference between oracle's plus (+) notation and ansi join notation?

564

What is the difference between substr and instr?

511

List out the types of joins.

583

Components of Oracle Data Integrator?

255