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!
This form of online analytical processing performs dynamic multidimensional analysis of data stored in a relational database rather than in a multidimensional database.
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.
This is a component of the Oracle9i database product that allows a database to be installed across multiple servers using a shared disk method.
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?
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.
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
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.
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.
In an Oracle index, what is the maximum number of columns that can be used for creating a composite primary key?
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?