Q.1
What is Oracle?
  • a) Oracle is a programming language
  • b) Oracle is a database
  • c) Oracle is a sripting language
  • d) Oracle is an operating system
Q.2
Which of the following is correct about Oracle?
  • a) Oracle is a relational database management system
  • b) Oracle was built in 1977
  • c) OracleDB is another name for it
  • d) All of the mentioned
Q.3
Which of the following database was designed first for enterprise grid computing?
  • a) Oracle database
  • b) SQL
  • c) MongoDB
  • d) Google database
Q.4
Which of the following is not a Oracle Database feature?
  • a) Scalability
  • b) Availability
  • c) Analytics
  • d) None of the mentioned
Q.5
Which of the following is an advantage of Oracle database?
  • a) Portability
  • b) Flashback Technology
  • c) Performance
  • d) All of the mentioned
Q.6
Which of the following is a disadvantage of Oracle database?
  • a) Difficult to manage
  • b) Cost
  • c) Complexity
  • d) All of the mentioned
Q.7
What is Oracle database used for?
  • a) Creating backup for data
  • b) Accessing database servers
  • c) Store and retrieve relevant data
  • d) Both a & c
Q.8
Which of the following components comprise an Oracle architecture?
  • a) Tablespaces
  • b) Datafiles
  • c) Database related background processes
  • d) All of the Mentioned
Q.9
Which of the following area of PGA stores binding variables and run-time buffers information?
  • a) Stack space
  • b) SQL area
  • c) Session area
  • d) Private SQL area
Q.10
Which of the following is the smallest unit of storage in an Oracle database?
  • a) Segment
  • b) Extent
  • c) Data File
  • d) Data Block
Q.11
Which of the following is another name of Oracle database’s design?
  • a) Database Instance
  • b) Database Schema
  • c) Database Abstraction
  • d) None of the Mentioned
Q.12
Which of the following is used to logically group data together?
  • a) Tablespace
  • b) Datafiles
  • c) Object
  • d) Database
Q.13
Which of the following package procedure is UNRESTRICTED in Oracle?
  • a) CLEAR_BLOCK
  • b) USER_EXIT
  • c) CALL_INPUT
  • d) EXECUTE_QUERY
Q.14
Oracle server configuration is dedicated for
  • a) One server process – One user process
  • b) Many server processes – Many user processes
  • c) Many server processes – One user process
  • d) One server process – Many user processes
Q.15
Which schema object instructs Oracle to connect to remotely access an object of a database?
  • a) Database Link
  • b) Sequence
  • c) Data Link
  • d) Remote Link
Q.16
When a transaction modifies the database, Oracle copies the original data before modifying it. What is the original copy of the modified data called?
  • a) Redo Data
  • b) Undone Data
  • c) Undo Data
  • d) Archive Data
Q.17
A new user on the database is created by executing the following command:
  • a) The user cannot query any tables
  • b) The user can not create tables
  • c) The user can create tables
  • d) None of the Mentioned
Q.18
Which of the following is referred to as the language used application programs to request data from the DBMS?
  • a) DDL
  • b) Query language
  • c) DML
  • d) All of the Mentioned
Q.19
Which of the following RDBMS supports full fledged client server application development?
  • a) FoxPro 2.1
  • b) Ingress
  • c) Oracle 7.1
  • d) dBase V
Q.20
Which of the following is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
  • a) Data Manipulation Language(DML)
  • b) Data Definition Language(DDL)
  • c) DDL and DML
  • d) None of the Mentioned
0 h : 0 m : 1 s