Managing Databases with Oracle The default extension for SQL*Plus is .sql. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle What Oracle backup and recover file contains user and system data? Datafile Control file Offline ReDo file OnLine ReDo file Datafile Control file Offline ReDo file OnLine ReDo file ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle SQL*Plus is a text editor. True False True False ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle When using SQL*Plus, Oracle commands, column names, table names and all other database elements: are case insensitive. must always be in upper case. are case sensitive. must always be in lower case. are case insensitive. must always be in upper case. are case sensitive. must always be in lower case. ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle Which SQL phrase is not supported by Oracle? ON DELETE CASCADE ON UPDATE CASCADE DROP SEQUENCE [SequenceName] CREATE SEQUENCE [SequenceName] ON DELETE CASCADE ON UPDATE CASCADE DROP SEQUENCE [SequenceName] CREATE SEQUENCE [SequenceName] ANSWER DOWNLOAD EXAMIANS APP
Managing Databases with Oracle To obtain the structure of an Oracle table, the command to use is: STRUCTURE [TableName]. DESCRIBE STRUCTURE [TableName]. DESCRIBE [TableName]. DESC TABLE [TableName]. STRUCTURE [TableName]. DESCRIBE STRUCTURE [TableName]. DESCRIBE [TableName]. DESC TABLE [TableName]. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS