sql questions -answer it [message #158333] |
Fri, 10 February 2006 00:39 |
joemelvin
Messages: 10 Registered: August 2005 Location: tamil nadu
|
Junior Member |
|
|
hello all
can u please answer the below questions -- - so that it will much usefull to me
QUESTIONS
1. How do u mask the user from entering irrelevant data ?
a. Synonym
b. View
c. Index
d. sequence
2. 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
3 -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
4. 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
5. What is the size of Varchar in Oracle 8.0 ?
a. 2000
b. 4000
c. 254
d. none of the above
6. What is the size of Varchar in Oracle 7.0 ?
a. 2000
b. 4000
c. 254
d. none of the above
7. The default value the lpad function takes is
a. a space (¡§ ¡§)
b. an asterisk
c. The default value is not optional
d. None of the above
8. The no. of columns that may be used as composite primary key in oracle 8
a. 8
b. 16
c. 32
d. none of the above
9. which of the following is true about add_months
a. we can pass a numerical value in first parameter
b. we can pass a negative value in second parameter
c. Both a & b
d. None of the above
10. The latest date that can be stored in oracle 8
a. 31st Dec 4012 A.D
b. 31st Dec 4011 A.D
c. Dec 31st ,9999
d. None of the above.
11. What happens when the first date is greater than the second date that is passed to the months_between function in oracle 8.
a. It gives an error
b. It gives a negative value
c. None of the above
12. Regarding the Summary query which of the following is true
a. The order of the base column list in the select statement should be same in the Group by clause.
b. The order of the base column list in the select statement need not be same in the Group by clause.
c. None of the above
13. How do u mask the user from entering irrelevant data ?
a. Synonym
b. View
c. Index
d. sequence
|
|
|
Re: sql questions -answer it [message #158553 is a reply to message #158333] |
Mon, 13 February 2006 02:40 |
|
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
Look here.
You didn't even bother to look. Did you?
Anyway,
you have an outdated question sheet: both Oracle 7 and Oracle 8 are desupported.
Furthermore, most answers can be found in the manuals. Look in the Sticky in the Newbie forum. It's the first thread there.
MHE
|
|
|