| Other Oracle AllOther Interview Questions |
| |
| Question |
Asked @ |
Answers |
| |
| what is different between inline query,subquery& corelated
query? |
Quest | 8 |
| whats the difference between join command and Cartesian
product using example? |
| 1 |
| HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN
KEY? |
| 4 |
| what is the querry to get first 10 records from the emp
table?(emp no is the primary key) |
Verizon | 4 |
| Can we get the deleted Record again if the delete
transaction has been committed. |
| 3 |
| Should you take the backup of Logfiles if the database is
running in ARCHIVELOG mode? |
| 4 |
| How client makes connection with server in client/server
architecture? |
CA | 1 |
| What command would you use to encrypt a PL/SQL application? |
| 1 |
| What command would you use to create a backup control file? |
| 1 |
| 1.In a table Gender is a column in that male and female are
the two data.In a single statement i have to modify all male
to female and all female to male vice versa.
2.In a single query i need the count of male data,count of
female and total count |
HP | 2 |
| Can anybody tell which is the best training institute for
learning Oracle in chennai...? And i also i want placement
assurance |
| 1 |
| How can you gather statistics on a table? |
| 2 |
| |
| For more Oracle AllOther Interview Questions Click Here |