The Oracle Guru Exam #1: A compilation of quizzes 1-10

If you've missed any of The Oracle Guru questions, here's another chance to test your knowledge. We've compiled the first 10 questions from The Oracle Guru series. Good luck!

If you've missed any of The Oracle Guru questions, here's another chance to test your knowledge. We've compiled the first 10 questions from The Oracle Guru series below. Good luck!

Question #1

This form of online analytical processing performs dynamic multidimensional analysis of data stored in a relational database rather than in a multidimensional database.

a. MOLAP
b. HOLAP
c. ROLAP
d. JOLAP

Click to see if you are correct

Question #2

At this level of normalization, each column in a table that is not a determiner of the contents of another column must itself be a function of the other columns in the table. For example, in a table with three columns containing customer ID, product sold and price of the product when sold, the price would be a function of the customer ID (entitled to a discount) and the specific product.

a. 1NF
b. 2NF
c. 3NF
d. DKNF

Click to see if you are correct

Question #3

This is a component of the Oracle9i database product that allows a database to be installed across multiple servers using a shared disk method.

a. RAC
b. data partitioning
c. OLAP
d. replication

Click to see if you are correct

Question #4

There is no "one size fits all" when talking about RAID configurations for any database, according to SearchOracle.com expert Brian Peasland. But, in his opinion, one RAID level is almost unacceptable for most Oracle databases. It may be the cheapest solution, but its write operations can be twice as slow compared to a normal file system. Which RAID level is he referring to?

a. RAID 0
b. RAID 1
c. RAID 0+1
d. RAID 3
e. RAID 5

Click to see if you are correct

Question #5

There is the analysis of data objects that are used in a business or other context and the identification of the relationships among these data objects. It is a first step in doing object-oriented programming.

a. data mining
b. data modeling
c. data splitting
d. data warehousing
e. data preprocessing

Click to see if you are correct

Question #6

When trying to show inheritance in a table with a parent-child relationship, three main steps are needed, according to SQL and PL/SQL guru Frank Kulash. Which of the following is NOT on of the three main steps?

a. graphically represent database design
b. normalize the data
c. bottom-up hierarchical query
d. find root in hierarchical queries

Click to see if you are correct

Question #7

This technology applies the resources of many computers in a network to a single problem at the same time -- usually to a scientific or technical problem that requires a great number of computer processing cycles or access to large amounts of data.

a. pervasive computing
b. online transaction processing
c. grid computing
d. parallel processing

Click to see if you are correct

Question #8

This feature of Oracle9i allows you to add tempfile entries in read-only mode for the purpose of making queries. You can then perform on-disk sorting operations in a read-only database without affecting dictionary files or generating redo entries.

a. transportable tablespace
b. temporary tablespace
c. Tablespace Map
d. namespace

Click below to see if you are correct

Question #9

In an Oracle index, what is the maximum number of columns that can be used for creating a composite primary key?

a. 18
b. 24
c. 32
d. 36
e. 106

Click to see if you are correct

Question #10

This is a large file, typically an image or sound file, that must be handled (uploaded, downloaded or stored in a database) in a special way because of its size. The main idea is that the handler of the file has no way of understanding the file in order to figure out how to deal with it -- it might as well be a large piece of coal, but there it is and now what?

a. BLOB
b. LONGRAW
c. BFILE
d. CLOB
e. VARCHAR

Click to see if you are correct

Dig deeper on Oracle DBA jobs, training and certification

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close