|
Question |
Rating |
View Answer |
|
What is Table ? |
|
View Answer |
|
What will happen if ARCn could not write to a mandatory archive destination? |
|
View Answer |
|
How does one coalesce free space ? |
|
View Answer |
|
What are the factors causing the reparsing of SQL statements in SGA? |
|
View Answer |
|
What is the best method to rename a control file? |
|
View Answer |
|
What is meant by recursive hints ? |
|
View Answer |
|
What are the use of Roles ? |
|
View Answer |
|
What is the purpose of a cluster? |
|
View Answer |
|
Which background process is not started by default when you start up the Oracle instance? |
|
View Answer |
|
what are phantom rows? |
|
View Answer |
|
What is the difference between candidate key, unique key and primary key? |
|
View Answer |
|
What are the attributes of Cursor? |
|
View Answer |
|
20. Which command is used to define CONNECT and RESOURCE as the default roles for user JAMES?
a. ALTER USER b. ALTER ROLE c. SET ROLE d. SET PRIVILEGE
|
|
View Answer |
|
When will the data in the snapshot log be used? |
|
View Answer |
|
2. Which command is used to assign a profile to an existing use? a. ALTER PROFILE b. ALTER USER c. SET PROFILE d. The profile should be specified when creating the user; it cannot be changed.
|
|
View Answer |
|
What is the difference between SHOW_EDITOR and EDIT_TEXTITEM? |
|
View Answer |
|
Name the stages of processing a DML statement. What stages are part of processing a query? |
|
View Answer |
|
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
|
|
View Answer |
|
How does one do off-line database backups? |
|
View Answer |
|
What are savepoint mode and cursor mode properties? |
|
View Answer |