• HOME
  • QUIZ
  • CONTACT US
EXAMIANS
  • COMPUTER
  • CURRENT AFFAIRS
  • ENGINEERING
    • Chemical Engineering
    • Civil Engineering
    • Computer Engineering
    • Electrical Engineering
    • Mechanical Engineering
  • ENGLISH GRAMMAR
  • GK
  • GUJARATI MCQ

Managing Databases with Oracle

Managing Databases with Oracle
To see the contents of the SQL*Plus buffer, type:

LIST
CONTENTS
BUFFER
CURRENT

ANSWER DOWNLOAD EXAMIANS APP

Managing Databases with Oracle
SQL*Plus will finish the statement and execute it when the user types in this:

A semicolon ( ; ) followed by [Enter].
A left slash ( ) followed by [Enter].
A period ( . ) followed by [Enter].
A colon ( : ) followed by [Enter].

ANSWER DOWNLOAD EXAMIANS APP

Managing Databases with Oracle
Oracle maintains a System Change Number (SCN) which is a database-wide value that is incremented by Oracle whenever database changes are made.

False
True

ANSWER DOWNLOAD EXAMIANS APP

Managing Databases with Oracle
Which prefixes are available to Oracle triggers?

:old only
Both :new and :old
Neither :new nor :old
:new only

ANSWER DOWNLOAD EXAMIANS APP

Managing Databases with Oracle
The default extension for an Oracle SQL*Plus file is:

.sql
.pls
.ora
.txt

ANSWER DOWNLOAD EXAMIANS APP

Managing Databases with Oracle
The semicolon terminates a SQL statement (and executes it).

False
True

ANSWER DOWNLOAD EXAMIANS APP
MORE MCQ ON Managing Databases with Oracle

DOWNLOAD APP

  • APPLE
    from app store
  • ANDROID
    from play store

SEARCH

LOGIN HERE


  • GOOGLE

FIND US

  • 1.70K
    FOLLOW US
  • EXAMIANSSTUDY FOR YOUR DREAMS.
  • SUPPORT :SUPPORT EMAIL ACCOUNT : examians@yahoo.com

OTHER WEBSITES

  • GUJARATI MCQ
  • ACCOUNTIANS

QUICK LINKS

  • HOME
  • QUIZ
  • PRIVACY POLICY
  • DISCLAIMER
  • TERMS & CONDITIONS
  • CONTACT US
↑