Sail E0 Webinar

MCQs

Total Questions : 109 | Page 11 of 11 pages
Question 101. Which operator is used to search for a specified pattern in a column?
  1.    FROM
  2.    GET
  3.    LIKE
  4.    None of these
 Discuss Question
Answer: Option C. -> LIKE
Question 102. The NOT NULL constraint enforces a column to not accept NULL values
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 103. Which of the following is true about the execution section of a PL/SQL block
  1.    It is enclosed between the keywords BEGIN and END.
  2.    It is a mandatory section.
  3.    It consists of the executable PL/SQL statements.
  4.    All of the above.
 Discuss Question
Answer: Option D. -> All of the above.
Question 104. _____cursor is declared by ORACLE for each UPDATE, DELETE and INSERT SQL commands
  1.    Internal
  2.    External
  3.    Implicit
  4.    Explicit
 Discuss Question
Answer: Option C. -> Implicit
Question 105. How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
  1.    UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
  2.    UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'
  3.    MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'
  4.    MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen
 Discuss Question
Answer: Option A. -> UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
Question 106. Which SQL statement is used to create a table in a database?
  1.    CREATE DATABASE TABLE
  2.    CREATE DB
  3.    CREATE TABLE
  4.    CREATE DATABASE TAB
 Discuss Question
Answer: Option C. -> CREATE TABLE
Question 107. What does database contains?
  1.    Excel Sheets
  2.    Rows and Columns
  3.    Only raw Data
  4.    Tables and relations between them
 Discuss Question
Answer: Option D. -> Tables and relations between them
Question 108. What are the Different Types of Keys?
  1.    Primary Key and Secondary Key
  2.    Foreign Key and Secondary Key
  3.    Indian Key and Foreign Key
  4.    Primary Key and Foreign Key
 Discuss Question
Answer: Option D. -> Primary Key and Foreign Key
Question 109. What are the characteristics of DBMS?
  1.    Real-world entity
  2.    Less Redundancy
  3.    Relation based Tables
  4.    All of the above
 Discuss Question
Answer: Option D. -> All of 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