Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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 4810

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

2 5555

how to genarate random numbers in oracle for particular row?

3 7708

What is use of oracle?

Satyam,

2 5478

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 10265

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

1988

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 4441

interview questions with answer for cts

Cognizant,

2583

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

1 26835

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

TCS,

2172

what is normalisation?what are its uses?

2273

How many memory layers are in the shared pool?

1 5018

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

2123

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?

2827

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

2270

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain the difference between a procedure and a function? What do you understand by those terms?

1082

What do you mean by group by clause?

1045

How to export several tables together?

1049

How to Truncate Table in Oracle

1155

Explain user account with reference to oracle.

990

How to resolve the ORA-39133 error in Oracle?

1118

How to convert character types to numeric types?

1132

Can sub procedure/function be called recursively?

1003

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2131

What are data pump export and import modes?

1068

What is connection pool in oracle?

988

What is a table in oracle?

981

what are the default admin accounts in Oracle 10g ?

968

How can you use check constraints for self referential integrity?

970

What is a tns file?

996

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