Oracel database basics interview questions - Free latest PlacementPapers, Interview Questions ....

sai6606 · 09-12-08, 04:38 PM

1. Odd return value from Oracle forms 6i calendar widget

2. What steps server process has to take to execute an update statement.

3. create a matrix query to display the job, the salary for that job based on department number and the total salary for that job, for departments 20,50,80, and 90,giving each column and appropriate heading.

4. Oracle 9i Tools and Utilities

5. what are the differences between rownum and level pseudo columns?

6. what is the difference between primary key, unique key, sorrougate key?

7. In Oracle varchar2 takes dynamic space for storage then why char is still in oracle?

8. What is stucture of Database

9. How many bites does varchar2(30) needs ?

10. what is data structure

11. What is the different between Stand Alone Procedure and Package?

12. Create a report for the HR department that displays employee last names, department numbers, and all the employees who work in the same department as a given employee. Give each column an appropriate label.

13. create a query that will display the total no.of employees and, of that total, the no.of employees hired in 1995,1996,1997, and 1998. create appropriate column headings.

14. What is the Life of an SQL Statement?

15. Difference between oracle8i and oracle9i

16. What is the diffrence between and constraints and triggers?

17. How the logs are escalated

18. What is the difference between cold backup and hot backup

19. What is Pro*C? What is OCI?

20. Create a query that display the last name,hire date and the day of the week on which the employee started. Label the column DAY. Order the results by the day of the week starting with Monday.LAST_NAME HIRE_DATE DAYGrant 24-MAY-99 MONDAYErnst 21-MAY-99 TUESDAYMourgos 16-NOV-99 TUESDAY------- ----- SUNDAY
21. Why do we need to use 'WHERE CURRENT OF' clause

22. What is the difference between Instance and a Database?

23. There are how many maximum no of colimns in atable in oracle?There are how many maximum no of canvases in a form in forms6i an forms9i?please will u tell me...tahnking YouSujit

24. Through Shell script in Unix, How can you run the Oracle procedure?

25. What is difference between varchar and varchar2

26. what is normalization? what is the advantage of normalization (briefly)

27. Hello, I have problem with this RecordSet. Do not open with "select distinct". Why?Without "distinct" recorset is opened without problems.Private Sub Command1_Click()Dim Cnn As New ADODB.ConnectionDim rs As New ADODB.RecordsetDim CadOracle As StringDim CadSql As StringCadOracle = "DSN=Oracle;UID=RECAUDA;PWD=xxxx;DBQ=orcl"Cnn. Open CadOracleCadSql = "select distinct NOMBRE_MUNI_SUJ from paddgc53"rs.Open CadSql, Cnn, adOpenKeyset, adLockOptimistic, adCmdText

28. write a query to display the no.of people with the same job

29. What is the difference between "NULL in C" and "NULL in Oracle?"

30. create a query that will display the total no.of employees and, of that total, the no.of employees hired in 1995,1996,1997, and 1998. create appropriate column headings.

31. What is one time procedure

32. Can we create sequence to a View??

33. what is synapshot?

34. write a query that displays the difference between the highest and lowest salaries. Label the column DIFFERENCE.

35. i want to try create the database from my script which i made.can help me how to run a script. can explain me step by step because i am a starter.thank's

36. What is the Difference between Replace and Translate

37. what is the difference between rownum,rowid

38. Is Oracle is a Multidimensional database? If yes How?

39. What is variable size when showing SGA?

40. how we can add signature to the character mode report ?

41. LGWR have to wait because checkpoint not complete so remove this error increase DBWn.Explain how DBWn related to LGWR?

42. I hav oracle 9i installed on my server, and I am fireing a query as followsSelect distinct divisioncode from Mdivision Order By DivisionCodeWhen I fire this query in sql plus, it runs and give me results.but when I fire it thru asp script as follows rsDiv.Open sql,conn,3,1 while traversing thru the recordset on line if not rsDiv.EOF thenit is giving me following errorADODB.Recordset (0x800A0E78)Operation is not allowed when the object is closed.Pl. help me a.s.a.p.

43. what is difference between COM & DCOM?

09-12-08, 04:38 PM	#1 (permalink)
sai6606 Senior Member Join Date: Nov 2008 Posts: 311	Oracel database basics interview questions 1. Odd return value from Oracle forms 6i calendar widget 2. What steps server process has to take to execute an update statement. 3. create a matrix query to display the job, the salary for that job based on department number and the total salary for that job, for departments 20,50,80, and 90,giving each column and appropriate heading. 4. Oracle 9i Tools and Utilities 5. what are the differences between rownum and level pseudo columns? 6. what is the difference between primary key, unique key, sorrougate key? 7. In Oracle varchar2 takes dynamic space for storage then why char is still in oracle? 8. What is stucture of Database 9. How many bites does varchar2(30) needs ? 10. what is data structure 11. What is the different between Stand Alone Procedure and Package? 12. Create a report for the HR department that displays employee last names, department numbers, and all the employees who work in the same department as a given employee. Give each column an appropriate label. 13. create a query that will display the total no.of employees and, of that total, the no.of employees hired in 1995,1996,1997, and 1998. create appropriate column headings. 14. What is the Life of an SQL Statement? 15. Difference between oracle8i and oracle9i 16. What is the diffrence between and constraints and triggers? 17. How the logs are escalated 18. What is the difference between cold backup and hot backup 19. What is ProC? What is OCI? 20. Create a query that display the last name,hire date and the day of the week on which the employee started. Label the column DAY. Order the results by the day of the week starting with Monday.LAST_NAME HIRE_DATE DAYGrant 24-MAY-99 MONDAYErnst 21-MAY-99 TUESDAYMourgos 16-NOV-99 TUESDAY------- ----- SUNDAY 21. Why do we need to use 'WHERE CURRENT OF' clause 22. What is the difference between Instance and a Database? 23. There are how many maximum no of colimns in atable in oracle?There are how many maximum no of canvases in a form in forms6i an forms9i?please will u tell me...tahnking YouSujit 24. Through Shell script in Unix, How can you run the Oracle procedure? 25. What is difference between varchar and varchar2 26. what is normalization? what is the advantage of normalization (briefly) 27. Hello, I have problem with this RecordSet. Do not open with "select distinct". Why?Without "distinct" recorset is opened without problems.Private Sub Command1_Click()Dim Cnn As New ADODB.ConnectionDim rs As New ADODB.RecordsetDim CadOracle As StringDim CadSql As StringCadOracle = "DSN=Oracle;UID=RECAUDA;PWD=xxxx;DBQ=orcl"Cnn. Open CadOracleCadSql = "select distinct NOMBRE_MUNI_SUJ from paddgc53"rs.Open CadSql, Cnn, adOpenKeyset, adLockOptimistic, adCmdText 28. write a query to display the no.of people with the same job 29. What is the difference between "NULL in C" and "NULL in Oracle?" 30. create a query that will display the total no.of employees and, of that total, the no.of employees hired in 1995,1996,1997, and 1998. create appropriate column headings. 31. What is one time procedure 32. Can we create sequence to a View?? 33. what is synapshot? 34. write a query that displays the difference between the highest and lowest salaries. Label the column DIFFERENCE. 35. i want to try create the database from my script which i made.can help me how to run a script. can explain me step by step because i am a starter.thank's 36. What is the Difference between Replace and Translate 37. what is the difference between rownum,rowid 38. Is Oracle is a Multidimensional database? If yes How? 39. What is variable size when showing SGA? 40. how we can add signature to the character mode report ? 41. LGWR have to wait because checkpoint not complete so remove this error increase DBWn.Explain how DBWn related to LGWR? 42. I hav oracle 9i installed on my server, and I am fireing a query as followsSelect distinct divisioncode from Mdivision Order By DivisionCodeWhen I fire this query in sql plus, it runs and give me results.but when I fire it thru asp script as follows rsDiv.Open sql,conn,3,1 while traversing thru the recordset on line if not rsDiv.EOF thenit is giving me following errorADODB.Recordset (0x800A0E78)Operation is not allowed when the object is closed.Pl. help me a.s.a.p. 43. what is difference between COM & DCOM? __________________ Sai Prepaid Mobile Recharge Online* - Airtel, Vodafone, Idea, BSNL Cellone, Reliance Mobile, Tata Indicom.