Discussion
Home ‣ Database ‣ Managing Databases with Oracle Comments
- Question
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?
Options- A. Open [FileName]
- B. Show [FileName]
- C. Alter [FileName]
- D. Edit [FileName]
- Correct Answer
- Edit [FileName]
- 1. When using SQL*Plus, Oracle commands, column names, table names and all other database elements:
Options- A. are case insensitive.
- B. are case sensitive.
- C. must always be in lower case.
- D. must always be in upper case. Discuss
- 2. Which of the following is not true about indexes?
Options- A. Indexes are created to enforce uniqueness on columns.
- B. Indexes are created to enable fast retrieval by column values.
- C. Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes.
- D. Indexes are created with the ALTER TABLE command. Discuss
- 3. Of the three ways to create an Oracle database, which one is the easiest and most recommended?
Options- A. Using the Oracle Database Configuration Assistant.
- B. Using the Oracle-supplied database creation procedures.
- C. Using the SQL CREATE DATABASE command.
- D. None of the above is correct. Discuss
- 4. Which statement about sequences is not true?
Options- A. A sequence is an object that generates a sequential series of unique numbers.
- B. Sequences are most often used to provide values for surrogate keys.
- C. NextVal and CurrVal are both sequence methods.
- D. Sequences guarantee valid surrogate key values. Discuss
- 5. What Oracle backup and recover file contains user and system data?
Options- A. Control file
- B. Datafile
- C. OnLine ReDo file
- D. Offline ReDo file Discuss
- 6. To see the contents of the SQL*Plus buffer, type:
Options- A. CONTENTS.
- B. BUFFER.
- C. CURRENT.
- D. LIST. Discuss
- 7. 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
- 8. 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
- 9. The default extension for an Oracle SQL*Plus file is:
Options- A. .txt.
- B. .pls.
- C. .ora.
- D. .sql. Discuss
- 10. 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
Managing Databases with Oracle problems
Search Results
Correct Answer: are case insensitive.
Correct Answer: Indexes are created with the ALTER TABLE command.
Correct Answer: Using the Oracle Database Configuration Assistant.
Correct Answer: Sequences guarantee valid surrogate key values.
Correct Answer: Datafile
Correct Answer: LIST.
Correct Answer: Consistent backup
Correct Answer: You cannot increase or decrease the number of decimal places.
Correct Answer: .sql.
Correct Answer: Both :new and :old
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.