If you've missed any of The Oracle Guru questions, here's another chance to test your knowledge. We've compiled the second group of 10 questions from The Oracle Guru series below. Or, you can go back to the first group of questions here: Oracle Guru Exam #1: A compilation of quizzes 1-10.
This is a program that is assigned to the computer to run without further user interaction. Some are defined to run automatically at a certain time.
Which of the following is NOT a Java Database Connectivity (JDBC) driver type?
In version 8.1, Oracle introduced this statement into SQL, which allowed the use of operators like > and BETWEEN, and permitted different values to be compared in different branches of the statement. It evaluates successive WHEN-conditions and, if true, returns a corresponding THEN-value.
This is sometimes used to describe databases occupying magnetic storage in the terabyte range and containing billions of table rows.
a. decision support system (DSS)
b. multidimensional database (MDB)
c. Very Large Database (VLDB)
d. relational database management system (RDBMS)
e. object-oriented database management system (OODBMS)
This is the oversight of materials, information and finances as they move in a process from supplier to manufacturer to wholesaler to retailer to consumer. It involves coordinating and integrating these flows both within and among companies.
This new feature of Oracle10g defaults to a collection interval every 30 minutes and collects data that is the foundation for all of the other self-tuning features. It is very much like Statspack.
You may get this Oracle error after installing or upgrading to a new database; it occurs when attempting to connect before Oracle has been started. This error states "Oracle not available."
This occurs when a VARCHAR2 value is updated and the length of the new value is longer than the old value and won't fit in the remaining block space -- it will connect to another block instead.
This act seeks to establish standardized mechanisms for electronic data interchange (EDI), security and confidentiality of all healthcare-related data.
This is a technology that incorporates the use of electromagnetic or electrostatic coupling to uniquely identify an object, animal or person. It is coming into increasing use in industry as an alternative to the barcode.