السلام عليكم
archive mode means making an archive'زى النسخة الاحتياطية'
from redo archive files in order to being able of performing backup and recovery on the data base
to set the data base in the archive mode

ALTER DATABASE ARCIVE LOG;
BUT NO NEEDOF EXTRA MEMORY OR ADDITIONA RESOURCES
GOOD BY

مشكورين والله يعافيكم

ده اختبار فى شركة كبيرة حطيطه من كام يوم فى المنتدى ومحمدش جاوب عليه

1 GAVEN THE FOLLOWING TABLES

SUPPLIER(SUPPLIER_ID,SUPPLIER_NAME,CITY); PK(SUPPLIER_ID)

------------------------------------------------------
SUPPLIER_ID | SUPPLIER_NAME
------------------------------------------------------
1 | IBM
------------------------------------------------------
2 | AT&T
------------------------------------------------------
3 | GE
------------------------------------------------------

PARTS(PART_ID,PART_NAME,COLOR); PK(PART_ID)

---------------------------------------------------------------------------
PART_ID | PART_NAME | COLOR
---------------------------------------------------------------------------
1 | COMPUTER | RED
---------------------------------------------------------------------------
2 | CALCULATOR | GREEN
---------------------------------------------------------------------------

SUPPLIER_PART(SUPPLIER_ID,PART_ID,QTY), PK(SUPPLIER_ID,PART_ID)

-------------------------------------------------------
SUPPLIER_ID | PART_ID | QTY
-------------------------------------------------------
1 | 1 | 30
-------------------------------------------------------
1 | 2 | 50
-------------------------------------------------------
2 | 1 | 20
-------------------------------------------------------


write SELECT statements to obtain results of following
1 get supplier who dose not supply any part.
2 get supplier who supplies only one part.
3 get supplier who supplies all parts.
4 get supplier who supplies the maximum quantity of part 1.
5 get the total quantity supplied of each part.

according the question no . i create database package contain.
1 function to get supplier who dose not supply any part.
2 function to get supplier who supplies only one part.
3 function to get supplier who supplies all parts.
4 function to get supplier who supplies the maximum quantity of part 1.
5 function to get the total quantity supplied of each part.

3 write two triggers that fire on each of form-level,block-level,record-level and item-level
explain briefly each trigger.
------------------------------------------


4 write down the name of the trigger that can be used to activate the close button at the top of the window
(note close button appears on the title bar of any window on MS WINDOWS PLATFORM as (x)).
------------------------------------------
5 if i need a trigger that fires on each navigation of records?....Ex...need to show and hide some items
depending on a condition in the record what will be that trigger?
------------------------------------------
6 if i need to check the uniqueness of the primary key not on commit but when entering the value of the
primary key state the triggers that will be used and the code you will write in each trigger?take into
consideration that this value might not been saved yet in the database ,this means it's on block and not
yet committed.
------------------------------------------
7 if you have a record group whose query changes depending on the data block record what built-in function
will be used?

------------------------------------------
8 if i need to change a property on item not in the whole records but in the current record
depending - assuming that we have a toolbar layout -on a condition in the record.what procedure will you used?
------------------------------------------
9 write a database function that accepts column name and table name as parameters and returns the MAX value
in the column.
function xxx(p_column_name varchar2,p_table_name)
what if you need to do the same function in forms builder,what package should you use?
------------------------------------------
10 assume that you have a table say
emp(empno number(10),ename varchar2(50))
the table contains the the following data
_________________
empno ename
_________________
1 ali
_________________
2 hassan
_________________

begin
select ename into ename
from emp
where empno=empno
end;

what would be the value of the variable ename after the execution of the above code?
do you expect any errors to arise from the above code?

-----------------------------------------------------------

11 assume you have two tables
table t1(t_id number(10)) with a check constraint t_id>0
table t2(cnt number(10)) with only one row record in it initialized to 0
now suppose we have a trigger on t1

declare
v_cnt number(15);
begin
select nvl(cnt,0)
into v_cnt
from t2;
v_cnt:=v_cnt+1;
update t2 set cnt=v_cnt;
end;

examine the code below and tell what would be the value of cnt in table t2
after execution of the following cases separately.

end;
please indicate the value of cnt after execution of above code (first case)

(second case)
begin
insert into t1 values(3);
insert into t1 values(-1);
exception
when others then
null;
end;

please indicate the value of cnt after execution of above code (second case)

--------------------------------------------------------------------------------
12 we need a query which display the following output form tables emp,dept

dept 10
emp1
emp2
dept 20
emp3
emp4

meaning first display the department then displays the employee belonging to this
department (using hierarchical retneval) indicate the level on each row as a column
of the result.

-----------------------------------------------------------------------

13 suppose you have the following results
1234 12341234fadf<hello>123423 dfa
write the statement to extract the text after the <hello> tag(note.: the number of characters of
the whole string is unknown one thing for sure,it contains<hello>)
--------------------------------------------------------------
14 what is the oracle supplied package responsible for writing on text files on the
database what is the other package used on forms for the same purpose

http://www.araboug.org/ib/index.php?showtopic=35701&hl=

رابط له علاقة بالموضوع

حاجه جميله فعلا جزاكم الله كل خير

تسلم ايدكم يا جماعة على المعلومات ذات القيمة
وجزاكم الله عنا كل خير

اشكركم اخوانى المشاركين فى هذا العمل الرائع

عندى Interview بكرة ادعولى

وان شاء الله هشارك بالاسئلة الى سوف تطرح فى المقابلة

bgd topic genan

gzak alla 5iran ya eng/sameh,eng/mostafa,eng/amagd

w kol eng sharek fe topic

genan bs ana m3ndesh interview lsa

rbna yshel b2a

ان شاء الله ربنا يكرمك بمقابله سهله جدا و تشتغلى بسرعه جدا .. بالتوفيق

السلام عليكم ازيكم يا شباب انا كنت في انترفيو امس وجتلي الأسئلة دي بس مش عارف جاوبت صح ولا غلط ياريت
حد يتبرع يجاوب عليها اجابه نموزجيه:
1.HOW do I eliminate the duplicate rows?
2. What is the types of view?explain in detail?
3. What is deifference between pl sql library,object library ,object gruop?
4. can I create the table space and the index of that table on another table space ?
5. Whit's the report triggers ?
6. How do I display row number with records in employee table ?
7. what is the difference between implicit & Explicit cursors ?
8. Find out the highest salary from employee table ?
9. Which date function returns number value?
10. Wat is the output of SIGN function ?
11. What is the maximum number of triggers, can apply to a single table ?
12. To view installed Oracle version information ?

كذلك من ضمن الأسئلة التي واجهتني في المقابلة هي:

1- ما الفرق بين الآتي:

1- primery Key
2- Index
3- Unique

وهل يمكن أن يكون المفتاح الأساسي index

4- مالمقصود بال Normalization وضح بمثال.

5- ما هي الفروقات الجوهرية بين oracle 9i وoracle 10g.

6- بما أن الدالة distinct تقوم بعرض السجلات بدون تكرار ،

ونفترض أننا نعمل على جدول بيانات الموظفين و لدينا رقم الموظف متكرر ( مفتاح ثانوي )
كيف أقوم بإضهار السجلات المتكررة في الجدول .


بمعنى ما هي جملة SQL التي سأقوم بكتابتها
------------------------------------------------------------------


أخوكم/ عبد الفتاح العمراني

تم تعديل 11 يناير 201016 سنة بواسطة amrani

ياشباب عندي اسئلة المقابلة الثانية ؟ وهي اصعب واشمل sql pl/sql forms reports ?
ومعايا نسخة من الأسئلة فياريت بس حد يجاوب الاسئلة دي وانا هضع الاسئلة الثانيه ان شاء الله

4- ما فائدة ال Anchor ؟
ممكن اى حد يجاوب عليه
وشكرااااااا.......

up

السلام عليكم ازيكم يا شباب انا كنت في انترفيو امس وجتلي الأسئلة دي بس مش عارف جاوبت صح ولا غلط ياريت

حد يتبرع يجاوب عليها اجابه نموزجيه:

1.HOW do I eliminate the duplicate rows?

2. What is the types of view?explain in detail?

3. What is deifference between pl sql library,object library ,object gruop?

4. can I create the table space and the index of that table on another table space ?

5. Whit's the report triggers ?

6. How do I display row number with records in employee table ?

7. what is the difference between implicit & Explicit cursors ?

8. Find out the highest salary from employee table ?

9. Which date function returns number value?

10. Wat is the output of SIGN function ?

11. What is the maximum number of triggers, can apply to a single table ?

12. To view installed Oracle version information ?

HOW to eliminate the duplicate rows :

you can simply use self join to eliminate duplicated rows in table...for instance,we've a table called "testing" which contains two colums called "first_column" and "second_column" alternatively..use the follwoing sql statement...delete from testing a where a.rowid > any (select b.rowid from testing b where a.first_column=b.first_column and a.second_column=b=second_column) .

 

 types of views :

there are two kinds of view..simple and complex views..simple views derives data from only one table while complex view derives data from more than one table,simple views got no group functions while complex view have got group functions..simple views can have dml statements which is not true in complex views.

 

difference between pl/sql library,object library and record groups :

 

pl/sql library contains only functions and procedures and can be compiled to produce a file with the extension (plx) which is a good way to hide source codes while object library may contain other objects like triggers,alerts ,ect...and it's not compiled so it contains the source codes.record groups contains sql statements and useful for creating LOVS and lists

 

can I create the table space and the index of that table on another table space

 

yes

 

report triggers

 

there are 5 types of reports triggers : before parameter form trigger,after parameter form trigger,before report,between pages and after report trigger

How to display row number with records in employee table

 

select rownum

 

 the difference between implicit & Explicit cursors

 

implicit triggers are being created automaticaly whenever you execute any select statement while explicit triggers are being created by the user when you want to fetch more than one row from one or more tables

 

Find out the highest salary from employee table

 

select max(salary) from employees

 

Which date function returns number value

 

months_between function

 

the output of SIGN function

 

sign functions identifies the sign of function..if it's greater or less than 0 and it returns 1 if the number is greater than 0 and -1 if it's less than 0

 

 the maximum number of triggers, can apply to a single table

 

there are only 12 triggers that you can create in a table

 

To view installed Oracle version information

 

select * from v$version