Transformation of Relational Expressions MCQ

Test your knowledge with important Transformation of Relational Expressions MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30+ more Transformation of Relational Expressions MCQs on Bissoy. Bissoy App

• State true or false: Multiple equivalence rules can be used one after the other on a query
  ক

  True

  খ

  False
• Which of the following set operations does the selection operation distribute over?
  ক

  Union

  খ

  Intersection

  গ

  Difference

  ঘ

  All of the mentioned
• Which of the following operations is associative
  ক

  Set union

  খ

  Set intersection

  গ

  Set difference

  ঘ

  Theta join
• Theta join operations are
  ক

  Commutative

  খ

  Associative

  গ

  Distributive under projection

  ঘ

  All of the mentioned
• If no rule can be derived from any combination of others then the set of rules is said to be ________
  ক

  Primitive

  খ

  Axiomatic

  গ

  Minimal

  ঘ

  Atomic
• State true or false: The projection operation does not distribute over the union operation
  ক

  True

  খ

  False
• Which of the following set operations is not commutative?
  ক

  Union

  খ

  Intersection

  গ

  Set difference

  ঘ

  None of the mentioned
• Which of the following operations are associative
  ক

  Natural joins

  খ

  Theta joins

  গ

  Both the mentioned

  ঘ

  None of the mentioned
• State true or false: Selection operations are commutative
  ক

  True

  খ

  False
• If on every legal database instant, the two expressions generate the same set of tuples, the expressions are called as
  ক

  Equal

  খ

  Equivalent

  গ

  Similar

  ঘ

  Identical
• Which of the following pair of regular expression are not equivalent?
  ক

  1(01)* and (10)*1

  খ

  x(xx)* and (xx)*x

  গ

  (ab)* and a*b*

  ঘ

  x+ and x*x+
• By default sql server has ___________ isolation level
  ক

  READ COMMITTED

  খ

  READ UNCOMMITTED

  গ

  SERIALIZABLE

  ঘ

  REPEATABLE READ
• Which of the following fixed database roles can add or remove user IDs?
  ক

  db_accessadmin

  খ

  db_securityadmin

  গ

  db_setupadmin

  ঘ

  db_sysadmin
• Problems occurs if we don’t implement a proper locking strategy
  ক

  Dirty reads

  খ

  Phantom reads

  গ

  Lost updates

  ঘ

  Unrepeatable reads
• 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?
  ক

  TINYINT

  খ

  SMALLINT

  গ

  INT

  ঘ

  DECIMAL(1)
• Which utilities can we use to export data from sql server to a text file?
  ক

  DTS export wizard

  খ

  BCP

  গ

  ISQL

  ঘ

  DTS export wizard and BCP
• ___________ refers to the ability of the system to recover committed transaction updates if either the system or the storage media fails.
  ক

  Isolation

  খ

  Atomicity

  গ

  Consistency

  ঘ

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

  XMLSCHEMA option does not returns an in-line XSD schema

  খ

  BINARY BASE32 returns the binary data in base32-encoded format

  গ

  Each row in the query result is transformed into an XML element

  ঘ

  None of the mentioned