Sail E0 Webinar

MCQs

Total Questions : 66 | Page 2 of 7 pages
Question 11. Of the three ways to create an Oracle database, which one is the easiest and most recommended?
  1.    Using the Oracle Database Configuration Assistant.
  2.    Using the Oracle-supplied database creation procedures.
  3.    Using the SQL CREATE DATABASE command.
  4.    None of the above is correct.
 Discuss Question
Answer: Option A. -> Using the Oracle Database Configuration Assistant.
Question 12. When using SQL*Plus, Oracle commands, column names, table names and all other database elements:
  1.    are case insensitive.
  2.    are case sensitive.
  3.    must always be in lower case.
  4.    must always be in upper case.
 Discuss Question
Answer: Option A. -> are case insensitive.
Question 13. What Oracle backup and recover file contains user and system data?
  1.    Control file
  2.    Datafile
  3.    OnLine ReDo file
  4.    Offline ReDo file
 Discuss Question
Answer: Option B. -> Datafile
Question 14. What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?
  1.    Full backup
  2.    Consistent backup
  3.    Inconsistent backup
  4.    Differential backup
 Discuss Question
Answer: Option B. -> Consistent backup
Question 15. Which SQL phrase is not supported by Oracle?
  1.    ON DELETE CASCADE
  2.    ON UPDATE CASCADE
  3.    CREATE SEQUENCE [SequenceName]
  4.    DROP SEQUENCE [SequenceName]
 Discuss Question
Answer: Option B. -> ON UPDATE CASCADE
Question 16. 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.    Show [FileName]
  3.    Alter [FileName]
  4.    Edit [FileName]
 Discuss Question
Answer: Option D. -> Edit [FileName]
Question 17. The default extension for an Oracle SQL*Plus file is:
  1.    .txt
  2.    .pls
  3.    .ora
  4.    .sql
 Discuss Question
Answer: Option D. -> .sql
Question 18. To obtain the structure of an Oracle table, the command to use is:
  1.    STRUCTURE [TableName].
  2.    DESCRIBE [TableName].
  3.    DESCRIBE STRUCTURE [TableName].
  4.    DESC TABLE [TableName].
 Discuss Question
Answer: Option B. -> DESCRIBE [TableName].
Question 19. 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 20. To see the contents of the SQL*Plus buffer, type:
  1.    CONTENTS
  2.    BUFFER
  3.    CURRENT
  4.    LIST
 Discuss Question
Answer: Option D. -> LIST

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