Transformation of Relational Expressions

1.

Let R(A,B,C,D,E,P,G) be a relational schema in which the following FDs are known to hold:
AB->CD
DE->P
C->E
P->C
B->G
The relation schema R is

   A.) in BCNF
   B.) in 3NF, but not in BCNF
   C.) in 2NF, but not in 3NF
   D.) not in 2NF

Answer: Option 'D'

not in 2NF

2.

Which of the following is/are false for RAW mode of FOR XML?

   A.) XMLSCHEMA option does not returns an in-line XSD schema.
   B.) BINARY BASE32 returns the binary data in base32-encoded format.
   C.) Each row in the query result is transformed into an XML element
   D.) Both a and b above

Answer: Option 'D'

Both a and b above

3.

You have a column that will only contain values from 0 to 256. What is the most economical data type to use for the column?

   A.) TINYINT
   B.) SMALLINT
   C.) INT
   D.) DECIMAL(1)

Answer: Option 'B'

SMALLINT

4.

Which of the following fixed database roles can add or remove user IDs?

   A.) db_accessadmin
   B.) db_securityadmin
   C.) db_setupadmin
   D.) db_sysadmin

Answer: Option 'A'

db_accessadmin

5.

By default sql server has ___________ isolation level

   A.) READ COMMITTED
   B.) READ UNCOMMITTED
   C.) SERIALIZABLE
   D.) REPEATABLE READ

Answer: Option 'A'

READ COMMITTED

Transformation of Relational Expressions Download Pdf