Basic Operations MCQ

Test your knowledge with important Basic Operations MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Basic Operations MCQs at Bissoy

• While operating with strings, what does “_ _ _%” match with?
  ক

  A string of three letters

  খ

  A string of at least three letters

  গ

  A string of three words

  ঘ

  A string of at least three words
• Which keyword is used to rename a relation in a query?
  ক

  rename

  খ

  as

  গ

  is

  ঘ

  to
• Observe the following query and choose the correct option. select name, ID from student natural join department natural join section
  ক

  The query is syntactically wrong because there is no where clause

  খ

  The query is syntactically wrong because there are more than one attributes in the select clause

  গ

  The query is syntactically wrong because more than one relations are included in the natural join operation

  ঘ

  The query is correct
• What does the natural join operation do?
  ক

  It considers only those pairs of tuples that have the same value on those attributes that appear in the schemas of both relations

  খ

  It considers only those pairs of tuples that have the same value on at least one of the attributes that appear in the schemas of both the relations

  গ

  It considers only those pairs of tuples that do not have the same value on those attributes that appear in the schemas of both relations

  ঘ

  None of the mentioned
• State true or false: Multiple conditions in the where clause are separated by a “,”
  ক

  True

  খ

  False
• If we specify multiple relations in the from clause and do not specify any conditions in the where clause, what will the result be?
  ক

  The natural join of both the relations

  খ

  The left outer join of both the relations

  গ

  A syntactical error

  ঘ

  The Cartesian product of both the relations
• The ________ clause is used to list the attributes desired in the result of a query
  ক

  select

  খ

  from

  গ

  where

  ঘ

  create
• What does the following query do? select name, ID, branch from student, department where student.branch = department.branch;
  ক

  It gives all values of name, ID, branch from both the relations only if all those attributes are present in both

  খ

  It gives all values of name, ID, branch from their respective relations

  গ

  It gives the values of name, ID, branch from their respective relations where the values in the branch attribute are same

  ঘ

  It gives the values of name, ID, branch from their respective relations where all the values are matching with each other
• The where clause is a predicate involving attributes of the relation in the ______ clause.
  ক

  select

  খ

  from

  গ

  with

  ঘ

  none of the mentioned
• Which of the following logical connectives is not included in SQL?
  ক

  and

  খ

  or

  গ

  nor

  ঘ

  not
• Which of the following keywords is used beside the select clause to explicitly specify that duplicates are not removed?
  ক

  all

  খ

  not unique

  গ

  notnull

  ঘ

  include
• Which of the following syntax of the basic query is correct?
  ক

  select <relation> from <attribute>

  খ

  select <attribute> from <elation>

  গ

  select <tuple> from <relation>

  ঘ

  select <tuple> from <attribute>