Answer Posted / shachindra pandey

proc sql;
select id,name,population from populations where
population=(select max(population) from
populations
where population < (select max(population) from
populations));


quit;

Will you be able to store pictures in the database?

1121

---

What privilege is needed for a user to insert rows to tables in another schema?

1015

---

What are the data types in oracle?

1040

---

What are the various types of snapshots ?

1029

---

What is a trigger oracle?

1086

---

How do I reset a sequence in oracle?

1098

---

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4174

---

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1971

---

Does oracle charge for java?

1056

---

Name the three major set of files on disk that compose a database in Oracle?

1123

---

What is define in oracle?

1060

---

What is the difference between pre-select and pre-query?

1219

---

How to define a variable of a specific record type?

1078

---

Explain the difference between sap and oracle?

1029

---

What operating systems are supported by oracle database 10g xe?

1034

---