Managing Databases with Oracle The default extension for SQL*Plus is .sql. True False True False 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 enable fast retrieval by column values. Indexes are created to enforce uniqueness on columns. 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 enable fast retrieval by column values. Indexes are created to enforce uniqueness on columns. Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle After a table has been created, its structure can be modified using the SQL command: UPDATE TABLE [TableName]. MODIFY TABLE [TableName]. ALTER TABLE [TableName]. CHANGE TABLE [TableName]. UPDATE TABLE [TableName]. MODIFY TABLE [TableName]. ALTER TABLE [TableName]. CHANGE TABLE [TableName]. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Oracle commands, column names, table names, view names and all other database elements are case sensitive. False True False True 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
Managing Databases with Oracle To obtain the structure of an Oracle table, the command to use is: DESCRIBE STRUCTURE [TableName]. STRUCTURE [TableName]. DESC TABLE [TableName]. DESCRIBE [TableName]. DESCRIBE STRUCTURE [TableName]. STRUCTURE [TableName]. DESC TABLE [TableName]. DESCRIBE [TableName]. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS