1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category
Oracle General Interview Questions
Questions Answers Views Company eMail

After using set unused can we enable the column again to use? Please give me some answers....

Maveric,

1 4030

what is the difference between no rows returned and null returned?

 2 4485

how to genarate random numbers in oracle for particular row?

 3 6445

What is use of oracle?

Satyam,

2 4481

i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash

 2 9136

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

 1567

SQL> CREATE TABLE to_table 2 (col1 NUMBER); Table created. SQL> CREATE OR REPLACE TRIGGER statement_trigger 2 AFTER INSERT ON to_table 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('After Insert Statement Level'); 5 END; 6 / Trigger created. SQL> CREATE OR REPLACE TRIGGER row_trigger 2 AFTER INSERT ON to_table 3 FOR EACH ROW 4 BEGIN 5 DBMS_OUTPUT.PUT_LINE('After Insert Row Level'); 6 END; 7 / Trigger created. SQL> INSERT INTO TO_TABLE VALUES(1); After Insert Row Level After Insert Statement Level 1 row created. SQL> BEGIN 2 INSERT INTO TO_TABLE VALUES(2); 3 INSERT INTO TO_TABLE VALUES(3); 4 INSERT INTO TO_TABLE VALUES(4); 5 INSERT INTO TO_TABLE VALUES(5); 6 INSERT INTO TO_TABLE VALUES(6); 7 INSERT INTO TO_TABLE VALUES(7); 8 INSERT INTO TO_TABLE VALUES(8); 9 INSERT INTO TO_TABLE VALUES(9); 10 INSERT INTO TO_TABLE VALUES(0); 11 END; 12 / WAT LL BE THE O/P??? XPLAIN IT>>>>

Infosys,

1 3465

interview questions with answer for cts

Cognizant,

2090

What is the difference between alert log file and trace file ?

 1 25865

What is the difference between alert log file and tarce file ?

TCS,

1634

what is normalisation?what are its uses?

1763

How many memory layers are in the shared pool?

 1 4237

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

 1659

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

 2395

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

 1858

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What are the various oracle database objects?

681

What is a Garbage Collection? and what is full recursive Garbage collection?

2389

How do you tell what your machine name is and what is its IP address?

1516

What is an Oracle Instance?

687

What is an Oracle index?

1177




How to create an initialization parameter file?

539

What is program global area (pga) in oracle?

607

What is oracle analytical function?

526

How to write date and time interval literals in oracle?

573

What is oracle used for?

534

What are set operators?

646

What is oracle database 10g express edition?

596

What is a subquery?

614

Does oracle charge for java?

590

What is a connect identifier?

543

For More Un-Answered { Oracle General } Questions Click Here