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 5440

how to genarate random numbers in oracle for particular row?

3 7564

What is use of oracle?

Satyam,

2 5382

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 4339

interview questions with answer for cts

Cognizant,

2543

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

1 26733

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

TCS,

2109

what is normalisation?what are its uses?

2219

How many memory layers are in the shared pool?

1 4956

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

2061

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?

2779

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 }

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1948

What are the different types of modules in oracle forms?

963

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

1990

What are the common oracle dba tasks?

1082

How to find the duplicate rows count from employees table in oracle?

1051

What is the quickest way to export a table to a flat file?

928

What is a package in oracle?

1040

What are the built-in functions used for sending Parameters to forms ?

3329

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1872

How a database is related to tablespaces?

995

What is oracle server autotrace in oracle?

1102

What is the relation of a user account and a schema?

1070

How to specify default values in insert statement using oracle?

1060

How to drop an index?

920

What are the types of partitions in oracle?

986

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