Oracle Implementations Interview Questions

Oracle Implementations interview questions

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

1. How many columns are presented after executing this query:

A. 1

B. 2

C. 3

D. 0

Correct Answer is : 1

2. What was a problem with navigational data access languages?

A. The user had to have knowledge of the table and index structures.

B. Navigational data access was far slower than declarative access.

C. Navigational access languages required the coder to embed their queries inside a procedural language shell.

D. Navigational languages were far slower then SQL

Correct Answer is : The user had to have knowledge of the table and index structures.

3. Which Oracle access method is the fastest way for Oracle to retrieve a single row?

A. Primary key access

B. Access via unique index

C. Table access by ROWID

D. Full table scan

Correct Answer is : Table access by ROWID

4. Which is a major problem with SQL?

A. SQL cannot support object-orientation

B. The same query can be written in many ways, each with vastly different execution plans.

C. SQL syntax is too difficult for non-computer professionals to use

D. SQL creates excessive locks within the database

Correct Answer is : The same query can be written in many ways, each with vastly different execution plans.

5. Which of the following can be a valid column name?

A. Column

B. 1966_Invoices

C. Catch_#22

D. #Invoices

Correct Answer is : Catch_#22

Oracle Implementations interview questions