Quiz

Question: 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.
Answer: Option A

Submit Answer & Explaination

Earn Reward Points by submitting Detailed Explaination for this Question

More Questions on This Topic :

Question 1. What Oracle backup and recover file contains user and system data?
  1.    Control file
  2.    Datafile
  3.    OnLine ReDo file
  4.    Offline ReDo file
Answer: Option B
Question 2. What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?
  1.    Full backup
  2.    Consistent backup
  3.    Inconsistent backup
  4.    Differential backup
Answer: Option B
Question 3. Which SQL phrase is not supported by Oracle?
  1.    ON DELETE CASCADE
  2.    ON UPDATE CASCADE
  3.    CREATE SEQUENCE [SequenceName]
  4.    DROP SEQUENCE [SequenceName]
Answer: Option B
Question 4. Of the three ways to create an Oracle database, which one is the easiest and most recommended?
  1.    Using the Oracle Database Configuration Assistant.
  2.    Using the Oracle-supplied database creation procedures.
  3.    Using the SQL CREATE DATABASE command.
  4.    None of the above is correct.
Answer: Option A
Question 5. Which of the following is not true about modifying table columns?
  1.    You can drop a column at any time.
  2.    You can add a column at any time as long as it is a NULL column.
  3.    You can increase the number of characters in character columns or the number of digits in numeric columns
  4.    You cannot increase or decrease the number of decimal places.
Answer: Option D
Question 6. After a table has been created, its structure can be modified using the SQL command:
  1.    UPDATE TABLE [TableName].
  2.    MODIFY TABLE [TableName].
  3.    ALTER TABLE [TableName].
  4.    CHANGE TABLE [TableName].
Answer: Option C

Check all Questions in this Topic : Click HERE

Recent Questions

Q. Most Of The Radiation Emitted By A Human Body Is In The Form....Q. Find The Missing Term: 11, 10, ?, 100, 1001, 1000, 10001....Q. The Degree And Order Of The Differential Equation Of The Fam....Q. SUM, AVG, MIN, And MAX Can Only Be Used With Numeric Columns....Q. The Function Of Cutting Oil When Threading A Pipe Is To....Q. In Index Of Financial Inclusion Has Been Launched For The Fi....Q. The Working Pressure And Temperature Inside The Cylinder Of ....Q. In Case Of __________ Boiling, The Liquid Temperature Is Bel....Q. The Product Of Mass And Acceleration Of Flowing Liquid Is Ca....Q. The Maximum Count Which A 6-bit Binary Word Can Represent Is....Q. I Have A Bone To Pick With You In This Matter.....Q. Rosin Soap Is Added During Paper Manufacture To....Q. Break-even Analysis Consists Of....Q. ___________ Has A Grammar But Unlike Traditional (X)HTML It ....Q. Verification Of Financial Statements Is....Q. The First Step Of The Implementation Phase Is....Q. Which Of The Following Material Of Construction May Be Recom....Q. A Man Goes From Mysore To Bangalore At A Uniform Speed Of 40....Q. Which Of The Following Liquids Has The Least Density ?....Q. What Estimate Would You Give For The Variance In Above Probl....Q. Write The coefficients And Terms Of The Algebraic Expre....Q. 10−4 G Of Gelatin Is Required To Be Added To 100 Cm3&....Q. In Case Of A Hammer Crusher, The....Q. Constituents Of Stellite Are....Q. Flooding In A Vapor-liquid Contacting Equipment Occurs In A ....Q. Parasitic Disease is ___ limiting Population.....Q. The Percentage Of Voids In Cement Is Approximately....Q. The Average Thickness Of Ozone Layer In Stratosphere Is Abou....Q. The Constitution Provides Prohibition Of Traffic In Human Be....Q. The Common Name For The Crime Of Stealing Passwords Is:....Q. __________ Of Depreciation Calculation Does Not Take Into Ac....Q. A Quantity Whose Dimensions Are M2l2t3 could Be The Product....Q. Line AB Is A Line Of Symmetry. True Or False.....Q. Which Of The Following Right Has Been Removed From Fundament....Q. Suppose A Is An Abstract Class, B Is A Concrete Subclass Of ....Q. Directions : In Each Of The Following Questions A Statement ....Q. The Vapour Pressure Over The Concave Surface Is....Q. When You P : Which One Is Closest In Meaning Q : Read The Fo....Q. Synonym Of DEAR....Q. If Concentration Of OH−ions In The Reaction  Fe(....Q. Directions : In Each Of The Following Questions A Statement ....Q.  who Launched Ibm's First Pc In 1981?....Q. The Bond Dissociation Energy Of H - H, C - C, And C - H Bond....Q.  a Square Room Has A Verandah Of Uniform Width Of 3m Around....Q. The Factors Which Are To Be Considered While Developing A Go....Q. To Update An SQL View, The DBMS Must Be Able To Associate Th....Q. A Circle Has A Circumference Of 70 Meters. Find Its Area. [2....Q. In Any A.C. Circuit Always....Q. The Function Of King Post In A King Post Roof Truss Is....Q. For External Style Sheets In Some Cases When @import Is Used....