The 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.
Posts Tagged ‘1Z0-007’
What is DECODE function?
September 1st, 2009
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.
What is system privilege?
July 15th, 2009System privilege is a privilege or right that allows a user to perform system level activities, such as connecting to a database, creating, altering, dropping, and managing database objects or features. Oracle does not retain the grantor of the system privileges. Therefore, even if a grantee has obtained system privileges from more than one grantor, these can be revoked by anyone with the appropriate privileges.
What is the syntax for creating a view?
July 15th, 2009Following is the syntax for creating a view:
[ (alias [, alias]…) ]
AS subquery
[WITH { READ ONLY | CHECK OPTION [CONSTRAINT ConstraintName] }];
where,
When is top-n analysis performed?
July 15th, 2009Top-n analysis is performed when the n topmost or the n bottommost records from a table are to be displayed. For example, top-n analysis can be performed in the following conditions:
What is a Cartesian product?
July 15th, 2009A join, between two or more tables, with no join condition results in a Cartesian product. A Cartesian product is a set of all possible combinations of rows drawn from each table involved in the join. In other words, Oracle combines each row of one table with each row of the other table. For example, the Cartesian product of two tables with five rows each, has twenty-five rows.
- Pass Oracle oca-dba10g - OCA DBA 10g
- Download practice question and study guide for oca-dba-11g for exam.
- Pass OCA DBA 9i in first attampt.
- Pass OCA DBA 9i PL/SQL in first attampt.
- Download practice question and study guide for oca-pl-sql for exam.
- Become Oracle OCP DBA 10g certified.
- Best exam simulation Oracle ocp-dba-11g download free trial.
- Best exam simulation Oracle ocp-dba9i download free trial.
- Best exam simulation Oracle ocp-pl-sql download free trial.
- Get certified in first attempt download ocm-10g - Oracle Certified Master 10g simulation.
- Download free practice test for oracle-pl-sql Oracle PL/SQL Developer exam.
- Pass Performance Tuning Expert 11g in first attampt.
- Download free practice test for rac-administrator-certified-experts-10g RAC Certified Expert 10g exam.
- Download free practice test for sql-certified-expert-10g SQL Certified Expert 10g exam.
- Download practice question and study guide for sql-certified-expert-11g for exam.
- Download free practice test for 1Z0-007 Introduction to Oracle9i: SQL exam.
- Download free practice test for Oracle Oracle Database SQL Expert exam.
- Best exam simulation Oracle 1Z0-051 download free trial.
What is IS NOT NULL operator?
July 15th, 2009IS NOT NULL is a comparison operator that is used to compare a value with a NULL value. It evaluates to TRUE if the value is not NULL, otherwise it evaluates to FALSE.
- Pass OCA DBA 10g in first attampt.
- Click here to download oca-dba-11g test study guide and practice question.
- Become Oracle OCA DBA 9i certified.
- Download practice question and study guide for oca-dba9i-pl-sql for exam.
- Download practice question and study guide for oca-pl-sql for exam.
- Pass Oracle ocp-dba10g - OCP DBA 10g
- Best exam simulation Oracle ocp-dba-11g download free trial.
- Download free practice test for Oracle OCP DBA 9i exam.
- Download practice question and study guide for ocp-pl-sql for exam.
- Click here to get free ocm-10g Oracle Certified Master 10g exam practice questions.
- Pass Oracle PL/SQL Developer in first attampt.
- Pass Oracle performance-tuning-certified-expert-11g - Performance Tuning Expert 11g
- Click here to get free rac-administrator-certified-experts-10g RAC Certified Expert 10g exam practice questions.
- Become Oracle SQL Certified Expert 10g certified.
- Download practice question and study guide for sql-certified-expert-11g for exam.
- Get certified in first attempt download 1Z0-007 - Introduction to Oracle9i: SQL simulation.
- Pass Oracle 1Z0-047 - Oracle Database SQL Expert
- Best exam simulation Oracle 1Z0-051 download free trial.
What is DML?
July 12th, 2009Data Manipulation Language (DML) is a category of SQL statements that query and update data in a database. Statements such as SELECT, UPDATE, INSERT, DELETE etc., are included in this category. These statements can be grouped with Data Control Language (DCL) statements.
- Click here to get free oca-dba10g OCA DBA 10g exam practice questions.
- Best exam simulation Oracle oca-dba-11g download free trial.
- Download practice question and study guide for oca-dba9i for exam.
- Pass Oracle oca-dba9i-pl-sql - OCA DBA 9i PL/SQL
- Become Oracle OCA PL/SQL Developer certified.
- Download practice question and study guide for ocp-dba10g for exam.
- Become Oracle OCP DBA 11g certified.
- Become Oracle OCP DBA 9i certified.
- Download practice question and study guide for ocp-pl-sql for exam.
- Get certified in first attempt download ocm-10g - Oracle Certified Master 10g simulation.
- Pass Oracle PL/SQL Developer in first attampt.
- Click here to get free performance-tuning-certified-expert-11g Performance Tuning Expert 11g exam practice questions.
- Become Oracle RAC Certified Expert 10g certified.
- Click here to download 1Z0-001 test study guide and practice question.
- Become Oracle Introduction to Oracle9i: SQL certified.
- Download free practice test for Oracle Oracle9i DB: Performance Tuning exam.
- Become Oracle OCA, 10g New Feature for Administrator certified.
- Get certified in first attempt download 1Z0-045 - OCA, 10g New Feature for Oracle 8i Ocp simulation.
- Download free practice test for Microsoft MCTS: SQL Server 2008, Implementation exam.
What is a tablespace?
July 10th, 2009A tablespace is a logical database structure for storing database segments. By default, each Oracle database has a single tablespace, known as SYSTEM, which stores data dictionary tables and indexes. Other tablespaces may also be configured for a database for performing some specific tasks such as:
- Partial backup and recovery operation
- Allocation of quotas for users
Additional tablespaces can also be created as per the requirements of the applications installed on the system. Such tablespaces can be used for storing application specific segments.
- Click here to download oca-dba10g test study guide and practice question.
- Pass OCA DBA 11g in first attampt.
- Click here to download oca-dba9i test study guide and practice question.
- Download practice question and study guide for oca-dba9i-pl-sql for exam.
- Download free practice test for oca-pl-sql OCA PL/SQL Developer exam.
- Click here to download ocp-dba10g test study guide and practice question.
- Pass OCP DBA 11g in first attampt.
- Become Oracle OCP DBA 9i certified.
- Become Oracle OCP PL/SQL Developer certified.
- Download practice question and study guide for ocm-10g for exam.
- Become Oracle Oracle PL/SQL Developer certified.
- Click here to download performance-tuning-certified-expert-11g test study guide and practice question.
- Best exam simulation Oracle rac-administrator-certified-experts-10g download free trial.
- Click here to download 1Z0-007 test study guide and practice question.
- Become Oracle Oracle9i Database: Fundamentals I certified.
- Pass Oracle9i DB: Performance Tuning in first attampt.
- Pass Oracle Database 10g: Admin - II in first attampt.
- Get certified in first attempt download 1Z0-045 - OCA, 10g New Feature for Oracle 8i Ocp simulation.
- Download free practice test for 1Z0-053 OCP: Oracle Database 11g: Administration II exam.
What is DECODE function?
July 8th, 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.