| Interview Questions [message #124049] |
Thu, 16 June 2005 01:09  |
ramvenky
Messages: 5
Registered: May 2005
|
Junior Member |
|
|
Respected Sir/Madam,
I want to know those Question's Answer.Please send immediately as soon as possible.
1.For a DDL statement, which of the following is true
a. A DDL statement is preceded and followed by commit.
b. All the DML statements gets committed even when u get an error after writing DDL statement.
c. Both a & b
d. None of the above.
2. Which of the following is true for update clause?
a. We can update two base tables simultaneously
b. U can use a subquery in SET clause of the UPDATE statement.
c. Both a & b
d. None of the above
3. Which of the following is true for delete?
a. Delete statement can be given without writing where clause.
b. We can delete two tables simultaneously
c. Both a & b
d. None of the above
4. In oracle 7 which of the following is true about manipulating the view
a. View based on two base tables can be manipulated
b. View having a column which contain operation can be manipulated
c. Both a & b
d. None of the above
5. In oracle 8 which of the following is true about manipulating the view
a. View based on two base tables can be manipulated
b. View having a column which contain operation can be manipulated
c. Both a & b
d. None of the above
6. Which of the following is true about packages
a. We can write a procedure in package body which has not been specified in package specification.
b. We cannot write a procedure in package body which has not been specified in package specification.
c. Both a & b
d. None of the above.
7. Which of the following is true about outer joins
a. The outer join symbol should be present on any one side of the join.
b. The outer join symbol may be present on both the sides of the join
c. The outer join return the rows from the two tables that donot have matching records in other table.
d. None of the above
8. What does OFA stands for ?
a. Oracle Flexible Architecture
b. Oracle Financials Applications
c. Optimal Flexible Architecture
d. None of the above
9. If you want to restrict the user, to enter the same values that has been stored in other table then what constraint do u use?
a. Entity integrity
b. Referential Integrity
c. Both a & b
d. None of the above
|
|
|
|
| Re: Interview Questions [message #127780 is a reply to message #124049] |
Wed, 13 July 2005 05:29  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
| Originally reported by ramvenky |
Why still you didn't answer my Interview Questions
|
You don't go reporting messages to get attention. The moderators already have enough to do ( aside a daytime job ). Why the extra whining?
Read the sticky in the newbie forum for tips and tricks.
And one thing about jobs: it's not only the interview. If it takes you over a month to get answers to these 8 simple questions I would consider a career change.
1. http://www.orafaq.com/forum/m/113111/43055
2. check the SQL reference for 'UPDATE'
3. check the SQL reference for 'DELETE'
4. Not applicable: Oracle 7 is desupported for eons now. Back to reality.
5. Not applicable: Oracle 8 is desupported for eons now. Back to reality.
6. Try it. Please do.
7. check the SQL reference for 'joins'
8. GOOGLE oracle + OFA
MHE
[Updated on: Mon, 19 June 2006 01:21] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
