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 5681

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 10351

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 4512

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,

2225

what is normalisation?what are its uses?

2328

How many memory layers are in the shared pool?

1 5089

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?

2872

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 }

How to retrieve values from data fields in record variables?

1171

What is the difference between translate and replace in oracle?

1216

What is control file used for?

1300

Explain the use of online redo log files in oracle.

1077

What are ddl statements in oracle?

1127

How remove data files before opening a database?

1133

How to rename an index?

1122

What to do if dba lost the system password?

1244

what is the difference between restoring and recovering?

1053

How to execute a stored program unit?

1128

How can you use check constraints for self referential integrity?

1017

How to create a new tablespace in oracle?

1032

Will you be able to store pictures in the database?explain.

1034

How to find out what oracle odbc drivers are installed?

1092

Explain the use of tables option in exp command.

1166

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