what is a field in a database ? : Sql dba

0 Answers  

---

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

1 Answers   CGI,

---

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  

---

Why truncate is used in sql?

0 Answers  

---

Difference between DBMS and RDBMS...CODD's rules

4 Answers   Polaris,

---

What is the difference between delete and truncate statement in sql?

0 Answers  

---

What is the maximum rows in csv?

0 Answers  

---

how to present a past time in hours, minutes and seconds? : Sql dba

0 Answers  

---

What is an escape character in sql?

0 Answers  

---

What is a dirty read sql?

0 Answers  

---

Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

4 Answers   IBM, Metric Stream,

---

Which is the correct statement about truncate and delete?

0 Answers  

---