logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Managing Databases with Oracle Comments
  • Question

  • 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."

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

    • Managing Databases with Oracle problems

    Search Results

    • 1. 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
    • 2. The default extension for an Oracle SQL*Plus file is:

    • Options
    • A. .txt.
    • B. .pls.
    • C. .ora.
    • D. .sql.
      • Discuss
    • 3. Which of the following is not true about modifying table columns?

    • Options
    • A. You can drop a column at any time.
    • B. You can add a column at any time as long as it is a NULL column.
    • C. You can increase the number of characters in character columns or the number of digits in numeric columns
    • D. You cannot increase or decrease the number of decimal places.
      • Discuss
    • 4. What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?

    • Options
    • A. Full backup
    • B. Consistent backup
    • C. Inconsistent backup
    • D. Differential backup
      • Discuss
    • 5. To see the contents of the SQL*Plus buffer, type:

    • Options
    • A. CONTENTS.
    • B. BUFFER.
    • C. CURRENT.
    • D. LIST.
      • Discuss
    • 6. Which of the following is NOT an Oracle-supported trigger?

    • Options
    • A. BEFORE
    • B. DURING
    • C. AFTER
    • D. INSTEAD OF
      • Discuss
    • 7. 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
    • 8. 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
    • 9. 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
    • 10. 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

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.