WorksheetsDBMS LAB
Total questions: 20
Worksheet time: 19mins
Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
DML(Data Manipulation Langauge)
DDL(Data Definition Langauge)
Query
Relational Schema
CREATE TABLE employee (name VARCHAR, id INTEGER)
What type of statement is this?
DML
DDL
View
Integrity constraint
The SQL used by front-end application programs to request data from the DBMS is called _______
A. DML
B .DDL
C .VDL
D. SDL
The command used to delete a particular column in a relation is ____________
A.UPDATE TABLE
B.TRUNCATE COLUMN
C.ALTER , DROP
D.DELETE COLUMN
What is the full form of DDL ?
A.Dynamic Data Language
B.Detailed Data Language
C.Data Definition Language
D.Data Derivation Language
In SQL, which command is used to SELECT only one copy of each set of duplicable rows
A. SELECT DISTINCT
B. SELECT UNIQUE
C. SELECT DIFFERENT
D. All of the above
A database management system (DBMS) is a collection of programs that enables users to
create a database
manipulate a database
both create and manipulate a database
for storing data only
The database definition or descriptive information is also stored by the DBMS in the form of a _______________
Data catalog
excel file
document file
pdf file
The database and DBMS software together is called a ________________
Database system
Data Model
Application Program
System software
What does "SQL" stand for?
Structured Question Language
Structured Query Language
Simple Query Language
Simple Question Language
Which statement is used to extract data from a database?
Extract
Get
Open
Select
Which word is missing from the following SQL statement?
Select * table_name
With
Where
From
And
How do we select all rows for the "Designer" table?
SELECT * FROM Designer
SELECT [All] FROM Designer
SELECT Designer.*
SELECT FROM Designer
DDL means
(a)
DML
(a)
It is a DML command that is used to display record.
DISPLAY
STRUCTURE
WHERE
SELECT
Where does the CREATE Command belong?
DML
DDL
DCL
An SQL command used to create a table.
Insert
Create
Update
Add
What is the meaning of DCL?
Data Count Language
Database Control Language
Data Calculation Language
Data Control Language
