| Other Oracle General Interview Questions |
|| Asked @
|How can we find the size of a database?
|How are Indexes Update ?
|WHT ARE THE AGGREATE FUNCTIONS?
|9)When information has to be stored w.r.t employees and
their respective departments, which of the following is the
Correct formulation of entries?
A)Employee and department would together be represented as
B)This is too less information to decide on entities.
C)An employee would be one entity and a department would be
D)Such a scenario cannot be modelled in RDBMS
|Create table Employee
Employee_Id varchar2(8) Constraint emp_id_pk primary key,
Constraint dept_id_fk Foreign Key(DeptId)
Error I am getting: Constraint specification are not
Can any one give answer for this question.
Suppose im having employee table with fields, eno, ename,
dept, address1, address2, address3.
In address field employee can fill only address1 or address2
or address3... at a time he can fill three address fields.
now i want all employee names who filled only one address
field.. Plz its urjent can any one give querry.. Thanks in
|Define 'view' advantage ?
|Write a simple Store procedure and pass parameter to it ?
|what is the maximum number of indexes i can create for a
What happens if i create indexes for all the columns of a
table? Will it slow down the speed of retrieval
|difference between truncate and delete ,drop?
|What is an Integrity Constrains ?
|You have one employee table having 3 entries emp_id, Mgr_id
and salary. Mgr_id is also referencing emp_id. so now find
out the emp_id which are having the second highest salary,
under a particular manager.
|For more Oracle General Interview Questions Click Here |