Oracle Database Administration Interview Questions You'll Most..

Price: $19.95
Sale: $16.56
Save: 17% off


Oracle Database Administration Interview Questions You'll Most Likely Be Asked is a perfect companion to stand ahead above the rest in today’s competitive job market. Rather than going through comprehensive, textbook-sized reference guides, this book includes only the information required immediately for job search to build an IT career. This book puts the interviewee in the driver's seat and helps them steer their way to impress the interviewer.


Table of contents

1. Basic Administration
2 Creating and Configuring an Oracle Database
3 Database States and Database Operations
4 Oracle Background Processes
5 Patches and Upgrades
6 Database External Utilities
7 Sessions and Processes
8 Schemas and Schema Objects
9 Data Integrity
10 Data Dictionary and Dynamic Performance Views
11 SQL
12 Programming
13 Data Concurrency and Consistency
14 Transactions
15 Storage Structures
16 Oracle Instance Architecture
17 Oracle Database Memory Structures
18 Application and Networking Architecture
19 Oracle Database Security.
20 Maximum Availability Architecture
HR Questions



(a) 280 Oracle Database Administration Interview Questions, Answers and Proven Strategies for getting hired as an IT professional

(b) Dozens of examples to respond to interview questions

(c) 77 HR Questions with Answers and Proven strategies to give specific, impressive, answers that help nail the interviews

(d) 2 Aptitude Tests download available on website



COM021040 COMPUTERS / Databases / Data Warehousing


Sample from the book
(Below Questions and Answers are randomly taken from different pages of the book)


1: You as a DBA just gathered the statistics on schema A. Schema A has 1500 tables. You want to know the name of the table with the highest number of records without running a count on each. How do you do this?


You query the NUM_ROWS column in the DBA_TABLES table. After running the statistics, this field is populated with current and updated data, and it is simple and quick method for getting this information without going to every table and counting the records.


110: What is a foreign key constraint?


A foreign key constraint is created for a column and it references a unique key on another table or in the same table. The foreign key constraint guarantees that there will be an occurrence of the column value in the referenced unique key constraint.

The referenced key can be either a unique key or a primary key. The referenced constraint is mandatory.

This constraint establishes a parent-child relation between two tables. The referenced table is the parent table and the other table is the child table.

The foreign key can also be defined for multiple columns. In such a case, the referenced key should also be a multiple column key and it should contain the same number of rows and same data types. The order of the columns should also match.


106: What is a “unique constraint” and why would you need that?


A “unique constraint” guarantees that a column or a combination of multiple columns will be unique inside a table.

For example, you have a “customers” table. This table has a “phone_number” column which stores the phone numbers of the customers. You want this column to be unique inside the table. Here, you need to create a unique key constraint on the “phone_number” column. In such a situation, if a customer tries to insert a phone number which already resides in that column, Oracle will raise an error. This way, the uniqueness of “phone_number” column is satisfied. The constraint will be forced for all insert and update statements.


247: What are the three types of buffer pools in database buffer cache?


There are three types of buffer pools in database buffer cache.

a) Default Buffer Pool: This is the default buffer pool where the data blocks are cached.

b) Recycle Pool: Objects that are explicitly targeted for removal because of infrequent access are placed in this pool.

c) Keep Pool: Objects that are explicitly targeted to remain in the buffer cache are put into this pool.

The recycle pool and keep pool has to be explicitly enabled. The default buffer is created as a default.


250: What is “Large Pool” in System Global Area?


Large pool is an optional memory region inside System Global Area. It is used for operations where large size of memory needs to be allocated. For example, the large pool is used when taking backup with RMAN (Recovery Manager). The large pool also stores user global area (UGA) if you have shared server architecture. Additionally, the large pool is also used during parallel execution of SQL statements. The message buffers are kept in the large pool.



Oracle DBA, Database Administration, Oracle Database, Job Interview Oracle, Interview questions oracle, Oracle DBA interview, Database administration interview