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 4813

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

2 5566

how to genarate random numbers in oracle for particular row?

3 7718

What is use of oracle?

Satyam,

2 5485

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 10272

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

1994

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 4451

interview questions with answer for cts

Cognizant,

2589

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

1 26839

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

TCS,

2173

what is normalisation?what are its uses?

2278

How many memory layers are in the shared pool?

1 5025

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?

2829

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 }

Point the difference between translate and replace?

1096

How to sort output in descending order in oracle?

1047

What are the limitations of check constraint?

1033

What is a nvl function? How can it be used?

1037

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1384

What is index in Oracle?

1077

how to make an oracle object

2363

What are the different windows events activated at runtime ?

2902

List out the components of logical database structure of oracle database.

1039

What are the original export and import utilities?

1177

How to drop an existing table in oracle?

1058

What is the difference between pre-select and pre-query?

1226

How data locks are respected in oracle?

1073

What is clustered table in Oracle?

1200

What happens if variable names collide with table/column names?

1196

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