Sail E0 Webinar

MCQs

Total Questions : 63 | Page 4 of 7 pages
Question 31. Views can be used to show the results of computed columns.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 32. A benefit of using a stored procedure is that it can be distributed to client computers.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 33. A trigger is a stored program that is attached to a database.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 34. A stored procedure is a program that performs some common action on database data and is stored in the database.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 35. A SQL view is a virtual table that is constructed from other tables or views.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 36. There are three SQL data modification operations: insert, modify and delete.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 37. SQL statements can be embedded in triggers, stored procedures, and program code.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 38. A view that contains a computed column can be easily updated.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 39. Three types of triggers are: BEFORE, AFTER and EXCEPTION.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 40.  The SQL command to create a table is:
  1.    MAKE TABLE.
  2.    ALTER TABLE.
  3.    DEFINE TABLE.
  4.    CREATE TABLE.
 Discuss Question
Answer: Option D. -> CREATE TABLE.

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