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

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

صورة
- - - - -

سؤالين لو سمحتم


لا توجد ردود على هذا الموضوع

#1 amd_el

amd_el

    مشترك

  • الأعضــاء
  • 89 مشاركة
  • البـلـد: Country Flag

تاريخ المشاركة 01 October 2007 - 01:31 PM

لو سمحتم اريد الأجابات الصحيحه لهذه الأسئله
1-To be callable from a SQL expression, a user-defined function must do what?

A. Be stored only in the database.
B. Have both IN and OUT parameters.
C. Use the positional notation for parameters.
D. Return a BOOLEAN or VARCHAR2 data type.

2- The creation of which database objects will cause a DDL trigger to fire? (Choose all that apply)

A. Index
B. Cluster
C. Package
D. Function
E. Synonyms
F. Dimensions
G. Database links

3- Which three are true regarding error propagation? (Choose three)

A. An exception cannot propagate across remote procedure calls.
B. An exception raised inside a declaration immediately propagates to the current block.
C. The use of the RAISE; statement in an exception handler reprises the current
exception.
D. An exception raised inside an exception handler immediately propagates to the
enclosing block