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.

1789

What are referenced objects? Explain the importance of referencing.

1

What is oracle full backup?

574

What are the types of Knowledge Modules?

599

Explain the different types of queries created in reports?

1

What happens if you lost a data file?

1038

What is the format trigger?

1

You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?

604

How to export your own schema?

1011

What is the difference between instance recovery and crash recovery?

1

where do u put the report file

2099

Differentiate between pre-select and pre-query?

1115

If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

576

What are the differences between lov and list item?

1074

How can you determine the number of sqlnet users logged in to the unix system?

575