Answer / Ankit Gupta

DDL (Data Definition Language) commands are used to create, alter, or drop database objects like tables, indexes, views, etc. in SQL and PL/SQL.nThe main DDL commands include:n- CREATE: To create a new database objectn- ALTER: To modify an existing database object (e.g., add or change columns in a table)n- DROP: To delete an existing database object

How do I save a stored procedure?

1 Answers  

---

Which join is like an inner join?

1 Answers  

---

which tcp/ip port does sql server run on? : Sql dba

1 Answers  

---

Define join and name different types of joins?

1 Answers  

---

What are the types of queries in sql?

1 Answers  

---

what are wild cards used in database for pattern matching ? : Sql dba

1 Answers  

---

Where the integrity constrints are stored in Data Dictionary?

1 Answers  

---

Is foreign key mandatory?

1 Answers  

---

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  

---

How do you define a foreign key?

1 Answers  

---

Is oracle and sql same?

1 Answers  

---

What does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

---