logo

CuriousTab

CuriousTab

Managing Databases with Oracle problems

  • 1. The default extension for an Oracle SQL*Plus file is:

  • Options
  • A. .txt.
  • B. .pls.
  • C. .ora.
  • D. .sql.
    • Discuss
  • 2. Which prefixes are available to Oracle triggers?

  • Options
  • A. :new only
  • B. :old only
  • C. Both :new and :old
  • D. Neither :new nor :old
    • Discuss
  • 3. In creating a procedure, you may get a message if you have compile errors. Which of the following is true?

  • Options
  • A. The line numbers reported match the line numbers you see in your text editor.
  • B. SQL*Plus will automatically show the errors to you.
  • C. To see the errors, enter SHOW ERRORS in SQL*Plus.
  • D. If there are no syntax errors, you will receive the message "NO ERRORS."
    • Discuss
  • 4. Which of the following is NOT an Oracle-supported trigger?

  • Options
  • A. BEFORE
  • B. DURING
  • C. AFTER
  • D. INSTEAD OF
    • Discuss
  • 5. An Oracle System Change Number (SCN):

  • Options
  • A. is a value that is incremented whenever a dirty read occurs.
  • B. is incremented whenever a deadlock occurs.
  • C. is a value that keeps track of explicit locks.
  • D. is a value that is incremented whenever database changes are made.
    • Discuss
  • 6. Which of the following is not true of SQL views?

  • Options
  • A. Oracle views cannot use the ORDER BY clause in view definitions.
  • B. Oracle views are created using the standard SQL-92 CREATE VIEW command.
  • C. Oracle views can by queried.
  • D. The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions.
    • Discuss
  • 7. To obtain the structure of an Oracle table, the command to use is:

  • Options
  • A. STRUCTURE [TableName].
  • B. DESCRIBE [TableName].
  • C. DESCRIBE STRUCTURE [TableName].
  • D. DESC TABLE [TableName].
    • Discuss
  • 8. SQL*Plus will finish the statement and execute it when the user types in this:

  • Options
  • A. A left slash ( \ ) followed by [Enter].
  • B. A colon ( : ) followed by [Enter].
  • C. A semicolon ( ; ) followed by [Enter].
  • D. A period ( . ) followed by [Enter].
    • Discuss
  • 9. Which SQL phrase is not supported by Oracle?

  • Options
  • A. ON DELETE CASCADE
  • B. ON UPDATE CASCADE
  • C. CREATE SEQUENCE [SequenceName]
  • D. DROP SEQUENCE [SequenceName]
    • Discuss
  • 10. What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?

  • Options
  • A. Application failure
  • B. Instance Failure
  • C. Media Failure
  • D. Rollback failure
    • Discuss

First 2 3

Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.