1Z Study Guide Pdf. The Most Recommended 1Z Exam Questions With Answers On Sale Smart Cities Vlaanderen. In recent months, the demon and. OCP: Oracle Database 12c Administrator Certified Professional Study Guide: Exam chapter review questions, electronic flashcards, searchable PDF glossary. Database Gateway for APPC Installation and Configuration Guide for AIX 5L Based Systems (Bit), HP-UX Itanium, Solaris Operating System (SPARC Bit).
|Language:||English, Spanish, Dutch|
|Country:||United Arab Emirates|
|ePub File Size:||28.59 MB|
|PDF File Size:||11.12 MB|
|Distribution:||Free* [*Regsitration Required]|
7 6 5 4 3 2 1 Dear Reader, Thank you for choosing OCA: Oracle Database 12c Administrator Certified Associate Study Guide. This book is part of a family. OCA: Oracle ® Database 12c Administrator Certified Associate Study Guide Biju .. Electronic Flashcards Bonus Author Materials PDF of Glossary of. Roopesh Ramklass (Canada) is an Oracle Certified Master with expertise in User Group conferences and is the author of several technology books. About the .
You query the database with the following: For example, product and patent—one product might have a patent, and one patent corresponds to only one product. Contains a high-level text description of the SQL syntax used to manage information in Oracle Database. List the buffer to verify its contents: Startup will fail, because you have not completed the instance recovery. Open Safari and navigate to Preferences. You can also find supplemental reading material and Oracle documentation references on my blog that will deepen your knowledge of what you read in this book.
Looks like you are currently in Ukraine but have requested a page in the United States site. Would you like to change to the United States site? Robert G. Freeman , Charles A. As the most popular database software in the world, Oracle Database 12c has been updated for the first time in nearly six years and the changes are significant. This study guide reviews how Oracle 12c allows multiple instances to be used simultaneously via the cloud.
You'll sharpen your skills to prepare for the three levels of certification: Workbook exercise appendix, test engine, chapter review questions, electronic flashcards, searchable PDF glossary, and two bonus practice exams all help to enhance your preparation to take the Oracle 12c exam. Focusing percent on the exam objectives, OCP: Oracle Database 12c Administrator Certified Professional Study Guide is designed for those who feel they are ready to attempt this challenging exam.
He frequently speaks on Oracle database topics.
Charles A. Undetected country. NO YES. Exam 1Z Selected type: Added to Your Shopping Cart. A foreign key is a column or collection of columns in one table that uniquely identifies a row of another table, defining the relationship between the tables. Records in a database table can be seen as instances of the entity. Each occurrence of an entity is differentiated by the values of the attributes. Oracle stores these records as rows of the table and the attributes as columns in each row.
In the most generic form, a database table can be seen as a single spreadsheet with unlimited numbers of columns and rows. The columns are not defined until the user names them and gives them a datatype. Oracle extends the concept of spreadsheets by defining relationships between multiple spreadsheets, constraints on columns, and providing mechanisms for multiple users to access the same database table s at the same time.
The data access path is implemented in Oracle using indexes. Indexing allows us to predefine to the relational database system the most common access paths that will be used. These indexes decrease the time required to search for data in a table using a number of algorithms such as B-tree, bitmap, etc.
It lets you create user-defined object types in the relational database system. Object types are structures that consist of built-in or user-defined data types. For example, Address can be defined as an object type and can be referenced in tables. This is a small example to show you how objects can be reused and how the functionality of the RDBMS can be extended to include built-in complex business rules. In this section, we will discuss the capabilities and features of Oracle Database 12c.
Detailed architecture and components are discussed in various chapters in Part II of this book. The physical structure of an Oracle Database 12c server consists of two major compo- nents: The database is a set of physical files saved on the disk that store information. The instance is a set of memory structures and processes that uses the physical components to manipulate and retrieve data. The host machine is where the Oracle instance is running. It has the memory structures and processes.
The storage array, or disk, is where the database resides. The host machine is where users and applications connect and interact.
If the machine goes down for some reason, the database will be unavailable. In this architecture, more than one instance com- municates to a single database. Oracle RAC takes reliability a step further by removing the database server as a single point of failure. If an instance fails, the remaining instances in the RAC pool remain open and active; and connections from failed instances can be failed-over to active instances.
The RAC load balancer directs the user connection request to the appro- priate instance. Oracle manages the connection load balancing and failover automatically. Many organizations have several hundreds or thousands of Oracle databases. Imagine if the policy were to have one instance per server, then you would have as many servers as the number of instances to manage. If you have a high-capacity server or if the database resource requirements are minimal, you can have more than one instance on the same host machine.
You need instance memory structures, processes, and management activities such as backup for each instance or database. With Oracle 12c, a new architecture feature is introduced known as the multitenant archi- tecture. The multitenant architecture enables an Oracle database to function as a multitenant container database CDB that includes zero, one, or many pluggable databases PDBs. All databases created prior to Oracle Database 12c are non-CDB; a pluggable database appears as a non-CDB to the application, so existing code and application need not be changed when you move to Oracle Database 12c.
Oracle RDBMS is responsible for keeping the pluggable databases separate, private for the application, and secure. The instance and SGA are assigned to a container database. The databases that are part of the CDB are known as pluggable databases. With the pluggable databases and multitenant architecture, Oracle Database 12c offers the following benefits: Because the overhead associated with each database is now shared among all databases, you can consolidate more databases with the same resources.
By consolidating hardware and sharing database memory and files, the cost of hardware is less. Although the architecture changed, each PDB acts and works as a traditional prec Oracle database. There is no need to change application code or architecture to start using Oracle Database 12c. Administrative activities such as patching and upgrade are performed on the container database so they do not need to be repeated for each database in the CDB.
This drastically reduces the administrative time required. With multiple databases consolidated into one server, you still have to back up each database separately. With container and pluggable databases, you only need to back up one multitenant container database. In the container database architecture, it is very easy to clone and provision pluggable databases. When you upgrade the container database, all the pluggable databases are automatically upgraded.
It is also possible to move a pluggable database from one container database to another. This is especially useful if you plan to upgrade all but a few data- bases to the next release. Before upgrading the container database, you may move a few pluggable databases to another container database, or move pluggable databases to another CDB of higher release.
In the next section, you will learn about users and schema in the database, which is the basis for connecting to the database. Connecting to Oracle Database Before you can connect to an Oracle database, you must create a user. When you create a new Oracle database, several default users are automatically created. Using this account for day-to-day operations is not recommended. You connect to SYS to start and stop database and other key administrative tasks.
Along with SYS and SYSTEM, several other database users are also created based on the options you choose during the installation and on the components installed in the database. In a container database, the users are either common or local.
Common users are visible on the container as well as in all pluggable databases; they have the same username and pass- word across all pluggable databases and in the container database.
The schema for common user is still local to each pluggable database and the container database. A schema is a collection of database objects owned by a user account in the database.
The objects in the schema may be related to support a business application. A schema and user have a one-to-one relationship in a database. A schema is created as a user in the data- base, but when the user owns database objects, it is called a schema. This is known as object-level privilege.
For certain users, you may want to grant privileges on all the objects in the database; this is accomplished by using the system privileges. Database Management Tools Oracle Database 12c comes with multiple feature-rich tools to help administrators manage and monitor the database and all of its components. In this section, you will review the tools that are used for everyday administration of Oracle database. It has several predefined menu functions; therefore, there is no need to remember the syntax or SQL command to perform basic functions.
For Linux, you must download and install it outside of an Oracle Database 12c installation. The distribution usually included in the database software distribution might not be the current version.
It is better to always download the latest version and install SQL Developer from http: To get started and learn more about SQL Developer, click the choices available in the screen. The section marked 1 shows various database connections and the objects in those data- bases. Section 2 provides you with a set of predefined reports. If you know how to write SQL, you can define your own reports as well. Section 4 is the SQL worksheet.
You use this section to interact directly with the data- base using SQL language. Output from the SQL commands is listed in section 5; both query output and script output are visible. Section 6 is the logging pane. This is useful when you are debugging code. You run SQL commands to query the database or to manage the database. This tool is automatically installed when you install the Oracle Database 12c server software.
The connect string following is the database alias name known as the net service name. If you omit the password, you will be prompted to enter it. Type the command you want to execute at this prompt. You can also format query results and perform calculations. On platforms where a return code is used, you can provide a return code while exiting.
You can also use the QUIT command to complete the session. They are discussed in this book in various chapters. OEM Database Express is designed to manage only one database, and is intended for database administrators.
When you invoke Database Express, you will be prompted for a username and password to connect to the database. You should provide a user account that has administrative privileges.
For the SQL section of this book, you will not be using this tool, so we will not discuss it in more detail here. With OEM 12c, you can manage multiple databases and all products under the Oracle stack.
It is a complete cloud lifecycle management answer to quickly set up, administer, and support enterprise clouds and Oracle environments from applications to storage. OEM 12c is not part of the Oracle Database 12c software install; it must be downloaded and installed separately. Cloud resources are shared not only by multiple users, but are also capable of reallocation based on demand.
Cloud computing allows organizations to provision resources and applications rapidly, with improved manageability and less administrative overhead. By enabling customers to efficiently use their information technology infrastruc- ture, Oracle Database 12c was designed for the cloud. The following are the benefits of having Oracle Database 12c in the cloud architecture: DBAs need to perform fewer patches and upgrades and will not need to configure many backups.
The heat map fea- ture tracks data usage information; administrators can create appropriate policies to automatically move and compress data based on age and activity of data. Oracle Database 12c helps customers reduce IT complexity and cost through private data- base cloud deployments by consolidation. Cloud computing offers an opportunity for IT orga- nizations to be more responsive to changes in application workloads and business demands.
You can terminate a SQL statement in any of the following ways: The statement is completed and executed. The statement in the buffer is executed. The statement is saved in the buffer. You can use the RUN command instead of a slash to execute a statement in the buffer. The SQL prompt returns when the statement has completed execution. You can enter your next command at the prompt. When you continue a SQL command to the next line, a line number appears at the beginning of the line.
This is in contrast to SQL statements, which can be continued to the next line without a continuation operator. Invisible columns are newly introduced in Oracle Database 12c, where a column in the table can be hidden from the application.
Invisible columns help to remove a column from the table quickly without actually dropping the column. Invisible columns are discussed in Chapter 7. You can run the command in this buffer again by simply typing a slash or using the RUN command.
You do not need to type the entire SQL statement again. Instead, just edit the existing statement in the buffer. You can make changes, delete lines, add text, and list the buffer contents using the commands described in the following sections.
Most editing commands operate on the current line. All commands can be abbreviated, except DEL which is already abbreviated. The asterisk indicates the current line. The command LIST m n displays lines from m through n. The abbreviated command is A. The abbreviated command is C. If you omit new, old will be deleted. Its abbreviation is I. If text is omitted, you can add as many lines as you want.
The DEL m n command deletes lines from m through n. This deletes all lines from the buffer. SQL statements saved in a file are called a script file. You can work with script files as follows: If you do not provide an extension, the saved file will have the extension.
You can also run a script file using filename. Exercise 1. List the SQL buffer: Save the buffer to a file named myfile; the default extension will be. Choose to edit the file: List the buffer: Bring the file contents to the buffer: List the buffer to verify its contents: Change the employee number from to Save the buffer again to the same file: Use "SAVE filename[. Execute the file: Change the employee number from to , and append this SQL code to the file; then execute it using: SPOOL overwrites an existing file by default.
A new file will be created if the file does not exist already. SPOOL with no clauses lists the current spooling status. Adding Comments to a Script File Comments in the script file can improve readability and make the code more understandable.
Lines in the script file beginning with the keyword REM are comments and are not executed. Comments can also be entered following -- double hyphen ; all characters following -- in the line are treated as comments by Oracle.
You may perform a quick default install of the database after downloading the software from OTN www. If you do not have such a database, you can follow these instructions to install software and create databases on a Windows machine.
After downloading the soft- ware, you can invoke the setup. For detailed instructions on down- loading and installing Oracle software, refer to www. You can also refer to Chapter 9 to install database software. For detailed instructions on creating a database, refer to www. You can also refer to Chapter 9 to create a database. If you did not install the sample schema during database creation, you can do so using the following procedure. When you install Oracle software, you can choose the Create Database With Default Configuration option, but this will not include the sample schemas.
Initially, the sample schema user accounts are locked. Now you can log in to the database using the hr user with the password hrpassword. Remember, the password is case sensitive by default. Chapter 2 of this document provides instruc- tions on how to install the sample schemas using Database Configuration Assistant DBCA as well as on running scripts. The same chapter also gives you steps to reinitialize the sample schema data.
The entity-relationship diagram is a modeling tool used in the beginning stages or application development. You also learned about the high-level architecture and various implementations of Oracle, such as single database, RAC database, and container database. Oracle Database 12c is cloud enabled. The multitenant architecture of the database helps to consolidate multiple Oracle databases pluggable databases into a single container database.
Various tools are available for the DBA to connect to the Oracle database and administer it. SQL Developer is a graphical tool, with ease of navigation and predefined tasks. Using this tool, you can produce interactive SQL statements and formatted reports. Such files are called script files. Understand entities and relationships. Learn how Oracle implements the object relational database management system. Know the tools. Have an understanding of what tools are available for database manage- ment in Oracle and their purposes.
Learn the various architectures Oracle Database 12c can implement. Identify Oracle Database 12c cloud features. Know the features of Oracle Database 12c that make cloud implementation easier. Look at the diagram. Each movie may have one or more characters. Each movie must have one or more characters. Many movies may have many characters. One movie can have only one character. When the physical model is being designed from the logical model, which element may be attributed as a table from the ER diagram?
Relationship B. Attribute C. Unique identifier D. Entity 3. Which statement about the object type is true? They are structures that consist of built-in or user-defined data types.
They are structures that consist of only built-in data types. They are structures that consist of only user-defined data types. Only one column in a table can be object type. Which of the following is not a benefit of Oracle Database 12c? Manage multiple databases as one B.
Fast provisioning of cloned databases C. Plug and unplug databases D. Which database tools are parts of Oracle Database 12c? SQL Developer D. In the physical implementation of RDBMS, which database object is used to represent unique identifiers?
Any constraint B.
Index C. Primary key D. Foreign key 8. SQL Developer is a tool primarily for whom? Database administrators B. End users C. Application developers D. All of the above 9. Which architecture in the Oracle Database 12c implementation guards against unplanned machine downtime? Multitenancy Container Database B.
Real Application Clusters C. Consolidate multiple databases and instances to one server D. Which connection method to the Oracle database is known as the easy connect? Both A and B D. SQL is the basic language used to manipulate and retrieve data from Oracle Database 12c.
SQL is a nonprocedural language, meaning it does not have programmatic constructs such as loop structures. You will learn how to write basic SQL statements to retrieve data from tables. You will also learn how to limit the information retrieved and to display the results in a specific order. SQL is the common language used by programmers, database administrators, and users to access and manipulate data as well as to administer databases.
SQL statements are like plain English but with specific syntax. SQL is a simple, yet pow- erful language used to create, access, and manipulate data and structures in the database. Session Control Used to control the properties of a user session. A session is the point from which you are connected to the database until you disconnect. System Control Used to manage the properties of the database.
Do not worry if you do not understand certain terms, such as role, session, privilege, and so on. We will cover all the statements in the coming chapters and include many examples.
Oracle Datatypes The basic structure of data storage in Oracle Database 12c is a table. A table can be con- sidered as a spreadsheet with columns and rows. Data is stored in the table as rows. Each column in the table has storage characteristics such as the type of data contained in the column. Oracle has several built-in datatypes to store different kinds of data.
In this sec- tion, we will go over the built-in datatypes available in Oracle Database 12c. When you create a table to store data in the database, you need to specify a datatype for all the columns you define in that table.
Oracle has many datatypes to suit application requirements. We discuss all the datatypes and their usage in detail in Chapter 7. Data stored in CHAR columns is space-padded to fill the maxi- mum length.
Its size can range from a minimum of 1 byte to a maximum of 2, bytes. The default size is 1. When you create a column using the CHAR datatype, the database will ensure that all data placed in this column has the defined length.
If the data is shorter than the defined length, it is space-padded on the right to the specified length. If the data inserted is longer than the column length, an error is raised. The default size of a CHAR datatype is 1.
With the CHAR datatype, trailing spaces are ignored. CHAR datatype: The precision and scale values are optional. Numeric datatypes are used to store negative and positive integers, fixed-point numbers, and floating-point numbers. The precision can be between 1 and 38, and the scale has a range between —84 and If the precision and scale are omitted, Oracle assumes the maximum of the range for both values. You can have precision and scale digits in the integer part.
Even if you do not include the decimal part for the value inserted, the maximum number you can store in a NUMBER 5,2 definition is If the value exceeds the precision, however, an Oracle error is returned. You cannot insert Specifying the scale and precision does not force all inserted values to be a fixed length. If the scale is negative, the number is rounded to the left of the decimal. If you specify a scale that is greater than the precision value, the precision defines the maximum number of digits to the right of the decimal point after the zeros.
This datatype can be con- verted to other forms for viewing, but it has a number of special functions and properties that make date manipulation and calculations simple. The time component of the DATE datatype has a resolution of one second—no less.
The DATE datatype occupies a storage space of 7 bytes. The following information is contained within each DATE datatype: This format shows that the default date must begin with a two-digit day, followed by a three-character abbreviation for the month, followed by a two-digit year. The default precision is 6 and can range from 0 to 9. Operators and Literals An operator is a manipulator that is applied to a data item in order to return a result.
Operators are commonly used in all programming environments, and you should already be familiar with the following operators, which may be classified into two types: You can insert spaces between the operand and operator to improve readability.
Arithmetic Operators Arithmetic operators operate on numeric values. Used to represent positive or negative data Used to add two data items or expressions.
Used to find the difference between two data Used to multiply two data items or expressions. Used to divide a data item or expression with another. Two hyphens represent the begin- ning of a comment in SQL. Concatenation Operator The concatenation operator is used to concatenate or join two character text strings. The result of concatenation is another character string. Two vertical bars are used as the concatenation operator.
Here are two examples: Operator Precedence If multiple operators are used in the same expression, Oracle evaluates them in the order of precedence set in the database engine. Operators with higher precedence are evaluated before operators with lower precedence.
Operators with the same precedence are evaluated from left to right. The innermost parenthesis is evaluated first. Literals A literal is a value that represents a fixed value constant. There are four types of literals: Text Literals A text literal must be enclosed in single quotation marks. Any character between the quotation marks is considered part of the text value.
Oracle treats all text literals as though they were CHAR datatypes for comparison blank padded. Single quotation marks can be included in the literal text value by preceding it with another single quotation mark.
Here are some examples of text literals: The quote delimiter can be a single quotation mark, but make sure inside the text literal a single quo- tation mark is not immediately followed by another single quotation mark. For all other quote delimiters, the opening quote delimiter must be the same as the closing quote delimiter.
Here are some examples of text literals using the alternative quoting mechanism: E or e represents a number in scientific notation; the exponent can be in the range of — to Here are some examples: To complete this discussion of literals, we will discuss the datetime literals briefly.
The time component will be defaulted to midnight The following are examples of the DATE literal: The time zone information can be specified using the UTC offset or using the time-zone region name.
SS TZ. Queries do not modify data; they read data from database tables and views. Simple queries are those that retrieve data from a single table or view. A table is used to store data and is stored in rows and columns.
Queries using multiple tables are discussed in later chapters. It allows you to retrieve information already stored in the database. The FROM clause provides the name of the table, view, or materialized view to use in the query.
These objects are discussed in detail in later chapters. For simplicity, we will use tables for the rest of this chapter.
The FROM clause identifies the table name. We will discuss all of these clauses in detail in the coming sections of this chapter. The keywords, column names, and table names are not case sensitive. Only literals enclosed in single quotation marks are case sensitive in Oracle. How do you list only the job title and minimum salary from this table?
If you know the column names and the table name, writing the query is simple. Execute the query by ending the query with a semicolon. Column Alias Names The column alias name is defined next to the column name with a space or by using the key- word AS.
If you want a space in the column alias name, you must enclose it in double quota- tion marks. The case is preserved only when the alias name is enclosed in double quotation marks; otherwise, the display will be uppercase. The following example demonstrates using an alias name for the column heading in the previous query: In this listing, the column alias name Title appears in all capital letters because it was not enclosed in double quotation marks.
This is useful when you do not know the column names or when you are too lazy to type all the column names. Uniqueness is verified against the complete row, not the first column. These are tables that belong to the Recycle Bin or dropped tables. The tasks of creating tables and managing tables are discussed in Chapter 7. It has one column and one row. The DUAL table is mostly used to select system variables or to evaluate an expression.
Here are a few examples. The first query is to show the contents of the DUAL table. Rows are returned or operated upon where the data satisfies the logical condition s of the WHERE clause.
Describes Oracle globalization support for the database. Explains how to set up a globalization support environment, choose and migrate a character set, customize locale data, do linguistic sorting, program in a global environment, and program with Unicode. Database In-Memory Guide. Describes the architecture, configuration, and administration of the In-Memory Column Store.
Provides configuration information for network and system administrators, and database installation information for database administrators DBAs who install and configure Oracle Database, and Oracle Grid Infrastructure for a standalone server on HP-UX systems. Database Installation Guide for Linux. Provides configuration information for network and system administrators, and database installation information for database administrators DBAs who install and configure Oracle Database and Oracle Grid Infrastructure for a standalone server on Linux.
Database Installation Guide for Microsoft Windows. Provides configuration information for network and system administrators, and database installation information for database administrators DBAs who install and configure Oracle Database and Oracle Grid Infrastructure for a standalone server on Windows. Database Installation Guide for Oracle Solaris.
Provides configuration information for network and system administrators, and database installation information for database administrators DBAs who install and configure Oracle Database, and Oracle Grid Infrastructure for a standalone server on Oracle Solaris.
Database Licensing Information User Manual. Describes Oracle Database licensing. If you have a question about your licensing needs, contact your Oracle sales representative. Database Performance Tuning Guide. Provides information about how to tune the performance of Oracle Database using Oracle performance tools.
Database Reference. Provides reference information about database initialization parameters, static data dictionary views, and dynamic performance views that are part of Oracle Database. Database Security Guide. Explains how to configure an Oracle database to use the default security features.
Database Upgrade Guide. Guides you through the process of planning and performing upgrades for Oracle Database. This book also provides information about compatibility, upgrading applications, and changes in the new release that affect upgrading Oracle Database.
Database Utilities. Describes how to use Oracle Database utilities to load data into a database, transfer data between databases, and maintain data. Database Vault Administrator's Guide.
Describes how to register and administer Oracle Database Vault. Provides deployment scenarios for using Rapid Home Provisioning for installation, upgrades, and patching. Enterprise User Security Administrator's Guide. Explains how to configure and use enterprise users, which are users defined in a directory. The guide also covers administrative tasks related to enterprise user security.
Error Messages. Describes error messages that may appear while using products that are part of Oracle Database. Provides dynamic load balancing, failover, and centralized service management for a set of replicated databases that offer common services.
Heterogeneous Connectivity User's Guide. Describes Oracle's approach to information integration in a heterogeneous environment. Describes Oracle Database Gateways and is a user's guide for these Oracle products.
High Availability Overview. Introduces Oracle best practices for deploying a highly available environment, helps you determine your availability requirements, and describes the database architectures that can help your business achieve high availability.
Java Developer's Guide. Describes how to develop, load, and run Java applications in Oracle Database. It covers how to store, generate, view, manipulate, manage, search, and index it. Label Security Administrator's Guide. Describes how to register and administer Oracle Label Security. Presents reference and other information about using Oracle Database to store, manage, and retrieve DICOM content such as single-frame and multiframe images, waveforms, slices of 3-D volumes, video segments, and structured reports in an integrated fashion with other enterprise information.
Multimedia Reference. Presents reference information about using Oracle Database to store, manage, and retrieve images, audio, video, DICOM format medical images and other objects, or other heterogeneous media data in an integrated fashion with other enterprise information. Oracle Multimedia extends Oracle Database reliability, availability, and data management to multimedia content in Internet, electronic commerce, medical, financial, and other media-rich applications. Multimedia User's Guide.
Presents information about using Oracle Database to store, manage, and retrieve images, audio, video, DICOM format medical images and other objects, or other heterogeneous media data in an integrated fashion with other enterprise information.
Oracle Multimedia extends Oracle Database reliability, availability, and data management to multimedia content in traditional, Internet, electronic commerce, medical, financial, and other media-rich applications. Net Services Administrator's Guide. Explains how to plan, configure, and manage enterprise-wide connectivity with Oracle Net Services.
Net Services Reference. Contains complete listing with descriptions of the control utility commands and configuration file parameters available for managing components of Oracle Net Services.
Object-Relational Developer's Guide. Explains how to use the object-relational features of Oracle Database. Describes Oracle Database ODBC driver new features, functionality, platforms supported, software required, server requirements, hardware required, testing matrix, UNIX platform certification matrix, post-installation, known issues, and software problems fixed.
Describes the Oracle OLAP expression syntax used to generate information-rich content from the data stored in dimensional database objects such as cubes and cube dimensions. To extend the functionality of code generated by the Object Type Translator, programmers may want to add code in the OTT-generated file. The OTT can distinguish between OTT-generated code and user-generated code by looking for some predefined markers tags. Oracle Call Interface Programmer's Guide.
Introduces new users to the default Oracle Database security features. Oracle Database New Features Guide. Oracle Database New Features Guide is addressed to those of you who would like to become familiar with features, options, and enhancements that are new in this release of the database.