The functional dependency A Þ B for relation schema R(A,B,C,D) implies that

 

 

سؤال 1
الدرجة 1.00

Which of the following lines of the SELECT statement contains an error?

  1. SELECT last_name, first_name,
  2. “Phone Number”, phone_number
  3. FROM employees;
سؤال 2
الدرجة 1.00

A relation schema R is in 3rd normal form if        

سؤال 3
الدرجة 1.00

Which of the following is not a binary operator in relational algebra?

سؤال 4
الدرجة 1.00

 …………..defines the structure of a relation which consists of a fixed set of attribute-domain pairs.

 

سؤال 5
الدرجة 1.00

Which of the following commands can be used to modify a tuple to other value?

 

سؤال 6
الدرجة 1.00

For like predicate which of the following is true 

i) % matches zero of more characters.

ii) _ matches exactly one character.

 

سؤال 7
الدرجة 1.00

Which of the following will display all the employees in department 90 and having a salary of at least $8000.00?

سؤال 8
الدرجة 1.00

The ........ is used for creating and destroying table, indexes and other forms of structures.

سؤال 9
الدرجة 1.00

 

 Given the set of functional dependencies, (AB Þ CDE  and A Þ E) , for relation scheme R = (A,B,C,D,E) we can infer the following:   

 

 

سؤال 10
الدرجة 1.00
الوقت المتبقي
00 : 00 : 29
التنقل بين الأسئلة