MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Information Science
1000 Oracle Database
Quiz 1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
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
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page