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 on Bissoy. Bissoy App

• 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 will let you define Notepad as your default editor, and whenever you type NOTEPAD, SQL*Plus will invoke Notepad.
  ক

  True

  খ

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

  True

  খ

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

  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
• 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.
• 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 .
• Which of the following is not true of SQL views?
  ক

  Oracle views cannot use the ORDER BY clause in view definitions.

  খ

  Oracle views are created using the standard SQL-92 CREATE VIEW command.

  গ

  Oracle views can by queried.

  ঘ

  The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions.
• Which of the following is not true about indexes?
  ক

  Indexes are created to enforce uniqueness on columns.

  খ

  Indexes are created to enable fast retrieval by column values.

  গ

  Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes.

  ঘ

  Indexes are created with the ALTER TABLE command.
• In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
  ক

  The line numbers reported match the line numbers you see in your text editor.

  খ

  SQL*Plus will automatically show the errors to you.

  গ

  To see the errors, enter SHOW ERRORS in SQL*Plus.

  ঘ

  If there are no syntax errors, you will receive the message "NO ERRORS."
• Which statement about sequences is not true?
  ক

  A sequence is an object that generates a sequential series of unique numbers.

  খ

  Sequences are most often used to provide values for surrogate keys.

  গ

  <i>NextVal</i> and <i>CurrVal</i> are both sequence methods.

  ঘ

  Sequences guarantee valid surrogate key values.
• What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?
  ক

  Application failure

  খ

  Instance Failure

  গ

  Media Failure

  ঘ

  Rollback failure