DBMS-Relational Query Languages
DBMS-Relational Query Languages
22. Which of the following statements is used to create a table?
- CREATE TABLE
- MAKE TABLE
- COSNSTRUCT TABLE
- None of these
23. Which of the following is the result of a SELECT statement ?
- TRIGGER
- INDEX
- TABLE
- None of these
24. The SQL data definition language (DDL) provides command for:
- defining relation schemas
- deleting relations
- modifying relation schemas
- all of these.
25. Which of the following is a clause in SELECT statement ?
- GROUP BY and HAVING
- WHERE
- ORDERBY
- All of these
27. Which of the following statement is used to modify a table?
- MIDIFY TABLE
- UPDATE TABLE
- ALTER TABLE
- All of these.
28. DROP operation of SQL is used for:
- deleting tables from schemes
- changing the definition of table
- Both of these
- None of these.
29. ALTER operation of SQL is used for:
- deleting tables from schema
- changing the definition of table
- Both of these
- None of these
30. Which of the following clause specifies the table or tables from where the data has to be retrieved?
- WHERE
- TABLE
- FROM
- None of these.