Sail E0 Webinar

MCQs

Total Questions : 50 | Page 1 of 5 pages
Question 1. Which SQL statement would add a record to the database?
  1.    INSERT INTO Designer VALUES ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456')
  2.    INSERT VALUES ('SMI01', 'M Smith', 'mail@msmith.com', 01224123456') INTO Designer
  3.    INSERT ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456') INTO Designer
  4.    INSERT Designer INTO VALUES (''SMI01', 'M Smith', 'mail@msmith.com', '01224123456')
 Discuss Question
Answer: Option A. -> INSERT INTO Designer VALUES ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456')
Question 2. Match SQL language with SQL commands
  1.    1-iii,2-i,3-ii,4-iv
  2.    1-iii,2-ii,3-iv,4-i
  3.    1-ii,2-iii,3-iv,4-i
  4.    1-i,2-iii,3-ii,4-iv
 Discuss Question
Answer: Option C. -> 1-ii,2-iii,3-iv,4-i
Question 3. DELETE FROM r; where r is relation
  1.    Remove relation
  2.    Clear relation entries
  3.    Delete fields
  4.    Delete rows
 Discuss Question
Answer: Option B. -> Clear relation entries
Question 4. Which of the following is an example of a DBMS
  1.    SQL
  2.    Microsoft Office
  3.    PHP
  4.    Oracle
 Discuss Question
Answer: Option D. -> Oracle
Question 5. Collection of information stored in a database at a particular moment is
  1.    view
  2.    schema
  3.    instance
  4.    none of the above
 Discuss Question
Answer: Option C. -> instance
Question 6. The term "Data independence" refers to____
  1.    Data is defined separately and not included in the programs
  2.    Programs are not dependent on the logical attributes of the data
  3.    Programs are not dependent on the physical attributes of the data
  4.    Both B & C
 Discuss Question
Answer: Option C. -> Programs are not dependent on the physical attributes of the data
Question 7. Here which of the following displays the unique values of the column?SELECT ________ dept_nameFROM instructor;
  1.    from
  2.    like
  3.    unique
  4.    distinct
 Discuss Question
Answer: Option D. -> distinct
Question 8. Which one of the following command is used to delete the existing row in a table?
  1.    Delete
  2.    Update
  3.    Insert
  4.    None of the above
 Discuss Question
Answer: Option A. -> Delete
Question 9. How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?
  1.    UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
  2.    MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
  3.    MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
  4.    UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
 Discuss Question
Answer: Option D. -> UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
Question 10. Every Boyee-Codd normal form is in
  1.    1NF
  2.    2Nf
  3.    3NF
  4.    all the above
 Discuss Question
Answer: Option D. -> all the above

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