Sail E0 Webinar

MCQs

Total Questions : 40 | Page 2 of 4 pages
Question 11. Of the three ways to create an Oracle database, which one is the easiest and most recommended?
  1.    None of these
  2.    Using the SQL CREATE DATABASE command.
  3.    Using the Oracle-supplied database creation procedures.
  4.    Using the Oracle Database Configuration Assistant.
 Discuss Question
Answer: Option D. -> Using the Oracle Database Configuration Assistant.
Question 12. When using SQL*Plus, Oracle commands, column names, table names and all other database elements:
  1.    must always be in upper case.
  2.    are case insensitive.
  3.    must always be in lower case.
  4.    are case sensitive.
 Discuss Question
Answer: Option B. -> are case insensitive.
Question 13. What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?
  1.    Differential backup
  2.    Inconsistent backup
  3.    Consistent backup
  4.    Full backup
 Discuss Question
Answer: Option C. -> Consistent backup
Question 14. Which SQL phrase is not supported by Oracle?
  1.    ON DELETE CASCADE
  2.    CREATE SEQUENCE [SequenceName]
  3.    ON UPDATE CASCADE
  4.    DROP SEQUENCE [SequenceName]
 Discuss Question
Answer: Option C. -> ON UPDATE CASCADE
Question 15. What Oracle backup and recover file contains user and system data?
  1.    Control file
  2.    Offline ReDo file
  3.    Datafile
  4.    OnLine ReDo file
 Discuss Question
Answer: Option C. -> Datafile
Question 16. To obtain the structure of an Oracle table, the command to use is:
  1.    DESC TABLE [TableName].
  2.    DESCRIBE STRUCTURE [TableName].
  3.    DESCRIBE [TableName].
  4.    STRUCTURE [TableName].
 Discuss Question
Answer: Option C. -> DESCRIBE [TableName].
Question 17. An Oracle System Change Number (SCN):
  1.    is a value that is incremented whenever a dirty read occurs.
  2.    is incremented whenever a deadlock occurs.
  3.    is a value that keeps track of explicit locks.
  4.    is a value that is incremented whenever database changes are made.
 Discuss Question
Answer: Option D. -> is a value that is incremented whenever database changes are made.
Question 18. To see the contents of the SQL*Plus buffer, type:
  1.    LIST
  2.    CURRENT
  3.    CONTENTS
  4.    BUFFER
 Discuss Question
Answer: Option A. -> LIST
Question 19. The default extension for an Oracle SQL*Plus file is:
  1.    .sql
  2.    .pls
  3.    .txt
  4.    .ora
 Discuss Question
Answer: Option A. -> .sql
Question 20. You have linked SQL*Plus to an external text editor. To invoke the text editor for use within SQL*Plus, which command do you use?
  1.    Open [FileName]
  2.    Alter [FileName]
  3.    Show [FileName]
  4.    Edit [FileName]
 Discuss Question
Answer: Option D. -> Edit [FileName]

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