Informatics Practices
Which of the following are DDL commands?
(A) Delete
(B) Create
(C) Update
(D) Alter
(E) Drop
- (B), (D) and (E)
- (A), (B) and (D)
- (B), (C) and (D)
- (A), (B) and (C)
Answer
(B), (D) and (E)
Reason — DDL (Data Definition Language) commands are used to create and define tables and other database objects in SQL (Structured Query Language). DDL commands such as CREATE, ALTER, and DROP, are used to create, define, change and delete objects like tables, indexes, views, and constraints.
Related Questions
A …………… is a text that is not executed.
- Statement
- Query
- Comment
- Clause
…………… are words that have a special meaning in SQL.
- Keyword
- Literal
- Variable
- Table
Identify the correct statement(s):
Statement 1 (S1): Char data type in MySQL stores fixed length strings.
Statement 2 (S2): Char data type stores string smaller than the maximum field size.
- (S1) : Correct, (S2) : Correct
- (S1): Incorrect, (S2) : Correct
- (S1): Correct, (S2) : Incorrect
- (S1) : Incorrect, (S2) : Incorrect
Which of the following keywords is used to display non-repeated values in MySQL?
- Unique
- All
- Order by
- Distinct