Oracle Basic Test! Trivia Questions Quiz

10 Questions | By Rajeshrbhattad | Updated: Mar 22, 2022 | Attempts: 2002

Questions

Settings

Oracle is a relational database management system (RDBMS) officially known as Oracle Database. This software is used by many Corporate IT companies which supports in keeping track and maintaining the database. This application used for processing transaction, business intelligence, and analytics. Take this test your knowledge about the Oracle tools and functions. Let's begin the quiz. All the best!

Questions and Answers

1.

What is wrong with these statements?
- A.
  
  Cursor cursor_name is
- B.
  
  Select first-name into first_name1 from emp
- C.
  
  Declare begin
- D.
  
  Null; end;
- E.
  
  None of above
2.

Which will delete records from the table which cant be rolled back?
- A.
  
  Delete
- B.
  
  Drop
- C.
  
  Truncate
- D.
  
  All of above
- E.
  
  None of above
3.

Which one of the following is not a shutdown command for a database?
- A.
  
  Shutdown partial
- B.
  
  Shutdown Transactional
- C.
  
  Shutdown normal
- D.
  
  Shutdown Immediate
4.

System Change Number (SCN) ________________.
- A.
  
  Is generated for every change in database tables
- B.
  
  Is generated for every checkpoint (CKPT) occurred
- C.
  
  Is generated for every change in database
- D.
  
  Is generated for every change in triggers
5.

Which of the following is not an aspect of logical data model?
- A.
  
  Entity
- B.
  
  Relation
- C.
  
  Attribute
- D.
  
  Object
6.

What does truncate do?
- A.
  
  Deletes all the rows and applies autocommit.
- B.
  
  Deletes rows after last commit.
- C.
  
  Deletes all rows without a commit.
- D.
  
  Deletes rows before last commit.
7.

Which of the following are some important dynamic performance views?
- A.
  
  V$Database, V$Instance, V$trigger, V$logfiles
- B.
  
  V$Database, V$Instance, V$controlfiles, V$logfiles
- C.
  
  V$Database, V$cursor, V$controlfiles, V$logfiles
- D.
  
  None of the above
8.

Triggers are fired on:
- A.
  
  Cursor
- B.
  
  DML statement
- C.
  
  DDL statement
- D.
  
  Insert, Update or Delete
9.

Which of the following is a feature of a tablespace?
- A.
  
  Logical storage unit used to group related data structures
- B.
  
  Memory buffer for storage
- C.
  
  Dedicated memory area for tables storage
- D.
  
  Physical storage unit for data
10.

Which of the following is not the feature of database view?
- A.
  
  Provide additional security
- B.
  
  Hide complexity
- C.
  
  Add portability
- D.
  
  Store complex queries