Sail E0 Webinar

MCQs

Total Questions : 40 | Page 3 of 4 pages
Question 21. 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 22. The default extension for SQL*Plus is .sql.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 23. Money is defined in Oracle with the Currency data type.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 24. The left-leaning slash tells Oracle to execute whatever statement is in the buffer.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 25. 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 26. Oracle directly supports the definition of surrogate keys.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 27. 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 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. The semicolon terminates a SQL statement (and executes it).
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 30. SQL*Plus is a text editor.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True

Latest Videos

Latest Test Papers