Searching for "ORACLE"

Q:

Oracle SQL developer is an

Answer

Oracle SQL developer is an Oracle Database IDE.

Report Error

View answer Workspace Report Error Discuss

Q:

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables ?

A) Data Manipulation Language(DML) B) Data Definition Language(DDL)
C) Both A & B D) None
 
Answer & Explanation Answer: B) Data Definition Language(DDL)

Explanation:

The Data Definition Language (DDL) is used to manage table and index structure.

CREATE,

ALTER,

RENAME,

DROP and

TRUNCATE

statements are the names of few data definition elements.

Report Error

View Answer Report Error Discuss

Filed Under: SQL
Job Role: IT Trainer , Database Administration , Analyst

Q:

What is user Account in Oracle database?

Answer

An user account is not a physical structure in Database but it is having important relationship to the objects in the database and will be having certain privileges. 95. When will the data in the snapshot log be used? - We must be able to create a after row trigger on table (i.e., it should be not be already available) After giving table privileges. We cannot specify snapshot log name because oracle uses the name of the master table in the name of the database objects that support its snapshot log. The master table name should be less than or equal to 23 characters. (The table name created will be MLOGS_tablename, and trigger name will be TLOGS name).

Report Error

View answer Workspace Report Error Discuss

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

Q:

What is WATER MARK in oracle? Explain the significance of High water mark.

Answer

WATER MARK is a divided segment of used and free blocks. Blocks which are below high WATER MARK i.e. used blocks, have at least once contained some data. This data might have been deleted later. Oracle knows that blocks beyond high WATER MARK don’t have data; it only reads blocks up to the high WATER MARK during a full table scan. 

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

Q:

What are transaction isolation levels supported by Oracle?

Answer

Oracle supports 3 transaction isolation levels: 


- Read committed (default)


- Serializable transactions


- Read only

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

Q:

Explain how to lock and unlock a user account in Oracle.

Answer

SQL> ALTER USER user_name ACCOUNT LOCK;


SQL> ALTER USER user_name ACCOUNT UNLOCK;

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

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