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 4817

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

2 5572

how to genarate random numbers in oracle for particular row?

3 7723

What is use of oracle?

Satyam,

2 5490

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 10274

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

1996

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 4455

interview questions with answer for cts

Cognizant,

2593

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

1 26846

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

TCS,

2178

what is normalisation?what are its uses?

2279

How many memory layers are in the shared pool?

1 5029

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

2126

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?

2834

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 }

What is the recommended interval at which to run statspack snapshots, and why?

2923

What is the relationship among database, tablespace and data file?

996

Explain what does a control file contain?

1107

What is a read write transaction in oracle?

1096

What do you mean by redo log file mirroring?

1041

How to recover a dropped table in oracle?

1051

How are extents allocated to a segment?

1136

What is a parameter file in oracle?

1140

How to create an oracle database manually?

1091

What happens if the update subquery returns multiple rows?

1124

Why is oracle database so popular?

1014

How to define an external table with a text file?

1078

What is a trigger and what are its types in oracle?

1083

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1935

What happens to the indexes if a table is recovered?

993

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