Sail E0 Webinar

MCQs

Total Questions : 6
Question 1. Which of the following creates a virtual relation for storing the query ?
  1.    Function
  2.    View
  3.    Procedure
  4.    None of the mentioned
 Discuss Question
Answer: Option B. -> View


ViewAny such relation that is not part of the logical model, but is made visible to a
user as a virtual relation, is called a view.


Question 2. Updating the value of the view
  1.    Will affect the relation from which it is defined
  2.    Will not change the view definition
  3.    Will not affect the relation from which it is defined
  4.    Cannot determine
 Discuss Question
Answer: Option A. -> Will affect the relation from which it is defined


Will affect the relation from which it is defined


Question 3. SQL view is said to be updatable (that is, inserts, updates or deletes can be applied on the view) if which of the following conditions are satisfied by the query defining the view?
  1.    The from clause has only one database relation.
  2.    The query does not have a group by or having clause.
  3.    The select clause contains only attribute names of the relation, and does not have any expressions, aggregates, or distinct specification.
  4.    All of the mentioned
 Discuss Question
Answer: Option D. -> All of the mentioned


All of the mentionedAll of the conditions must be satisfied to update the view in sql.


Question 4. Which of the following is the syntax for views where v is view name ?
  1.    Create view v as query name";
  2.    Create query expression" as view;
  3.    Create view v as query expression";
  4.    Create view query expression";
 Discuss Question
Answer: Option B. -> Create query expression" as view;


Create view v as "query expression;is any legal query expression. The view name is represented by v


Question 5. Materialised views make sure that
  1.    View definition is kept stable
  2.    View definition is kept up-to-date
  3.    View definition is verified for error
  4.    View is deleted after specified time
 Discuss Question
Answer: Option B. -> View definition is kept up-to-date


View definition is kept up-to-date


Question 6. Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause ?
  1.    With
  2.    Check
  3.    With check
  4.    All of the mentioned
 Discuss Question
Answer: Option C. -> With check


With checkViews can be defined with a with check option clause at the end of the view definition; then, if a tuple inserted into the view does not satisfy the view's where clause condition, the insertion is rejected by the database system.


Latest Videos
Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)
Direction Sense Test Part 1 Reasoning (Hindi)
Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE
Cube & Cuboid Part 1 Reasoning (Hindi)
Data Interpretation (DI) Basic Concept Reasoning (Hindi)
Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)
Sail E0 free webinar Webinars
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI
Tabulation - Test Paper 2 Data Interpretation Reasoning & DI
Test Paper 1 Direction Sense Test Reasoning & DI
ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0
GFM Combined 1 Free Revision Test SAIL JO E-0