SQL DB

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