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

Here  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 part. Q3) What are the datatypes a available … Continue reading Most commonly asked 25 oracle plsql interview questions »

Top 10 Oracle Certification Exams 2016 and How to Earn Them

Oracle 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 Certified Associate Oracle Database 11g Administrator Oracle Certified … 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

All 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 times first shortlisting happens on the basis of … Continue reading All about Oracle certification program »

sql performance tuning examination questions

Here 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 the data in an indexed columns is a … Continue reading sql performance tuning examination questions »

good Oracle sql examination questions with answer

good-oracle-sql-examination-questions-with-answer

Here 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) (c) 2. Examine the following command: CREATE TABLE … Continue reading good Oracle sql examination questions with answer »