Home » Other » Training & Certification » SQL Interview questions?
SQL Interview questions? [message #137803] Fri, 16 September 2005 19:22 Go to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Sent via PM from samy ganesh:

these are very important sql interview questions...
i want to confirm the answers. so if could spend some
time and confirm the answers that would be great

1. What is the size of Varchar in Oracle 8.0 ?
a. 2000
b. 4000
c. 254
d. none of the above
2. What is the size of Varchar in Oracle 7.0 ?
a. 2000
b. 4000
c. 254
d. none of the above
3. 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
4. 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
5. 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
6. 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.
7. 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
8. 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
9. Regarding the Summary query which of the following is true
a. All the base table columns selected in the select list should be specified in the Group by clause.
b. All the base table columns selected in the select list need not be specified in the Group by clause.
c. None of the above.
10. How do u mask the user from entering irrelevant data ?
a. Synonym
b. View
c. Index
d. sequence
11. What does the length function returns when applied to column of char datatype ?
12. Which of the following is true about the packages ?
a. Package specification should contain return type of a function
b. Package specification need not contain return type of a function
c. Both a & b
d. None of the above
13. If the first parameter is negative, then second parameter
a. need not be negative
b. there is no such restrictions
c. should be positive
d. None of the above.
14. Which of the following is true about procedures
a. The size of the parameter should be mentioned in a procedure.
b. The size of the parameter should not be mentioned in a procedure
c. Both a & b
d. None of the above.
15. ??REFERENCING?? in oracle 8
a. used to mention referential integrity
b. used for creating views
c. there is no such word in oracle 8
d. none of the above
16. 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
17. Which of the following is true about NULL?
a. when an arithmetic operation is performed on NULL, u will get the result as NULL
b. NULL is same as 0.
c. NULL is same as blank date.
d. None of the above
18. 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.
19. 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
20. 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
21. How do u rename a table ?
a. Using alter command
b. Using RENAME
c. Dropping the table and creating once again
d. None of the above.
22. 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
23. 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
24. 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.
25. 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
26. Which of the following is true about procedure and a function
a. Procedure should return a value and a function may not return a value
b. A function has to return a value and a procedure don??t have to
c. Both a & b
d. None of the above.

Can we call another procedure or function from a procedure inside package body?
Can we use a variable in a procedure without datatype? Like xyz(a,b)
Re: SQL Interview questions? [message #137804 is a reply to message #137803] Fri, 16 September 2005 19:31 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
0) these are very important sql interview questions...
No they're not.
1) D. Who cares? Oracle 8 is desupported.
2) D. Who cares? Oracle 7 is desupported.
3) Check the documentation
4) D. Who cares? Oracle 8 is desupported.

...skipping...

26) Check the documentation

@samy ganesh: read the sticky in the newbie forum, follow the links, read the manuals and come back with specific questions.

The list you have is outdated. It refers far too often to obsoleted and desupported Oracle questions. These are irrelevant in a professional environment (hence the answer to question 0).

No hard feelings Wink

MHE

[Updated on: Mon, 19 June 2006 01:20]

Report message to a moderator

Re: SQL Interview questions? [message #190908 is a reply to message #137804] Sat, 02 September 2006 05:10 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
And above all, do NOT report a message to get an answer!!


Besides, try to learn Oracle instead of pop-quiz answers..

[Updated on: Sat, 02 September 2006 05:10]

Report message to a moderator

Previous Topic: Get trained from oracle university!(India)
Next Topic: oracle ocp exams guide ?
Goto Forum:
  


Current Time: Thu Mar 28 03:52:08 CDT 2024