Category Archives: Oracle examination

Oracle examination is used globally as the standard matrix to judge candidate capability about Oracle products

I am posting here question  with answers asked in various oracle certification

Most commonly asked 25 oracle plsql interview questions

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 »

Top 10 Oracle Certification Exams 2016 and How to Earn Them

Last updated on August 31st, 2016 at 09:45 amOracle certification are always in demand as it proved your credibility in the market.Here are Top 10 Oracle Certification Exams 2016 and How to Earn Them Top 10 Oracle Certification Exams 2016 Java Programmer Certification track Oracle Database 11g Administrator Certification track Oracle Database 12c Administrator Certification track Database SQL Certification Track Java SE 7 Programmer Oracle … Continue reading Top 10 Oracle Certification Exams 2016 and How to Earn Them »

Oracle examination questions

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 »

Oracle database performance tuning examination part 2

Here are some more questions on  Oracle database performance tuning examination Question 1 What are two main benefits of index- organized tables? A. More concurrency. B. Faster full table scans. C. Fast primary key- based access. D. Less contention on the segment header. E. Less storage is required because there is no duplication of primary key values. Answer: C, E. Question 2. To provide more … Continue reading Oracle database performance tuning examination part 2 »

Oracle performance tuning examination question -1

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 »

All about Oracle certification program

Last updated on August 31st, 2016 at 09:43 amAll about Oracle certification program The oracle certification program certifies a candidate based on its skills in particular oracle product and technology. The certificate is given by Oracle corporation and they are higly valued in IT industry. If two candidate have same skill sets then employer would prefer to choose the person which has Oracle certificate. Many … Continue reading All about Oracle certification program »

sql performance tuning examination questions

Last updated on December 31st, 2015 at 06:03 pmHere are some of sql performance tuning examination questions 1) following an ANALYZE command, which of the following data dictionary views will contain statistics on the number of rows in a table a dbms_rows b dba_table_rows c dbs_tables d dbs_statistics Solution (c) 2) histograms are useful because they allow the optimizer to have a better idea of how … Continue reading sql performance tuning examination questions »

good Oracle sql examination questions with answer

Last updated on December 31st, 2015 at 06:05 pmHere are some of good Oracle sql examination questions with answer 1. You must permanently remove all data from the sales_data table, but will need the table structure in the future. What single command should be issued? a. DROP TABLE sales_data b. TRUNCATE TABLE sales_data c. DELETE FROM sales_data d. TRNCATE TABLE sales_data KEEP STRUCTURE; Solution :(b) … Continue reading good Oracle sql examination questions with answer »