1. CREATE – It is used to create database objects like table, view etc.
2. ALTER – It is used to alter the structure of the existing database object.
3. DROP – It is used to delete the existing objects from the database.
4. TRUNCATE – It remove all records from a table, including all spaces allocated for the records will be removed.
5. RENAME – It is used to rename an existing database object.
- What is DBMS?
- What is RDBMS?
- Difference between DBMS and RDBMS
- What are various DDL commands in SQL?
- What are various DML commands in SQL?
- What are various DCL commands in SQL?
- Can you sort a column using a column alias?
- Is a null value same as zero or a blank space if not then what is the difference?
- How can you eliminate duplicate rows from a query result?
- Difference between TRUNCATE, DELETE and DROP commands?
- What is the difference between CHAR and VARCHAR2 datatype in SQL?
- What are the differences between sql and pl/sql?
- What are the transaction properties in sql?
- What is the sql case statement used for?
- How many types of aggregate functions are there in sql?
- What are scalar functions in sql?
- What is the difference between sql and mysql?
- What is the use of nvl function in sql?
- What do you mean by subquery?
- What are Indexes in SQL?
- How to create index in oracle sql?
- How to view index in oracle sql?
- How to get list of tables in oracle sql
- Difference between clustered and nonclustered indexes in oracle sql?
- How to update with select subquery in sql server
- Explain different types of index in sql server