Discussion
Home ‣ Database ‣ Managing Databases with Oracle Comments
- Question
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].
- Correct Answer
- ALTER TABLE [TableName].
- 1. 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
- 2. 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
- 3. 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
- 4. Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.
Options- A. optimistic
- B. skeptical
- C. ambivalent
- D. None of the above is correct. Discuss
- 5. The process of reading a database schema and producing a data model from that schema is known as:
Options- A. data modeling.
- B. database design.
- C. reverse engineering.
- D. None of the above is correct. Discuss
- 6. 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
- 7. 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
- 8. 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
- 9. 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
- 10. 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
Managing Databases with Oracle problems
Search Results
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: skeptical
Correct Answer: reverse engineering.
Correct Answer: Datafile
Correct Answer: Sequences guarantee valid surrogate key values.
Correct Answer: Using the Oracle Database Configuration Assistant.
Correct Answer: Indexes are created with the ALTER TABLE command.
Correct Answer: are case insensitive.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.