|
Question |
Rating |
View Answer |
|
How do you make a database read-only? |
|
View Answer |
|
Which environment variable or registry entry variable is used to represent the instance name? |
|
View Answer |
|
What packages are associated with the LogMiner utility? |
|
View Answer |
|
What is a cursor ? Why Cursor is required ? |
|
View Answer |
|
Which command is used to enable the auto-extensible feature for a file, if the file is already part of a tablespace? |
|
View Answer |
|
13. Which line in the following code has an error? 1. ALTER TABEL MY_TABLE 2. STORAGE ( 3. MINEXTENTS 4 4. NEXT 512K) 5. NOLOGGING;
|
|
View Answer |
|
If you have two redo log groups with four members each, how many disks does Oracle recommend to keep the redo log files? |
|
View Answer |
|
What is the difference between locks, latches, enqueues and semaphores? |
|
View Answer |
|
What is the maximum number of profiles that can be assigned to a user?
|
|
View Answer |
|
Explain about stacked canvas views? |
|
View Answer |
|
what is place holder column? where we can use other than formula column?
|
|
View Answer |
|
List out differences between Oracle Server 9i and Oracle Server 10g.
|
|
View Answer |
|
What is SGA? |
|
View Answer |
|
Which view has information about users who are ghranted SYSDBA or SYSOPER privilege? |
|
View Answer |
|
Why query fails sometimes ? |
|
View Answer |
|
Querying which view will show whether automatic archiving is enabled? |
|
View Answer |
|
18. How do you enable a role?
a. ALTER ROLE b. ALTER USER c. SET ROLE d. ALTER SESSION
|
|
View Answer |
|
How to define Data Block size ? |
|
View Answer |
|
What are various joins used while writing SUBQUERIES? |
|
View Answer |
|
What is Distributed database ? |
|
View Answer |