Sql DDL Statement Set 1

'Insert ' is a ddl statement .

true

false

Which is not a ddl statement ?

create

alter

delete

drop

Which statements are true about ddl ?

DDL stands for Data definition language

DDL is similar to a computer programming language for defining data structures, especially database schemas.

Create, drop, alter are ddl commands

It is also used for inserting, deleting and updating data in a database

What is the right command for creating database ?

create db user1 ;

create user1 as db;

create user1 as database;

create database user1 ;

To make a new database, table, index which of the following we can use

alter

create

add

update

Which is the correct format for create table ?

CREATE EMP.SCOTT TABLE (
EmpNo NUMBER,
EName VarChar(25),
Job Char(10) ,
Hiredate Date,
)

CREATE EMP TABLE (
EmpNo NUMBER,
EName VarChar(25),
Job Char(10) ,
Hiredate Date,
)

CREATE TABLE EMP (
EmpNo NUMBER,
EName VarChar(25),
Job Char(10) ,
Hiredate Date,
)

All the abov

Which statements are true about 'Alter' Statement ?

Its used when we want to change the table structure

We add a column using this command

We drop a column using this command

It is also used for dropping constraint

How to add Emp_Address column to emp table ?

ALTER TABLE EMP add ( EMP_Address Char(24));

ALTER TABLE EMP add EMP_Address Char(24);

ALTER EMP add ( EMP_Address Char(24));

All the above

How to add multiple column like Address and DOB , DeptNo to emp table?

ALTER TABLE EMP add ( Address Char(24),Dob date,DeptNo number(8));

ALTER TABLE EMP add ( Address Char(24)),
add( Dob date),
add (DeptNo number(8));

ALTER TABLE EMP add ( Address Char(24),
Dob( date),
add (DeptNo number(8));

First and Second one

To change the datatype of a column which is the correct statement

ALTER TABLE table_name
update column_name column_type;

ALTER TABLE table_name
rename column_name column_type;

ALTER TABLE table_name
MODIFY column_name column_type;

ALTER TABLE table_name
rechange column_name column_type;