إنتقال للمحتوى

  • تسجيل الدخول عبر الفيس بوك تسجيل الدخول عبر تويتر Log In with LinkedIn Log In with Google      تسجيل دخول    
  • إنشاء حساب

صورة
- - - - -

مجموعه أسئله فى الPL/SQL اريد المساعده فى حلها


1 رد (ردود) على هذا الموضوع

#1 وسن

وسن

    عضو

  • الأعضــاء
  • 3 مشاركة

تاريخ المشاركة 17 December 2005 - 06:29 PM

السلام عليكم ورحمة الله وبركاته
تحية عطرة لجميع أعضاء هذا المنتدى الرائع
أرجو منكم مساعدتي في حل أسئلة سوف أقوم بطرحها بين أيديكم
فيعلم الله لم أطرحها إلا بعد أن ضاقت بي السبل حيث لا يوجد لدي مرجع أستند إلى معلوماته
الأسئلة:
Can you create a PRE-FORM trigger at the block level? Why not
**************************************
Explain how changing the Execution Hierarchy property of a trigger a form?
**********************************
What trigger would you create to replace the default delete processing? What named category does this fall under? What functional category does it fall under?
**********************************
Is it mandatory that you write triggers to respond to each event? What happens if you don’t?
**************************************************
Choose the correct answer:

1. Which of the following is true about When event triggers?
a) Thy augment default Forms processing
b Thy replace default Forms processing
c) Thy only respond to interface events
d) Non of above
*****************************************
2. Where could you attach a POST-QUERY trigger if you want it to populate a display item named STUDENT.LAST_NAME?
a) To the primary key item in the block
b To the STUDENT block
c) To the LAST_NAME item
d) To any item in the form that will be queried
*******************************************
3. When dose the WHEN- VALIDATE-ITEM trigger fire?
a) In response to Validate Item event
b When an item is not valid
c) When the user navigates out of an item and that items value has been changed
d) a & c
****************************************

4. Which trigger should you use to validate an entire record?
a) POST- VALIDATE-RECORD
b WHEN- VALIDATE-RECORD
c) WHEN-NEW- RECORD-INSTANCE
d) a & b
*******************************************************
5. What is FORM_TRIGGER_FAILUAR?
a) A built-in to respond to the failure of an event
b A built-in you can use to crash the operating system
c) A built-in exception to help you handle errors
d) An event you can respond to with the ON-ERROR trigger
*********************************************************
Assume that in the SECTION tables LOCATION column, all the buildings that are named L501,L502, and so on- can seat 15 students or less. When users are inserting or updating section records, you want to prevent them from making the CAPACITY greater than 15 for any room
a) Could you write a Validation trigger to enforce this rule? What would the code be?
b If you use a WHEN-VALIDATE-ITEM trigger, which item could the trigger code be attached to?
c) If your answer to Question I was CAPACITY, when will the WHEN- VALIDATE-ITEM trigger fire?
d) If the user inserted a new row, what would happen if the user set CAPACITY to 25 first and then set LOCATION to L501? Would the validation take place? Why not?

#2 أسامة موسى

أسامة موسى

    مشرف سابق وعضو مميز

  • المجموعة الماسية
  • 2,381 مشاركة
  • البـلـد: Country Flag

تاريخ المشاركة 18 December 2005 - 02:41 PM

[QUOTE]Can you create a PRE-FORM trigger at the block level? Why not[/QUOTE]
**************************************
لايمكن عمل تريجر PRE-FORM على مستوى البلوك لأن الهدف من هذا التريجر هو تنفيذ تعليمة معينه قبل فتح الفورم لذلك يجب ان يكون على مستوى الفورم وليس مستوى البلوك



[QUOTE]Explain how changing the Execution Hierarchy property of a trigger a form?


What trigger would you create to replace the default delete processing? What named category does this fall under? What functional category does it fall under?

Is it mandatory that you write triggers to respond to each event? What happens if you don’t?[/QUOTE]

اجابات الثلاثة اسألة راجعي هذا الرابط
http://courses.csusm...es/triggers.htm

الاجابات الصحيح
[QUOTE]
1. Which of the following is true about When event triggers?
a) Thy augment default Forms processing
b Thy replace default Forms processing
c) Thy only respond to interface events
d) Non of above[/QUOTE]
الجواب a
*****************************************
[QUOTE]2. Where could you attach a POST-QUERY trigger if you want it to populate a display item named STUDENT.LAST_NAME?
a) To the primary key item in the block
b To the STUDENT block
c) To the LAST_NAME item
d) To any item in the form that will be queried
*******************************************[/QUOTE]
الجواب a

[QUOTE]3. When dose the WHEN- VALIDATE-ITEM trigger fire?
a) In response to Validate Item event
b When an item is not valid
c) When the user navigates out of an item and that items value has been changed
d) a & c
****************************************[/QUOTE]
الجواب c

[QUOTE]4. Which trigger should you use to validate an entire record?
a) POST- VALIDATE-RECORD
b WHEN- VALIDATE-RECORD
c) WHEN-NEW- RECORD-INSTANCE
d) a & b
*******************************************************[/QUOTE]
الجواب d

[QUOTE]5. What is FORM_TRIGGER_FAILUAR?
a) A built-in to respond to the failure of an event
b A built-in you can use to crash the operating system
c) A built-in exception to help you handle errors
d) An event you can respond to with the ON-ERROR trigger
*********************************************************[/QUOTE]
الجواب b

*********************************************************
[QUOTE]Assume that in the SECTION tables LOCATION column, all the buildings that are named L501,L502, and so on- can seat 15 students or less. When users are inserting or updating section records, you want to prevent them from making the CAPACITY greater than 15 for any room
a) Could you write a Validation trigger to enforce this rule? What would the code be?[/QUOTE]
answer:
u can make the trigger in table before-insert
and check the count of the location and make comparison between the count and number 15 if less or more and use the where condtion by name or id

[QUOTE]b If you use a WHEN-VALIDATE-ITEM trigger, which item could the trigger code be attached to?[/QUOTE]

i use the trigger in location failed and check by the name

[QUOTE]c) If your answer to Question I was CAPACITY, when will the WHEN- VALIDATE-ITEM trigger fire?[/QUOTE]
when the value changed or update or insert new record

[QUOTE]d) If the user inserted a new row, what would happen if the user set CAPACITY to 25 first and then set LOCATION to L501? Would the validation take place? Why not[/QUOTE]
no couse the user enter the capacity after that he make like update in the table and do insert


هذه الاجابات ليست كاملة ولكن مقتطفات منها او رؤوس اقلام
۩ اللهـــــــــــــــــــــــم صلي على سيدنا محمد وعلـى آله وصحبه أجمـعين ۩
۩ سبحـــــــــــــــــان الله وبحمده ....... سبحــــــــــــــــــــــــان الله العظيم ۩



يمكنك زيارتي على صفحتي الخاصة بالفيس بوك على الرابط AskOsama

يمكنك زيارتي على مدونتي الجديدة على الرابط http://askossama.blogspot.com