Home » Other » Training & Certification » sql questions -answer it
sql questions -answer it [message #158333] Fri, 10 February 2006 00:39 Go to next message
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 Go to previous message
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
Previous Topic: Oracle Financials- Functional
Next Topic: Looking for Forms/Reports education centre in Hyberabad (India)
Goto Forum:
  


Current Time: Thu Mar 28 08:13:48 CDT 2024