Discussion
Home ‣ Database ‣ Managing Databases with Oracle Comments
- Question
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.
- Correct Answer
- Sequences guarantee valid surrogate key values.
- 1. 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
- 2. 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
- 3. 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
- 4. 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
- 5. Which of the following modifications may not succeed?
Options- A. Changing a column data type from char to date
- B. Changing a column data type from numeric to char
- C. Both of the above actions should succeed.
- D. Neither of the above actions will succeed. Discuss
- 6. 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
- 7. 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
- 8. 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
- 9. 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
- 10. To see the contents of the SQL*Plus buffer, type:
Options- A. CONTENTS.
- B. BUFFER.
- C. CURRENT.
- D. LIST. Discuss
Managing Databases with Oracle problems
Search Results
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: Changing a column data type from char to date
Correct Answer: Using the Oracle Database Configuration Assistant.
Correct Answer: Indexes are created with the ALTER TABLE command.
Correct Answer: are case insensitive.
Correct Answer: Edit [FileName]
Correct Answer: LIST.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.