WorksheetsDDL - Create
Total questions: 10
Worksheet time: 5mins
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
