Discussion
Home ‣ Database ‣ Managing Databases with Oracle Comments
- Question
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.
- Correct Answer
- Using the Oracle Database Configuration Assistant.
- 1. 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
- 2. 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
- 3. After a table has been created, its structure can be modified using the SQL command:
Options- A. UPDATE TABLE [TableName].
- B. MODIFY TABLE [TableName].
- C. ALTER TABLE [TableName].
- D. CHANGE TABLE [TableName]. Discuss
- 4. Database redesign is not terribly difficult if the:
Options- A. database is structured.
- B. database is well-designed.
- C. database has no data.
- D. database is relatively small. Discuss
- 5. What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
Options- A. ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0);
- B. ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);
- C. ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
- D. None of the above is correct. Discuss
- 6. 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
- 7. 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
- 8. 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] Discuss
- 9. To see the contents of the SQL*Plus buffer, type:
Options- A. CONTENTS.
- B. BUFFER.
- C. CURRENT.
- D. LIST. Discuss
- 10. 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
Managing Databases with Oracle problems
Search Results
Correct Answer: Sequences guarantee valid surrogate key values.
Correct Answer: Datafile
Correct Answer: ALTER TABLE [TableName].
Correct Answer: database has no data.
Correct Answer: ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
Correct Answer: Indexes are created with the ALTER TABLE command.
Correct Answer: are case insensitive.
Correct Answer: Edit [FileName]
Correct Answer: LIST.
Correct Answer: Consistent backup
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.