Font size
WorksheetsDDL
Total questions: 15
Worksheet time: 8mins
What does "SQL" stand for?
Structured Question Language
Structured Query Language
Simple Query Language
Simple Question Language
Less than or equal to?
>=
=>
=<
<=
DDL means
(a)
DML
(a)
______________ constraint prevents NULL values
UNIQUE
NOT NULL
NULL
FOREIGN KEY
A primary key can be NULL in the table? TRUE or FALSE
TRUE
FALSE
Select DDL commands from among the options...
SELECT
ALTER
DROP
DELETE
The restrictions or conditions applied on data are known as (a)
The primary key of a table which is present in another table for referencing is known as (a)
The command which changes the structure of a table is (a)
Which constraint(s) can be used to make sure that the column is not left empty?
NOT NULL
UNIQUE
PRIMARY KEY
ALL THE ABOVE
1.Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
a) Data Definition Language(DDL)
b) Data Manipulation Language(DML)
c) DDL and DML
d) None of the Mentioned
Write the correct SQL statement to create a new table called Persons
ـــــــــــــــــــــــــ (
PersonID int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
);
(a)
Write the correct SQL statement to create a new database called testDB
ــــــــــــــــــــــــــــــــــــــــــــــــــ ;
(a)
Add a column of type DATE called Birthday
ALTER TABLE Persons
ــــــــــــــــــــــــــــــ ;
(a)
