Oracle Interview Question Bank

 

Oracle Interview Question Bank

Here is the below oracle interview question commonly asked in many MNC company . Try to prepare it before appearing for an interview you can refer HAND ON SQL  for interview question and answer .

1.     What is an RDBMS ? what are different Database models ?

2.     What is SQL ?

3.     What is a transaction ?

4.     What is a Commit ?

5.     What is a rollback ?

6.     What is a DDL ?

7.     What is a DML ?

8.     What are group functions ? explain each

9.     What is  locking ?

10.  What is deadlocking ?

11.  What is a shared lock ?

12.  What is a exclusive lock ?

13.  What is a shared exclusive lock ?

14.  What are clusters ?

15.  What is indexing?

16.  What is a view?

17.  What is a rowid?

18.  What is a primary key?

19.  What is a unique key ?

20.  What is the difference between unique and primary key?

21.  What is a foreign key?

22.  What are integrity constraint.?

23.  What is referencial  intigrity ?

24.  What are different datatypes ?

25.  What is Varchar2 ? How is it different from Char?

26.  What is datatype mixing ?

27.  What is NULL?

28.  What is a sequence ?

29.  What are pseudo Columns in ORACLE ?

30.  What is a Like operator? How is it different from IN Operator?

31.  What are single row number functions in oracle? Give 4 examples and explain

32.  What are single row char functions in oracle? Give 4 examples and explain

33.  What are Conversion functions in oracle Give 4 examples and explain

34.  What are date function ? Give 4 examples and explain

35.  What is New_Time function?

36.  What is Convert function ?

37.  What is Translate function?

38.  What is Soundex function ?

39.  What is Replace function?

40.  What is floor function?

41.  What is iIntcap function?

42.  What is ASCII function?

43.  What is Decode function?

44.  What is Greatest function?

45.  What is format model in oracle?

46.  Give 5 examples of of number and date formats ?

47.  What is an expression ?

48.  What are 5 forms of expressions ?

49.  What is a condition?

50.  What aer 7 forms of conditions?

51.  What is a Synonym ?

52.  What are Cursors?

53.  What is explicit Cursors? How is it different from implicit cursor?

54.  What is an embedded SQL?

55.  What is PL/SQL?

56.  What are the Conditional Constructs of  PL/SQL?

57.  How is an array defined in PL/SQL?

58.  How to define a variable in PL/SQL?

59.   How to define an cursor in PL/SQL?

60.  What are exceptions?

61.  What are system Exceptions?

62.  How to Define our own exceptions in PL/SQL?

63.  How is the performance improved by PL/SQL in Oracle ?

64.  What is a Schema?

65.  What is a profile?

66.  What are roles?

67.  How can we alter a user’s password in oracle?

68.  What is a table-space in oracle?

69.  What is extent?

70.  What are PCTFREE and PCTUSED parameters?

71.  What is a Block in oracle?

72.  What is client –server architecture? Explain the different types?

73.  What is a segment in oracle ? explain different types?

74.  What is the use of RollBack segment?

75.  What is read-consistancy in ORACLE?

76.  What is SGA?

77.  What are background processes?

78.  What is SYSTEM userid? What does it have?

79.  What is SYS userid? What does it have?

80.  What is data dictionary in ORACLE?

81.  What is SQLDBA?

82.  Who is ORACLE ADMINISTRATOR ? How is he different from DBA ?

83.  How to create database?

84.  What are database files?

85.  What is a log file ? What is it's significance?

86.  What is a control file ? What is it's significance?

87.  What is a init file ? What is it's significance?

88.  What does an UPDATE  statement do?

89.  What does an DELETE statement do?

90.  What does an SELECT  statement do?

91.  What does an INSERT  statement do?

92.  How to create a table using SELECT and INSERT statements?

93.  How To delete duplicate rows in a table?

94.  What is an instance?

95.  What is startup and shutdown?

96.  What is mounting of database?

97.  What is two-phase commit?

98.  What are snapshots?

99.  What are triggers and stored procedures?

100.        What are packages?

101.        What is SQL*Forms 3.0 ? Is it a client or server?

102.         What are different objects of SQL* Forms?

103.        What are packaged Procedures?

104.        What are different types of triggers?

105.        What is the difference between resticted and unrestricted packaged procedures?

106.        What are system variables in SQL*Forms?

107.        What are global variables in SQL*Forms?

108.        What are pages?

109.        What is block? Explain different types?

110.        What is screen?

111.        What are different types of field?

112.        What is page zero?

113.        What does MESSAGE function do?

114.        What does NAME_IN function do?

115.        What does CLEAR_EOL procedure do?

116.        What does ON_ERROR procedure do?

117.        What does COPY function do?

118.        What is ARRAYSIZE parameter?

119.        What is GO_BLOCK function?

120.        What is ANCHOR_VIEW function?

121.        How to call a form from inside a form?

122.        How to send a parameters to another form?

123.        How to give automatic hint text for fields?

124.        How to see key map sequences?

125.        What is SYNCHRONIZE function?

126.        What is EXECUTE_QUERY procedure?

127.         How to customise system messages in SQL*Forms

128.        How to define fields in WYSIWYG format?

129.        What is ON-INSERT trigger?How is different from PRE-INSERT?

130.        What is the difference between a trigger and procedure?

131.        How to call a stored procedure from inside a form?

132.        What are V2 triggers?

133.        How to rename a form?

134.        What is a pop-up page?How to define one?

135.        What is a group in SQL*ReportWriter?

136.        How do you define parent-child relationship in ReportWriter?

137.        What is a rowcount fuction in ReportWriter?

138.        How do you define matrix report?

139.        How do you execute a report from within a form?

140.        What are exp and imp utilities?

141.     what is vertual column ?

142.     select decode('A',1,'C','A') from dual ;

143 .   create sequence seq1;

           select seq1.currval from dual ;

144.  select substr('123456789',instr('abcabcabc','b'),4) from dual ;

145.  select sysdate-sysdate+2 from dual ;

146. what is different between Union and union all?

147. what is different group by clause and having clause?

148. Explain join and type of joins ?

150 .what is different between case and decode?

151. Explain  rank and dense rank.?

152. SQL loaded sample 

153. how to skip a column from txt file in sql loaded ?

154. after loading the data how you will check the junk data and log into error log table ?

155. What is collection ? Diff Type of Collection ?

156. how to display odd/even record of table ?

157. 7th heighest salary of employee ?

158. How to reduce to time of query which is taking 4hrs to run ?

159. What is partition ? Explain with real life example ?

160. How to remove the duplicate data from table ? using two diff method ?



If you have some more interview question please drop in comment section .