Sail E0 Webinar

MCQs

Total Questions : 63 | Page 3 of 7 pages
Question 21. The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 22. SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 23. The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 24. Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 25. SQL Server does not support the BEFORE trigger.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 26. A updatable view has its own data.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 27. The SQL DELETE statement is used to delete both the table structure and table data.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 28. Common types of SQL CHECK constraints include range checks and limiting columns values.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 29. When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 30. If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True

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