- /*…*/ and — are used to put comments in an Oracle program.
- The CREATE TABLE does not end immediately with a semicolon, and a column name cannot start with a numeric value. However, a numeric value can be used in between a column name.
Archive for the ‘OCA DBA 11g’ category
OCP 1z0-047 Short Notes: Exam passing tips
October 3rd, 2009
What is the REMOTE_OS_AUTHENT parameter?
September 30th, 2009The REMOTE_OS_AUTHENT parameter in the parameter file of the database specifies whether remote clients will be authenticated with the value of the OS_AUTHENT_PREFIX parameter or not. The type of the REMOTE_OS_AUTHENT parameter is Boolean, the default value is false, and the parameter class is static. The REMOTE_OS_AUTHENT parameter is case sensitive on some operating systems. The flow diagram below may help a user understand the role of the REMOTE_OS_AUTHENT parameter for a remote database:
What is DBMS_SESSION PL/SQL package?
September 8th, 2009The DBMS_SESSION PL/SQL package is used to provide access to the ALTER SESSION and ALTER SYSTEM statements. This package is also used for gathering session related information. The DBMS_SESSION PL/SQL package uses the privileges of the user executing this package, instead of using privileges of the user SYS.
- Get certified in first attempt download oca-dba10g - OCA DBA 10g simulation.
- Pass OCA DBA 11g in first attampt.
- Get certified in first attempt download oca-dba9i - OCA DBA 9i simulation.
- Download free practice test for oca-pl-sql OCA PL/SQL Developer exam.
- Download free practice test for Oracle OCP DBA 10g exam.
- Click here to get free ocp-dba-11g OCP DBA 11g exam practice questions.
- Download practice question and study guide for ocp-dba9i for exam.
- Download free practice test for ocp-pl-sql OCP PL/SQL Developer exam.
- Become Oracle Oracle Certified Master 10g certified.
- Become Oracle Oracle PL/SQL Developer certified.
- Click here to get free performance-tuning-certified-expert-11g Performance Tuning Expert 11g exam practice questions.
- Get certified in first attempt download rac-administrator-certified-experts-10g - RAC Certified Expert 10g simulation.
- Become Oracle SQL Certified Expert 10g certified.
- Click here to download sql-certified-expert-11g test study guide and practice question.
- Pass Oracle 1Z0-033 - Oracle9i DB: Performance Tuning
- Download practice question and study guide for 1Z0-042 for exam.
- Click here to get free 1Z0-047 Oracle Database SQL Expert exam practice questions.
- Click here to get free 1Z0-051 OCA: Oracle Database 11g-SQL Fundamentals-I exam practice questions.
What is DECODE function?
September 1st, 2009The DECODE function decodes a column value or an expression and compares it with each specified search value, one by one. If the expression matches a search value, a result value corresponding to the matching search value is returned. If no match is found, a default result value, if included, is returned. However, if no default value is included, a NULL value is returned. The DECODE function is one of the few single-row functions that directly deal with NULL values. It can compare two NULL values and can return a NULL value.
What is TO_CHAR (datetime) function?
September 1st, 2009TO_CHAR (datetime) is a single-row function that is used to convert a value of DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, or TIMESTAMP WITH LOCAL TIME ZONE datatype to a value of VARCHAR2 datatype in the specified date format.
Joins: Its Types and Uses
August 21st, 2009The JOIN clause is used with the SELECT statement to retrieve data from more than one table. This clause matches data from multiple tables. This results in the creation of a table, which is a combination of columns from multiple tables.
Relational Algebra
August 15th, 2009Algebra is a formal structure, which consists of sets, and operations performed on these sets. Relational algebra is a formal structure for manipulating relations. There are various relational operators for manipulating relations. These operators take two tables, perform the operation, and return back the desired output.
OCP 1z0-047 Short Notes: Exam passing tips
August 7th, 2009- /*…*/ and — are used to put comments in an Oracle program.
- The CREATE TABLE does not end immediately with a semicolon, and a column name cannot start with a numeric value. However, a numeric value can be used in between a column name.
What is the REMOTE_OS_AUTHENT parameter?
August 4th, 2009The REMOTE_OS_AUTHENT parameter in the parameter file of the database specifies whether remote clients will be authenticated with the value of the OS_AUTHENT_PREFIX parameter or not. The type of the REMOTE_OS_AUTHENT parameter is Boolean, the default value is false, and the parameter class is static. The REMOTE_OS_AUTHENT parameter is case sensitive on some operating systems. The flow diagram below may help a user understand the role of the REMOTE_OS_AUTHENT parameter for a remote database:
What are conventional path loads?
July 27th, 2009A conventional path load is a method of loading data into tables. This method uses the SQL INSERT statement and a bind array buffer for loading the data. It is the default method employed by every Oracle tool and application. In conventional path loads, the SQL*Loader has to compete with all other Oracle processes for buffer resources. However, this significantly deteriorates the speed of the load process as compared to direct path loads. Conventional path loads search for partially filled data blocks to fill them at each insert operation. This process also deteriorates the speed of conventional path loads. Conventional path loads are generally employed for loading data into clustered tables or where a small number of rows are to be inserted into a large indexed table.
- Download free practice test for Oracle OCA DBA 11g exam.
- Download free practice test for ocp-dba-11g OCP DBA 11g exam.
- Download free practice test for Oracle OCP DBA 9i exam.
- Get certified in first attempt download performance-tuning-certified-expert-11g - Performance Tuning Expert 11g simulation.
- Click here to get free rac-administrator-certified-experts-10g RAC Certified Expert 10g exam practice questions.
- Download free practice test for 1Z0-033 Oracle9i DB: Performance Tuning exam.
- Become Oracle OCA: Oracle Database 11g: Administration I certified.