Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 3366

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

2 3577

how to genarate random numbers in oracle for particular row?

3 5423

What is use of oracle?

Satyam,

2 3446

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 7935

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

1141

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 2722

interview questions with answer for cts

Cognizant,

1562

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

1 23313

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

TCS,

1244

what is normalisation?what are its uses?

1294

How many memory layers are in the shared pool?

1 3494

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

1199

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?

1929

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

1368


Post New Oracle General Questions






Un-Answered Questions { Oracle General }

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1014


what are archived logs?

1295


Where do you use decode and case statements?

125


What is the usage of analyze command in oracle?

140


How to delete a column in an existing table?

150






How to drop a tablespace?

136


What happens to indexes if you drop a table?

161


What is the quickest way to fetch the data from a table?

134


Give the various exception types.

129


How to invoke the data pump export utility?

137


what is the dual table in oracle?

138


ABOUT IDENTITY?

1057


Explain alias?

155


What are the numeric comparison operations?

140


Is there a function to split a string in plsql?

128