| Other Oracle AllOther Interview Questions |
| |
| Question |
Asked @ |
Answers |
| |
| How do you switch from an init.ora file to a spfile? |
Wipro | 1 |
| What does coalescing a tablespace do? |
| 2 |
| What is index? How many types of indexes? |
HCL | 2 |
| Explain an ORA-01555 |
| 2 |
| You have just compiled a PL/SQL package but got errors, how
would you view the errors? |
| 1 |
| What type of index should you use on a fact table? |
| 1 |
| the user should know to which database he is connected
currently in oracle |
| 1 |
| When creating a user, what permissions must you grant to
allow them to connect to the database? |
| 4 |
| Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to
each. |
HCL | 1 |
| When a user process fails, what background process cleans
up after it? |
| 1 |
| what is correlated subquery
|
| 3 |
| Why we are using primary key and foreign key in oracle and
difference between primary key and foreign key? |
| 1 |
| |
| For more Oracle AllOther Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
