Font size
WorksheetsSQL DB
Total questions: 11
Worksheet time: 8mins
What is the Full Form of DDL
Data Determination Language
Data Description Language
Data Definition Language
Data Damage Language
What values can be stored in a column with Datatype as Varchar2
ABCD
!@#$
AB12
All The Above
Which of the create table syntax is correct ?
Create table_name
(
Emp_Name Varchar2(10),
Emp_No Number,
Salary Number
);
Create Table table_name
(
Emp_Name Varchar2(10),
Emp_No Number,
Salary Number
);
Create Table table_name
(
Emp_Name Varchar2(10),
Emp_No Number,
Salary Number,
;
Create Table
(
Emp_Name Varchar2(10),
Emp_No Number,
Salary Number
);
What alter keyword is followed by column and column Name ?
Rename
Drop
Add
Modify
Rename
Modify
All the Above
Which SQL statement is followed by commit;
Insert
Update
Delete
Both A & B
None of the Above
Write an update statement to update salary of A employee to 7000.
Table_Name : emp
Name Number salary Location
A 01 5000 HYD
B 02 7000 BLR
C 03 9000 CHN
(a)
Which all of the below statements comes under TCL ?
Commit
Grant
Savepoint
Rollback
Commit
revoke
Commit
Rollback
Savepoint
Grant
Revoke
What happens to the table if I run the truncate statement ?
Deletes data and structure
Deletes only structure
Deletes the complete table from database
Deletes only the data but not structure
What all can be done by running a delete statement ?
Deletes complete data but not structure
Deletes specific data
Both A & B
deletes structure and data
What is the functionality of the rollback ?
Rollback your data till last commit point
Roll back all your data
Rollback will not rollback the data it will rollback only the structure
None of the above
what happens to a table when we run a drop statement?
Deletes the structure
Removes structure and data
Remove the complete object from the database
Both B & C
