Article

Oracle Guru Exam #2: A compilation of quizzes 11-20

SearchOracle.com editors

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.

    Requires Free Membership to View

Good luck!

Question #11

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.

a. initial program load
b. application program
c. batch job
d. exit program

Click to see if you are correct!

Question #12

Which of the following is NOT a Java Database Connectivity (JDBC) driver type?

a. JDBC-ODBC bridge
b. Native API driver
c. JDBC network-protocol driver
d. ASPI driver
e. Native protocol (100% Java driver)

Click to see if you are correct!

Question #13

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.

a. DECODE
b. Searched CASE
c. Simple CASE

Click to see if you are correct!

Question #14

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)

Click to see if you are correct!

Question #15

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.

a. supply chain management
b. procurement management
c. product lifecycle management
d. demand planning
e. manufacturing

Click to see if you are correct!

Question #16

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.

a. Automatic Storage Management
b. Automatic Maintenance Tasks
c. Automatic Database Diagnostic Monitor
d. Automatic Memory Management
e. Automatic Workload Repository

Click to see if you are correct!

Question #17

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."

a. ORA-01034
b. ORA-01555
c. ORA-04031
d. ORA-12154
e. ORA-29516

Click to see if you are correct!

Question #18

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.

a. logical block addressing
b. tree structure
c. row chaining
d. rollback

Click to see if you are correct!

Question #19

This act seeks to establish standardized mechanisms for electronic data interchange (EDI), security and confidentiality of all healthcare-related data.

a. Sarbanes-Oxley Act
b. HIPAA
c. Patriot Act
d. Gramm-Leach-Bliley Act

Click to see if you are correct!

Question #20

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.

a. PID
b. RID
c. RFID
d. SID

Click to see if you are correct!


There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: