Oracle Questions

Q:

What are PL/SQL Subprograms? What are its Advantages ?

Answer

Named PL/SQL blocks of code which can be invoked using parameters are called PL/SQL sub programs.


 


Advantages of PL/SQL subprograms are


- The application makes a single call to the database to run a block of statements which improves performance against running SQL multiple times. This will reduce the number of calls between the database and the application.


- PL/SQL is secure since the code resides inside the database thus hiding internal database details from the application. The application will only make a call to the PL/SQL sub program


- PL/SQL and SQL go hand in hand so there would be no need of any translation required between PL/SQL and SQL.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle - Technology

1 4903
Q:

What is AFIEDT.BUF?

Answer

When any file is attempted to edit without any arguments (example ed or edit), the last SQL command is saved in AFIEDT.BUF, It acts like a default buffer file for edit commands.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle - Technology

0 4712
Q:

Whar are the Difference between online and offline backups?

Answer

- Online backup is one which is taken at the time the database is running in the ARCHIVELOG mode.


- Following files should be backed up during the Offline Backup: All data file, all control file and all online redo log file. But in the case of the online backup following files is backed up: All data files all archived redo log files and one control file via the alter database command.


- Offline database we cannot rely upon but in case of online database no issues.


- Offline backup no archived mode is required but in the online backup it is must.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle - Technology

1 4355
Q:

What is the Oracle HTTP Server? How does it work?

Answer

Oracle HTTP Server is the Web server component of Oracle Database. It is based on the Apache HTTP Server. It is robust and reliable server due to following features:


- Provide high availability infrastructure integration with Oracle Process Manager and Notification Server (OPMN), for process management, death detection and failover for Oracle HTTP Server processes.


- Provide Dynamic Monitoring Services (DMS) metrics that give runtime performance statistics for Oracle HTTP Server processes.


- Enable securing of transactions with Secure Sockets Layer (SSL) technology.


- Execute Perl scripts in the same process as the Oracle HTTP Server, or as CGI script.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle - Technology

0 4285
Q:

What are the advantages of LINQ ?

Answer

- Debugging is esy.
- Reduces Development Time.
- LINQ offers IntelliSense which means writing more accurate queries easily.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle - Technology
Job Role: Analyst , IT Trainer

2 4281
Q:

Can you explain how to insert an image in table in oracle?

Answer

Insert image into a table


Create the following table:


      create table pics_table (


      bfile_id number,


      bfile_desc varchar2(30),


      bfile_loc bfile,


      bfile_type varchar2(4))


      TABLESPACE appl_data


      storage (initial 1m next 1m pctincrease 0) 


Insert Query:


      INSERT INTO pics_table


      VALUES(4,'test image',bfilename('GIF_FILES','Test.JPG'),'JPEG'); 

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle - Technology

2 4226
Q:

What is ANALYZE command used for?

Answer

ANALYZE command is used to perform various functions on index, table, or cluster, as listed below:
- It helps in dentifying migrated and chained rows of the table or cluster.
- It helps in validating the structure of the object.
- It helps in collecting the statistics about object used by the optimizer. They are then stored in the data dictionary.
- It helps in deleting statistics used by object from the data dictionary.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle - Technology

1 4149
Q:

What is DocumentDB ?

Answer

DocumentDB is a NoSQL document-oriented database and records saves in key-value pairs. It's same as the other NoSQL document-oriented such as MongoDB.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle - Technology
Job Role: Analyst , IT Trainer

1 4029