Managing Databases with Oracle You can use the DROP statement to remove structures from the database. False True False True ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle What type of failure occurs when Oracle fails due to an operating system or computer hardware failure? Instance Failure Application failure Media Failure Rollback failure Instance Failure Application failure Media Failure Rollback failure ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle After a table has been created, its structure can be modified using the SQL command: MODIFY TABLE [TableName]. ALTER TABLE [TableName]. UPDATE TABLE [TableName]. CHANGE TABLE [TableName]. MODIFY TABLE [TableName]. ALTER TABLE [TableName]. UPDATE TABLE [TableName]. CHANGE TABLE [TableName]. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which of the following is not true about indexes? Indexes are created with the ALTER TABLE command. Indexes are created to enforce uniqueness on columns. Indexes are created to enable fast retrieval by column values. Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes. Indexes are created with the ALTER TABLE command. Indexes are created to enforce uniqueness on columns. Indexes are created to enable fast retrieval by column values. Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which statement about sequences is not true? Sequences guarantee valid surrogate key values. Sequences are most often used to provide values for surrogate keys. NextVal and CurrVal are both sequence methods. A sequence is an object that generates a sequential series of unique numbers. Sequences guarantee valid surrogate key values. Sequences are most often used to provide values for surrogate keys. NextVal and CurrVal are both sequence methods. A sequence is an object that generates a sequential series of unique numbers. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values. False True False True ANSWER DOWNLOAD EXAMIANS APP