• Increase font size
  • Default font size
  • Decrease font size


AddThis Social Bookmark Button

36.) Which of the following is true concerning a procedure?

A.)     You do not create them with SQL.

B.)     They do not need to have a unique name.

C.)     They include procedural and SQL statements.

D.)     They are the same thing as a function.

View Answer

Answer: Option C

37.) Which of the following is one of the basic approaches for joining tables?

A.)     Subqueries

B.)     Union Join

C.)     Natural join

D.)     All of the above

View Answer 

Answer: Option  D

38.) Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater than 8000?

A.)     ORDER BY SALARY > 8000

B.)     WHERE SALARY > 8000

C.)     HAVING SALARY > 8000

D.)     GROUP BY SALARY > 8000

View Answer 

Answer: Option  B

39.) In which scenario would index be most useful?

A.)     The indexed column is declared as NOT NULL.

B.)     The indexed columns are used in the FROM clause.

C.)     The indexed columns are part of an expression.

D.)     The indexed column contains a wide range of values.

View Answer 

Answer:  Option D

40.) Which of the following statements is true concerning subqueries?

A.)     Involves the use of an inner and outer query.

B.)     Cannot return the same result as a query that is not a subquery.

C.)     Does not start with the word SELECT?

D.)     All of the above.

View Answer 

Answer: Option A



Oracle Certification


The Oracle Certification Program is a professional certification program offered by the Oracle Corporation. There are three levels of Oracle Certification in several disciplines: Oracle Certified Associate (OCA), Oracle Certified Professional (OCP), and Oracle Certified Master (OCM).

Java Certification


Sun Certified Professional (SCP) is a professional certification program by Sun Microsystems, a subsidiary of Oracle Corporation. There are two levels of java Certification in several disciplines: Sun Certified Java Associate (SCJA), Sun Certified Java Programmer (SCJP), and Sun Certified Java Developer (SCJD)

Red Hat Certification


The Red Hat Certification Program is Red Hat's professional certification program for Red Hat and general Linux related skills such as system administration on Red Hat Enterprise Linux Red Hat Certified Technician (RHCT)  and Red Hat Certified Engineer (RHCE)