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 4717

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

2 5409

how to genarate random numbers in oracle for particular row?

3 7529

What is use of oracle?

Satyam,

2 5347

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 10105

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

1943

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 4313

interview questions with answer for cts

Cognizant,

2532

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

1 26714

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

TCS,

2096

what is normalisation?what are its uses?

2207

How many memory layers are in the shared pool?

1 4937

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

2052

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?

2772

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

2216

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How do you tell what your machine name is and what is its IP address?

2005

How do we get field detail of a table?

1020

Explain what does a control file contain?

1032

What is columnar storage what is the advantage?

985

What is hash cluster in oracle?

1087

How to get last row id?

938

What are the parameters that we can pass through a stored procedure?

997

How to see the table columns used in an index?

958

Is oracle a relational database?

870

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

1943

Differentiate between function and procedure in oracle.

1018

Explain implicit cursor.

960

What is the usage of control file in oracle?

1025

State and explain the different types of data models?

894

How to create a temporary table in oracle?

1191

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