what is oltp (online transaction processing)? : Sql dba

0 Answers  

---

How many types of keys are there in sql?

0 Answers  

---

Does sql between include endpoints?

0 Answers  

---

what is cursor procedure

1 Answers   iGate,

---

Is stored procedure faster than query?

0 Answers  

---

---

What is meant by Materialized view?

2 Answers   iGate, Marlabs, Polaris,

---

Can a foreign key have a different name?

0 Answers  

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

0 Answers  

---

What is crud stand for?

0 Answers  

---

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

---

How many types of tables are there?

0 Answers  

---

What is scope of pl sql developer in future?

0 Answers  

---