When using SQL*Plus, Oracle commands, column names, table names and all other database elements: must always be in lower case. must always be in upper case. are case sensitive. are case insensitive. TRUE ANSWER : ? YOUR ANSWER : ?
After a table has been created, its structure can be modified using the SQL command: ALTER TABLE [TableName]. CHANGE TABLE [TableName]. UPDATE TABLE [TableName]. MODIFY TABLE [TableName]. TRUE ANSWER : ? YOUR ANSWER : ?
Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values. True False TRUE ANSWER : ? YOUR ANSWER : ?
Oracle commands, column names, table names, view names and all other database elements are case sensitive. False True TRUE ANSWER : ? YOUR ANSWER : ?
What Oracle backup and recover file contains user and system data? Control file Datafile Offline ReDo file OnLine ReDo file TRUE ANSWER : ? YOUR ANSWER : ?
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? Alter [FileName] Show [FileName] Edit [FileName] Open [FileName] TRUE ANSWER : ? YOUR ANSWER : ?
When you type into SQL*Plus and press enter, the statement will be finished and executed. False True TRUE ANSWER : ? YOUR ANSWER : ?
Of the three ways to create an Oracle database, which one is the easiest and most recommended? Using the Oracle Database Configuration Assistant. Using the Oracle-supplied database creation procedures. None of these Using the SQL CREATE DATABASE command. TRUE ANSWER : ? YOUR ANSWER : ?