Sail E0 Webinar

MCQs

Total Questions : 109 | Page 2 of 11 pages
Question 11. Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
  1.    Data Definition Language(DDL)
  2.    Data Manipulation Language(DML)
  3.    Both of above
  4.    None
 Discuss Question
Answer: Option A. -> Data Definition Language(DDL)
Question 12. Which operator performs pattern matching?
  1.    BETWEEN operator
  2.    LIKE operator
  3.    EXISTS operator
  4.    None of these
 Discuss Question
Answer: Option B. -> LIKE operator
Question 13. In SQL, which command(s) is(are) used to change a table's storage characteristics?
  1.    ALTER TABLE
  2.    MODIFY TABLE
  3.    CHANGE TABLE
  4.    All of the above
 Discuss Question
Answer: Option A. -> ALTER TABLE
Question 14. What operator tests column for the absence of data?
  1.    EXISTS operator
  2.    NOT operator
  3.    IS NULL operator
  4.    None of these
 Discuss Question
Answer: Option C. -> IS NULL operator
Question 15. In SQL, which of the following is not a data definition language commands?
  1.    RENAME
  2.    REVOKE
  3.    GRANT
  4.    UPDATE
 Discuss Question
Answer: Option D. -> UPDATE
Question 16. A command that lets you change one or more fields in a record is
  1.    Insert
  2.    Modify
  3.    Look-up
  4.    All of the above
 Discuss Question
Answer: Option B. -> Modify
Question 17. In SQL, which command is used to SELECT only one copy of each set of duplicable rows
  1.    SELECT DISTINCT
  2.    SELECT UNIQUE
  3.    SELECT DIFFERENT
  4.    All of the above
 Discuss Question
Answer: Option A. -> SELECT DISTINCT
Question 18. Which of the SQL statements is correct?
  1.    SELECT Username AND Password FROM Users
  2.    SELECT Username, Password FROM Users
  3.    SELECT Username, Password WHERE Username = 'user1'
  4.    None of these
 Discuss Question
Answer: Option B. -> SELECT Username, Password FROM Users
Question 19. The FROM SQL clause is used to...
  1.    specify what table we are selecting or deleting data FROM
  2.    specify range for search condition
  3.    specify search condition
  4.    None of these
 Discuss Question
Answer: Option A. -> specify what table we are selecting or deleting data FROM
Question 20. Which SQL keyword is used to retrieve only unique values?
  1.    DISTINCTIVE
  2.    UNIQUE
  3.    DISTINCT
  4.    DIFFERENT
 Discuss Question
Answer: Option C. -> DISTINCT

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