SQL – Using the Group Functions Questions 1. Which of the following is NOT a GROUP BY function? MAX MIN NVL AVG Answer: C. NVL is a general function used to provide alternate value to the NULL values. The functions MAX, MIN and AVG can be used as GROUP BY functions. 2. Which of the […]
Author Archives: user
SQL – Get Data from Multiple Tables Questions 1.Which of the following is not related to a Relational Database? Selection Projection Joining None of the above Answer: D. The options A, B and C are the major capabilities of the Oracle Relational Database. 2.Which of the following methods is used for writing a query with […]
Discuss SQL Certificate Oracle”s Oracle Database 11g: SQL Fundamentals exam is part of the Oracle Certified Oracle Database 11g Administrator track, combining training, experience, and testing to endorse candidates with a strong foundation and expertise in the industry’s most advanced database management system. This certification is to put you on the short list for winning […]