Oracle dba questions and answers pdf

7.81  ·  9,486 ratings  ·  530 reviews
oracle dba questions and answers pdf

Oracle DBA Interview Questions and Answers - Backup and Recovery | Oracle Database | Sql

Synonym, B. Table space, c System server, d Dynamic data replication Ans : D. Simple snapshots, B. Complex snapshots, C. Neither A nor B Ans : A.
File Name: oracle dba questions and answers
Size: 38492 Kb
Published 13.05.2019

SQL Server DBA interview Questions and Answers 2019 Part-1 -Microsoft- SQL Server-DBA-

check out awesome oracle dba interview questions and answers to Download of oracle dba interview questions as PDF is also given below.

Oracle DBA Interview Questions and Answers - Backup and Recovery

Answer : Small tables do not require indexes; if a query is taking too long, then the table might have grown from small to large. Oracle Text provides text indexing and search capabilities required to index and query data retrieved from the data sources. Q77 Steps to shutdown RAC system. Answer : Don't grant user access directly to tables within the application.

Helpful during Rollback. Answer : Each database user is assigned a Profile that specifies limitations on various system resources available to the user. Answer : Sub-query is a query whose return values are used in filtering conditions of the main query. Key trigger C.

Q48 Difference between sysdba and sysoper user roles. The fourth digit identifies a release level specific to a component. Answer: Following initialization parameters are required for parallelism setup in database. Ans: When a row is too large that it cannot fit in a block, then it will end up using consequent blocks which lead to the concept of Row Chaining.

Q61 Different status of redo log files. Oracle automatically creates, resizes and deletes flashback logs in the flash recovery area d. Q84 What is a control file. While multiple related records in other group can be displayed.

Library support dynamic loading-that is library program units are loaded into an application only when needed. Give Answsrs On Dvf Schema. PLL extension. Find the ODD datatype out A.

Multiple Tablespaces can share a single datafile A. For the following rba which is true 1. Answer : Following factors are considered by a physical query or an execution plan:? What Is Query Execution.

Uploaded by

Top 65 SQL Interview Questions and Answers - SQL Interview Preparation - SQL Training - Edureka

These questions and answers are suitable for both freshers and experienced professionals at any level. It is the medium to connect to the database. Library cache is used to store Oracle statements. Data Dictionary Cache contains the definition of Database objects and privileges granted to users. Data Base buffer cache holds copies of data blocks which are frequently accessed so that they can be retrieved faster for any future requests. The control file is a binary file which has the physical structure of a database.


Tasks include creation of resources related Oracle RAC when new instances are added to the cluster. They are composed of Memory structures and background processes same as the single instance database. Checkpoints occur AFTER not during every redo log switch and also at intervals specified by initialization parameters. Answer : A user named editor has the same text editing functionality as the default answres

Oracle Shutdown steps decoded. Q74 How many standby redo log files should be created. Files are created at specified location, renames files. Answer : An integrity constraint is a declarative way to define a business rule for a column of a table.


  1. Emma W. says:

    We can restore the lost files using the 11 PM full backup which is Restoration. Answer : Oracle VM is the latest virtualization technology from oracle. Znswers be assigned to a global variable B. Invokes a 3Gl program by name which has been properly linked into your current oracle forms executable.

  2. Genciana H. says:

    If you're looking for Oracle DBA Interview Questions for Experienced or Freshers, you are at right place. There are a lot of opportunities from many reputed.

  3. Astolfo M. says:

    0 Interview Questions and Answers

Leave a Reply

Your email address will not be published. Required fields are marked *