This set of Database Questions & Answers focuses on ” SQL Basics and SQL Data Definition”
🔥2 playsPublished
0 of 5 answered
Stacked
1. Which one of the following is used to define the structure of the relation ,deleting relations and relating schemas ?
1/5
Choose one
a) DML(Data Manipulation Langauge)
b) DDL(Data Definition Langauge)
c) Query
d) Relational Schema
b)DDL
2. Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database ?
2/5
Choose one
a) DML(Data Manipulation Langauge)
b) DDL(Data Definition Langauge)
c) Query
d) Relational Schema
Select * from employee
What type of statement is this?
3/5
Choose one
a) DML
b) DDL
c) View
d) Integrity constraint
a
The basic data type char(n) is a _____ length character string and varchar(n) is _____ length character.
4/5
Choose one
a) Fixed, equal
b) Equal, variable
c) Fixed, variable
d) Variable, equal
c
To remove a relation from an SQL database, we use the ______ command.