Sail E0 Webinar

MCQs

Total Questions : 66 | Page 3 of 7 pages
Question 21. Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 22. Money is defined in Oracle with the Currency data type.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 23. The default extension for SQL*Plus is .sql.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 24. The left-leaning slash tells Oracle to execute whatever statement is in the buffer.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 25. Oracle maintains a System Change Number (SCN) which is a database-wide value that is incremented by Oracle whenever database changes are made.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 26. The semicolon terminates a SQL statement (and executes it).
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 27. SQL*Plus is a text editor.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 28. When you type Start FILENAME, the statement in your file will be executed automatically.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 29. You can check on the status of tables with the DESCRIBE or DESC command.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 30. Oracle directly supports the definition of surrogate keys.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False

Latest Videos

Latest Test Papers