Sail E0 Webinar

MCQs

Total Questions : 39 | Page 1 of 4 pages
Question 1. The SQL command to create a table is:
  1.    ALTER TABLE
  2.    CREATE TABLE
  3.    MAKE TABLE
  4.    DEFINE TABLE
 Discuss Question
Answer: Option B. -> CREATE TABLE
Question 2. The SQL statement to create a view is:
  1.    SELECT VIEW
  2.    CREATE VIEW
  3.    MAKE VIEW
  4.    INSERT VIEW
 Discuss Question
Answer: Option B. -> CREATE VIEW
Question 3. A ________ is a stored program that is attached to a table or a view.
  1.    None of these
  2.    embedded SELECT statement
  3.    pseudofile
  4.    trigger
 Discuss Question
Answer: Option D. -> trigger
Question 4. SQL views can be used to hide:
  1.    complicated SQL syntax only.
  2.    both of the above can be hidden by an SQL view.
  3.    columns and rows only.
  4.    None of these
 Discuss Question
Answer: Option B. -> both of the above can be hidden by an SQL view.
Question 5. The DROP TABLE statement:
  1.    deletes the table structure only.
  2.    deletes the table structure along with the table data.
  3.    is not an SQL statement.
  4.    works whether or not referential integrity constraints would be violated.
 Discuss Question
Answer: Option B. -> deletes the table structure along with the table data.
Question 6. 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 row in a particular underlying table.
  3.    None of these
  4.    a particular column in a particular row.
 Discuss Question
Answer: Option B. -> a particular row in a particular underlying table.
Question 7. For what purposes are views used?
  1.    To hide complicated SQL statements only
  2.    To hide columns only
  3.    To hide rows only
  4.    All of these
 Discuss Question
Answer: Option D. -> All of these
Question 8. What is an SQL virtual table that is constructed from other tables?
  1.    Query results
  2.    A relation
  3.    Just another table
  4.    A view
 Discuss Question
Answer: Option D. -> A view
Question 9. A ________ is a program that performs some common action on database data and that is stored in the database.
  1.    stored procedure
  2.    pseudofile
  3.    None of these
  4.    trigger
 Discuss Question
Answer: Option A. -> stored procedure
Question 10. Which of the following is NOT a type of SQL constraint?
  1.    FOREIGN KEY
  2.    UNIQUE
  3.    ALTERNATE KEY
  4.    PRIMARY KEY
 Discuss Question
Answer: Option C. -> ALTERNATE KEY

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