software development languages Oracle with quiz tests all solved high level programming language Lisp programming language is also a best programming language for designing a software. All simple programming language with top 10 programming languages 2016. What is computer programming language with basic computer programming language and evolution of programming languages.
You Scored:
Ranking:
Past Papers Oracle Questions Answers
1. What is the use of Library cache?
Contains User information, such as user privileges
Used to store shared SQL (Answer)
Log of changes made to the database
All of the Mentioned
2. A data block is?
The largest logical storage unit ever available for any database block
The place where all deleted records are persisted
The smallest logical storage unit for a database object (Answer)
All of the above
3. Which of the following segment is destroyed when the SQL statement is finished?
Temporary Segment (Answer)
Data Segment
Object Segment
All of Above
4. Which processes is an instance made of Oracle?
Memory processes
Data processes
Oracle background processes (Answer)
All of Above
5. Which of the following is not an reason for the fact that most of the processing is done at the server ?
To implement business rules centrally
For application sharing
To reduce network traffic
None of the above (Answer)
6. What is the probable cause for getting the following error stack?
ERROR: ORA-01034: ORACLE not available
ORA-07318: smsget: open error when opening sgadef.dbf file.
HP-UX Error: 2: No such file or directory
The Oracle namespace is shutdown that they are trying to access
The Oracle segment is shutdown that they are trying to access
The Oracle instance is shutdown that they are trying to access (Answer)
All of Above
7. Which of the following is the root directory for oracle?
ORACLE-HOME
ORACLE-BASE (Answer)
ORACLE-ROOT
ORACLE-SERVER
8. Which area of PGA stores binding variables and run-time buffers information?
Session area
Stack space
SQL area
Private SQL area (Answer)
9. What is the use of an index?
Related data requires much less I/O overhead if accessed simultaneously
Retrieve data more quickly and efficiently (Answer)
Simplify the user’s perception of data access
All of them
10. ------------ is an area on disk which comprises of one or more disk files?
A partition
Heap
A package
A table space (Answer)
