Oracle Questions

Q:

How does the PeopleSoft database interact with the Oracle?

Answer

A Peoplesoft database is expression which point out a database containing Peoplesoft objects. For Oracle and only for Oracle, Peoplesoft consists in 3 schemas namely:


- PS (PSDBOWNER table owner),


- PEOPLE (for connection checking) and


- SYSADM (by default), the last one contains all the objects/data.


One of the database objects is connected with single Oracle schema, and all processes that connect to the database use the standard PSFT login procedure. PSFT login is used because to refer to the collection of tables in the administrative schema within an Oracle database. Every process that makes a 2-tier connection to the database identifies itself with a PSFT user or operator ID. Hence the interaction goes.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle - Technology

0 2785
Q:

Explain Check constraint.

Answer

Oracle check constraint is used to ensure that before inserting the data in the database, it is validated and checked for the condition.
Example:
Below, the constraint is that the id has to be between 0 and 1000.
create table employee ( id number check (id between 0 and 1000), Name varchar(200) );

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle - Technology

0 2771
Q:

What strategies are available for backing-up an Oracle database?

Answer

The backup strategies that are provided by Oracle are as follows:


- Logical backup using Exports and import.


- Physical file system backup


- RMAN Recovery Manger which is also known as incremental files system backup.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle - Technology

0 2697
Q:

Define cursor attributes: %FOUND, %NOTFOUND, %ROWCOUNT, and %ISOPEN

Answer

- %FOUND


 This is a Boolean variable which evaluates to TRUE if the last row is successfully fetched.


 


- %NOTFOUND


 This is a Boolean variable which evaluates to TRUE if the last row is not successfully fetched. This means there are no more rows to fetch.


 


- %ROWCOUNT


 Returns the number of rows fetched by the cursor.


 


- %ISOPEN


If the cursor is open, it evaluates to TRUE else FALSE.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle - Technology

0 2677
Q:

What is RAC and how is it different from non RAC databases?

Answer

Oracle Real Application Clusters (RAC) is a software component we can add to a high-availability solution that enables users on multiple machines to access a single database with increased performance. RAC comprises two or more Oracle database instances running on two or more clustered machines and accessing a shared storage device via cluster technology. To support this architecture, the machines that host the database instances are linked by a high-speed interconnect to form the cluster. Oracle RAC offers features in the following areas:


- Scalability


- Availability


- Load balancing


- Failover

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle - Technology

0 2644
Q:

How can we call DDL statements like CREATE, DROP, TRUNCATE, etc. from PL/SQL?

Answer

EXECUTE IMMEDIATE command can be used to call DDL statements. 


Example:


BEGIN


EXECUTE IMMEDIATE  'TRUNCATE TABLE employee';


END;

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle - Technology

0 2597
Q:

Define PL/SQL sequences and write syntax for a sequence

Answer

A sequence is a database object that is used to generate sequential number.


CREATE SEQUENCE seqname [increment] [minimum value][maximum value][start][cache][cycle]               Nextval and currval lets us get the next value and current value from the sequence.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle - Technology

0 2526
Q:

Oracle Server supports two different forms of replication: Basic and Advanced replication. Explain difference between these.

Answer

Basic Replication : Basic replication is implemented using standard CREATE SNAPSHOT or CREATE MATERIALIZED VIEW statements. It can only replicate data and not procedures, indexes replication is always one-way, and snapshot copies are read only.


Advanced Replication : Advanced replication supports various configurations of updatable snapshot, multi-master and update anywhere replication. It is more difficult to configure but allows data and other database objects like indexes and procedures to be replicated.


 


Differences between Basic and Advanced replications:


- With basic replication, data replicas provide read-only access to the table data whereas advanced replication features extend the capabilities of basic read-only replication by allowing applications to update table replicas throughout a replicated database system.


- With Basic Replication applications can query data from local data replicas. On the other hand with advanced replication, data replicas anywhere in the system can provide both read and update access to a table's data.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle - Technology

0 2458