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 4018

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

 2 4460

how to genarate random numbers in oracle for particular row?

 3 6419

What is use of oracle?

Satyam,

2 4454

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 9117

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

 1559

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 3449

interview questions with answer for cts

Cognizant,

2074

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

 1 25833

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

TCS,

1626

what is normalisation?what are its uses?

1748

How many memory layers are in the shared pool?

 1 4222

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

 1651

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?

 2385

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

 1854

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a snapshot in oracle database?

564

what is normalisation?what are its uses?

1748

What is the difference between view and materialized view in Oracle?

597

Explain oracle left join with an example?

572

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1496




What is the difference between I and G in Oracle?

592

What is ADDM Advisor in Oracle?

652

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

595

How do I call oracle stored procedures that take no parameters?

555

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1549

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

1609

How would you go about verifying the network name that the local_listener is currently using?

1600

What is a data lock in oracle?

603

How do we get field details of a table?

538

How to initialize variables with default values?

621

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