Managing Databases With Oracle MCQ

Test your knowledge with important Managing Databases With Oracle MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Managing Databases With Oracle MCQs at Bissoy

• Oracle, the world's most popular DBMS, is powerful and robust, running on many different operating systems.
  ক

  True

  খ

  False
• You can use the DROP statement to remove structures from the database.
  ক

  True

  খ

  False
• The only time that case matters is inside quotation marks of strings.
  ক

  True

  খ

  False
• If there is only one statement and no ambiguity about what is wanted, Oracle will treat the semicolon and slash as the same.
  ক

  True

  খ

  False
• Oracle commands, column names, table names, view names and all other database elements are case sensitive.
  ক

  True

  খ

  False
• Oracle will let you define Notepad as your default editor, and whenever you type NOTEPAD, SQL*Plus will invoke Notepad.
  ক

  True

  খ

  False
• Sequences guarantee valid surrogate key values.
  ক

  True

  খ

  False
• Oracle does NOT support a CASCADE UPDATE constraint.
  ক

  True

  খ

  False
• Oracle allows the ORDER BY clause in view definitions.
  ক

  True

  খ

  False
• When you type into SQL*Plus and press enter, the statement will be finished and executed.
  ক

  True

  খ

  False
• Oracle directly supports the definition of surrogate keys.
  ক

  True

  খ

  False
• You can check on the status of tables with the DESCRIBE or DESC command.
  ক

  True

  খ

  False
• When you type Start FILENAME, the statement in your file will be executed automatically.
  ক

  True

  খ

  False
• SQL*Plus is a text editor.
  ক

  True

  খ

  False
• The semicolon terminates a SQL statement (and executes it).
  ক

  True

  খ

  False
• Oracle maintains a System Change Number (SCN) which is a database-wide value that is incremented by Oracle whenever database changes are made.
  ক

  True

  খ

  False
• The left-leaning slash tells Oracle to execute whatever statement is in the buffer.
  ক

  True

  খ

  False
• The default extension for SQL*Plus is .sql.
  ক

  True

  খ

  False
• Money is defined in Oracle with the Currency data type.
  ক

  True

  খ

  False
• Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values.
  ক

  True

  খ

  False
• To see the contents of the SQL*Plus buffer, type:
  ক

  CONTENTS

  খ

  BUFFER

  গ

  CURRENT

  ঘ

  LIST
• To obtain the structure of an Oracle table, the command to use is:
  ক

  STRUCTURE .

  খ

  DESCRIBE .

  গ

  DESCRIBE STRUCTURE .

  ঘ

  DESC TABLE .
• 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?
  ক

  Open

  খ

  Show

  গ

  Alter

  ঘ

  Edit
• What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?
  ক

  Full backup

  খ

  Consistent backup

  গ

  Inconsistent backup

  ঘ

  Differential backup
• Which SQL phrase is not supported by Oracle?
  ক

  ON DELETE CASCADE

  খ

  ON UPDATE CASCADE

  গ

  CREATE SEQUENCE

  ঘ

  DROP SEQUENCE
• When using SQL*Plus, Oracle commands, column names, table names and all other database elements:
  ক

  are case insensitive.

  খ

  are case sensitive.

  গ

  must always be in lower case.

  ঘ

  must always be in upper case.
• What Oracle backup and recover file contains user and system data?
  ক

  Control file

  খ

  Datafile

  গ

  OnLine ReDo file

  ঘ

  Offline ReDo file
• Which of the following is not true about modifying table columns?
  ক

  You can drop a column at any time.

  খ

  You can add a column at any time as long as it is a NULL column.

  গ

  You can increase the number of characters in character columns or the number of digits in numeric columns

  ঘ

  You cannot increase or decrease the number of decimal places.
• After a table has been created, its structure can be modified using the SQL command:
  ক

  UPDATE TABLE .

  খ

  MODIFY TABLE .

  গ

  ALTER TABLE .

  ঘ

  CHANGE TABLE .
• SQL*Plus will finish the statement and execute it when the user types in this:
  ক

  A left slash ( ) followed by .

  খ

  A colon ( : ) followed by .

  গ

  A semicolon ( ; ) followed by .

  ঘ

  A period ( . ) followed by .