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 July 26th, 2018 at 04:57 pmHere  is the compilation of Most commonly asked oracle plsql interview questions. These will for sure help you in the interview. The questions are from basic to advanced level and covers most of the aspects of the PLSQL programming. I hope you find this useful Question 1) What is Oracle plsql? Answer PL/SQL is a procedural language extension … 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 »