Category Archives: Interviews questions

This page contains interview questions  on following topics

  1. Oracle database
  2. Oracle apps
  3. Oracle sql and plsql
  4. Unix
  5. php
  6. Oracle weblogic
  7. Oracle performance

I  am trying to cover most of the interview asked in these areas

Interviews questions, Oracle, Oracle Database

Step by Step instructions for Oracle Virtual Box Installation

Comment

VirtualBox is a powerful x86 and AMD64/Intel64 virtualization product for enterprise as well as home use VirtualBox runs on Windows, Linux, Macintosh, and Solaris hosts and supports a large number of guest operating systems including but not limited to Windows (NT 4.0, 2000, XP, Server 2003, Vista, Windows 7, Windows 8, Windows 10), DOS/Windows 3.x, Linux (2.4, 2.6, 3.x and 4.x), Solaris and OpenSolaris, OS/2, … Continue reading Step by Step instructions for Oracle Virtual Box Installation »

Interviews questions, Oracle, Oracle Database

Top 46 Oracle ASM Interview Questions

Comment

Oracle ASM is widely used in IT industry. Here I have compiled Top 46 Oracle ASM Interview Questions to enhance the knowledge about Oracle ASM instance Question 1 What is ASM in Oracle? Answer Oracle ASM is Oracle’s volume manager specially designed for Oracle database data. It is available since Oracle database version 10g and many improvements have been made in versions 11g release 1 and … Continue reading Top 46 Oracle ASM Interview Questions »

General, Interviews questions, mysql, Web development

Top 51 Frequently Asked Mysql Interview Questions

Comment

Last updated on September 17th, 2017 at 04:57 pmHere is the compilation of Top 51 Frequently Asked Mysql Interview Questions,I hope you will like that and it will be useful in the interviews 1) What is the difference between sql and Mysql? SQL or Structured Query Language is a programming language designed for managing data held in a Relational Database Management System. Mysql is a open … Continue reading Top 51 Frequently Asked Mysql Interview Questions »

Interviews questions, Unix command and scripts

Must read unix shell scripting interview questions

1 Comment

Last updated on March 20th, 2017 at 04:02 amUnix is used everywhere and knowledge of the operating system is must for any interview. Here are the must read  unix shell scripting interview questions 1) What is Shell Script? Answer A shell script is a collection of command which are executed in a order given. There are conditional statement and looping also available like if ,while which … Continue reading Must read unix shell scripting interview questions »

Interviews questions, Oracle, Oracle Database

Top 40 oracle dba interview questions and answers

3 Comments

Last updated on March 30th, 2018 at 03:02 amThis article contains the most commonly asked top 40 oracle dba interview questions and answers 1) What is oracle database ? Answer: Oracle Database is a relational database management system (RDBMS) which is used to store and retrieve the large amounts of data. Oracle Database had physical and logical structures. Logical structures and physical structures are separated … Continue reading Top 40 oracle dba interview questions and answers »

Interviews questions, Oracle, Oracle Sql

Top 40 Oracle sql interview questions

Comment

Last updated on March 22nd, 2017 at 04:52 amThis article contains Top 40  Oracle sql interview questions asked in various interview. I hope it should help in interviews 1) What is a table Cluster ? Answer: Table Cluster is a group of related tables that share common columns are store related data in the same block. 2) What is exists usage in sql Answer “exists” … Continue reading Top 40 Oracle sql interview questions »

Interviews questions, Oracle, Oracle examination, Oracle Sql

Most commonly asked 25 oracle plsql interview questions

Comment

Last updated on March 20th, 2017 at 03:57 amHere  is the compilation of Most commonly asked oracle plsql interview questions Q1) What is Oracle plsql? Answer PL/SQL is a procedural language extension to Structured Query Language (SQL). The purpose of PL/SQL is to combine database language and procedural programming language Q2) What are the components of a PL/SQL Block? Answer Declarative part, Executable part and Exception … Continue reading Most commonly asked 25 oracle plsql interview questions »

Interviews questions, Oracle, Oracle Ebuisness Suite

40 question you must know about R12.2

Comment
40 questions you must know about R12.2

Last updated on May 4th, 2017 at 05:20 pmR12.2 is the latest release in Oracle EBS area. We are presenting here the most sought over 40 question you must know about R12.2 Question 1: What is Online Patching? Answer: Online patching is a new patching mechanism that is available with R12.2 that allows the application of patches while the system is up and running, and the … Continue reading 40 question you must know about R12.2 »

Interviews questions, Oracle, Oracle Database, Oracle examination

Oracle examination questions

Comment

Question 1. Which two are valid modes for a process requesting latches? A. Scheduled B. Deferred C. Immediate D. Pre- Emptive E. Willing- to- Wait Solution C, E. Question 2. Which three SQL statements can use the NOLOGGING mode to reduce redo operations? A. UPDATE B. CREATE INDEX C. ALTER INDEX …REBUILD D. Conventional Path INSERT E. CREATE TABLE …AS SELECT Solution B, C, E. … Continue reading Oracle examination questions »

Interviews questions, Oracle, Oracle Database

30 Awesome Frequently asked DBA questions

Comment

Last updated on September 4th, 2016 at 05:21 amI am here presenting some of the most commonly asked DBA questions. We have provided the required answer to these DBA questions also Question 1) How to find Database version ? Answer SQL> select * from v$version; The command returns the release information, Question 2) How to find opatch Version ? Answer opatch is utility to apply database patch … Continue reading 30 Awesome Frequently asked DBA questions »

Interviews questions, Oracle, Oracle Ebuisness Suite

60 Awesome oracle apps dba interview questions

Comment

Last updated on March 30th, 2018 at 09:43 amHere is the list of oracle apps dba interview questions, I expect Apps DBA to know Question 1) I am applying a patch , can I open another session and run adadmin ? Answer Yes, We can run unless you are running a process where workers are involved Question 2) I am applying a patch , can … Continue reading 60 Awesome oracle apps dba interview questions »

Interviews questions, Oracle, Oracle Database, Oracle examination

Oracle performance tuning examination question -1

Comment

Oracle performance tuning examination few questions are present below. Question 1.When tables are stored in locally managed tablespaces, where is extent allocation nformation stored? A. Within the locally managed tablespace B. Data dictionary C. Temporary tablespace D. Memory Answer: A Question 2.What are two benefits of storing each table and index partition in a separate tablespace? A. You can backup and recover each partition independently. … Continue reading Oracle performance tuning examination question -1 »