|
Question |
Rating |
View Answer |
|
What is Trigger at one Line? |
|
View Answer |
|
What is pseudo columns ? Name them? |
|
View Answer |
|
Which utility would you use to refresh the test table with production data? a. SQL*Loader conventional path b. SQL * Loader direct path c. Export/import d. SQL * Plus direct-load insert
|
|
View Answer |
|
What is mouse navigate property of button? |
|
View Answer |
|
What is OCI. What are its uses? |
|
View Answer |
|
What is a datafile? |
|
View Answer |
|
If you are updating one row in a table using the ROWID in the WHERE clause (assume that the row is not already in the buffer cache), what will be the minimum amount of information read to the database buffer cache? |
|
View Answer |
|
I want to know that..is there any special way to login into oracle SQL*PLUS Editor directly..Rather than every time u have enter user,password,host string...what should i do with login.sql script.. i Put it in /Bin directory..but not working..
|
|
View Answer |
|
User JAMES has a table named JOBS created on the tablespace USERS. When you issue the following statement, what effect will it have on the JOBS table?
ALTER USER JAMES QUOTA 0 ON USERS;
a. No more rows can be added to the JOBS table b. No blocks can be allocated to the JOBS table c. No new extents can be allocated to the JOBS table d. The table JOBS cannot be accessed
|
|
View Answer |
|
What is the content view and stacked view? |
|
View Answer |
|
Which background process is responsible for writing the dirty buffers to the database files? |
|
View Answer |
|
Using SQL*Plus, list two options which show the value of the parameter DB_BLOCK_SIZE? |
|
View Answer |
|
What is an Oracle view? |
|
View Answer |
|
How are extents allocated to a segment? |
|
View Answer |
|
What is Two-Phase Commit ? |
|
View Answer |
|
What are the Various Master and Detail Relation ships? |
|
View Answer |
|
What is OLE automation ? |
|
View Answer |
|
What are different types of modules available in oracle form? |
|
View Answer |
|
How to define data block size? |
|
View Answer |
|
What is Full Backup ? |
|
View Answer |