DDL - Create

Which of the following is the full form of DDL?

• Data derivation language.

• Data definition language.

• Dynamic Data language.

• Detailed Data language.

Which command is used to remove all rows from a table?

• Delete

• Remove

• Truncate

• Both Delete and Remove

A command that lets you change one or more fields in a record is ............

• Insert

• Modify

• Look-up

• All of the three

Which command is used to add a column to an existing table ?

• Create

• Update

• Alter

• None of these

What is the language used by most of the DBMS for helping their users to access data ?

• High level language

• Query language

• SQL

• 4GL

Which of the following is not an SQL command ?

• CREATE

• DROP

• ALTER

• All are SQL commands

This is an authorization command of SQL :

• Access

• Grant

• Allow

• None of these

Grant is a command from SQL type :

• DDL

• DML

• DCL

• TCL

Which of the following is not true about SQL statements?

• SQL statements are not case sensitive.

• SQL statements can be written on one or more lines.

• Keywords cannot be split across lines.

• Clauses must be written on separate lines.

What is the basic unit of storage in Oracle Database that contains data?

• View

• Column

• Query

• Table