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 4742

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

2 5444

how to genarate random numbers in oracle for particular row?

3 7567

What is use of oracle?

Satyam,

2 5383

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 10141

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

1947

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 4345

interview questions with answer for cts

Cognizant,

2543

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

1 26738

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

TCS,

2111

what is normalisation?what are its uses?

2221

How many memory layers are in the shared pool?

1 4958

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

2062

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?

2781

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

2229

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is sharded cluster?

946

What is Segment Advisor in Oracle?

1062

What is snapshot is too old? Give and example for better understand.

1553

Why does for update in oracle 8 cause an ora-01002 error?

947

How to create id with auto_increment on oracle?

950

Explain joins in oracle?

989

What are the ways tablespaces can be managed and how do they differ?

2287

What is primefaces used for?

1017

How to bring a tablespace offline?

1009

can u plz provide me oca sql dumps please i need them

1910

Explain the use of compress option in exp command.

978

How do you find current date and time in oracle?

997

What is a data lock in oracle?

1044

What is a database table in oracle?

976

What is an Oracle Instance?

1083

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