Sail E0 Webinar

MCQs

Total Questions : 63 | Page 5 of 7 pages
Question 41.  To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
  1.    a particular column in a particular underlying table.
  2.    a particular column in a particular row.
  3.    a particular row in a particular underlying table.
  4.    None of the above is correct.
 Discuss Question
Answer: Option C. -> a particular row in a particular underlying table.
Question 42.  The DROP TABLE statement:
  1.    deletes the table structure only.
  2.    deletes the table structure along with the table data.
  3.    works whether or not referential integrity constraints would be violated.
  4.    is not an SQL statement.
 Discuss Question
Answer: Option B. -> deletes the table structure along with the table data.
Question 43.  Which of the following is NOT a type of SQL constraint?
  1.    PRIMARY KEY
  2.    FOREIGN KEY
  3.    ALTERNATE KEY
  4.    UNIQUE
 Discuss Question
Answer: Option C. -> ALTERNATE KEY
Question 44.  SQL views can be used to hide:
  1.    columns and rows only.
  2.    complicated SQL syntax only.
  3.    both of the above can be hidden by an SQL view.
  4.    None of the above is correct.
 Discuss Question
Answer: Option C. -> both of the above can be hidden by an SQL view.
Question 45.  A ________ is a stored program that is attached to a table or a view.
  1.    pseudofile
  2.    embedded SELECT statement
  3.    trigger
  4.    None of the above is correct.
 Discuss Question
Answer: Option C. -> trigger
Question 46.  The SQL statement to create a view is:
  1.    CREATE VIEW.
  2.    MAKE VIEW.
  3.    SELECT VIEW.
  4.    INSERT VIEW.
 Discuss Question
Answer: Option A. -> CREATE VIEW.
Question 47.  A ________ is a program that performs some common action on database data and that is stored in the database.
  1.    trigger
  2.    stored procedure
  3.    pseudofile
  4.    None of the above is correct.
 Discuss Question
Answer: Option B. -> stored procedure
Question 48.  For what purposes are views used?
  1.    To hide columns only
  2.    To hide rows only
  3.    To hide complicated SQL statements only
  4.    All of the above are uses for SQL views.
 Discuss Question
Answer: Option D. -> All of the above are uses for SQL views.
Question 49. . What is an SQL virtual table that is constructed from other tables?
  1.    Just another table
  2.    A view
  3.    A relation
  4.    Query results
 Discuss Question
Answer: Option B. -> A view
Question 50. . When using the SQL INSERT statement:
  1.    rows can be modified according to criteria only.
  2.    rows cannot be copied in mass from one table to another only.
  3.    rows can be inserted into a table only one at a time only.
  4.    rows can either be inserted into a table one at a time or in groups.
 Discuss Question
Answer: Option D. -> rows can either be inserted into a table one at a time or in groups.

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