Sign Up Login


  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category
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 4380

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

 2 4939

how to genarate random numbers in oracle for particular row?

 3 6973

What is use of oracle?

Satyam,

2 4880

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 9639

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

 1775

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 3884

interview questions with answer for cts

Cognizant,

2331

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

 1 26305

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

TCS,

1855

what is normalisation?what are its uses?

1952

How many memory layers are in the shared pool?

 1 4586

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

 1876

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?

 2587

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

 2056

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2385

What is the difference between $oracle_base and $oracle_home?

805

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

1855

When system tablespace is created?

789

How to get execution statistics reports on query statements?

813

How many types of cluster table in Oracle?

789

Can the query output be sorted by multiple columns in oracle?

755

How to create a stored program unit?

798

Explain an exception and its types?

814

Explain how are indexes update?

824

What is integrity and what is constraint??Explain with example

1971

What is oracle host variable?

717

How will you identify oracle database software release?

756

What is a subquery in oracle?

792

Can we convert a date to char in oracle and if so, what would be the syntax?

774

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