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 4885

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

2 5677

how to genarate random numbers in oracle for particular row?

3 7844

What is use of oracle?

Satyam,

2 5581

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 10345

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

2040

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 4508

interview questions with answer for cts

Cognizant,

2635

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

1 26932

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

TCS,

2223

what is normalisation?what are its uses?

2326

How many memory layers are in the shared pool?

1 5087

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

2171

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?

2870

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

2309

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is merge in oracle?

1095

Briefly explain what is literal? Give an example where it can be used?

1087

How to export your own schema?

1048

How to use in conditions in oracle?

1104

How to use subqueries in the from clause in oracle?

1165

What is the sid in oracle?

1032

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2341

How to get a list of all background sessions in the database?

1036

How to initialize variables with default values?

1305

Explain the use of control file?

1169

What is a parameter file in oracle?

1186

What is meant by joins?

1106

Explain the use of tables option in exp command.

1166

Difference between hot backup vs. Cold backup?

1036

What is the use of aggregate functions in oracle?

1071

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