Sail E0 Webinar

MCQs

Total Questions : 10
Question 1. The default extension for an Oracle SQL*Plus file is:
  1.    .txt
  2.    .pls
  3.    .ora
  4.    .sql
 Discuss Question
Answer: Option D. -> .sql


.sql


Question 2. Which prefixes are available to Oracle triggers?
  1.    : new only
  2.    : old only
  3.    Both :new and : old
  4.    Neither :new nor : old
 Discuss Question
Answer: Option C. -> Both :new and : old


Both :new and : old


Question 3. Which of the following is NOT an Oracle-supported trigger?
  1.    BEFORE
  2.    DURING
  3.    AFTER
  4.    INSTEAD OF
 Discuss Question
Answer: Option B. -> DURING


DURING


Question 4. Triggers ________ enabled or disabled
  1.    Can be
  2.    Cannot be
  3.    Ought to be
  4.    Always
 Discuss Question
Answer: Option A. -> Can be


Can beTriggers can be manipulated.


Question 5. What are the different in triggers ?
  1.    Define, Create
  2.    Drop, Comment
  3.    Insert, Update, Delete
  4.    All of the mentioned
 Discuss Question
Answer: Option C. -> Insert, Update, Delete


Insert, Update, DeleteTriggers are not possible for create,drop.


Question 6. A __________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.
  1.    Procedures
  2.    Triggers
  3.    Functions
  4.    None of the mentioned
 Discuss Question
Answer: Option B. -> Triggers


TriggersTriggers are automatically generated when a particular operation takes place.


Question 7. The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTER INSERT trigger.
  1.    for insert, on
  2.    On, for insert
  3.    For, insert
  4.    Both a and c
 Discuss Question
Answer: Option B. -> On, for insert


On, for insertThe triggers run after an insert, update or delete on a table. They are not supported for views.


Question 8. What are the after triggers ?
  1.    Triggers generated after a particular operation
  2.    These triggers run after an insert, update or delete on a table
  3.    These triggers run after an insert, views, update or delete on a table
  4.    Both b and c
 Discuss Question
Answer: Option B. -> These triggers run after an insert, update or delete on a table


These triggers run after an insert, update or delete on a tableAFTER TRIGGERS can be classified further into three types as: AFTER INSERT Trigger, AFTER UPDATE Trigger. ,AFTER DELETE Trigger.


Question 9. Trigger are supported in
  1.    Delete
  2.    Update
  3.    Views
  4.    All of the mentioned
 Discuss Question
Answer: Option C. -> Views


ViewsThe triggers run after an insert, update or delete on a table. They are not supported for views.


Question 10. The variables in the triggers are declared using
  1.    -
  2.    @
  3.    /
  4.    /@
 Discuss Question
Answer: Option B. -> @


@
declare @empid int; where empid is the variable.


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