Font size
WorksheetsSQL
Total questions: 23
Worksheet time: 14mins
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
3. A command that lets you change one or more fields in a record is
a) Insert
b) Modify
c) Look-up
d) All of the Mentioned
4. Which of the SQL statements is correct?
a) SELECT Username AND Password FROM Users
b) SELECT Username, Password FROM Users
c) SELECT Username, Password WHERE Username = ‘user1’
d) None of the Mentioned
A scout company have a database with records of all the scouts. They want to create a list of all scouts who are under 15 and their achievements. What would they use?
Report
Form
Query
Sort
The command to remove rows from a table ‘CUSTOMER’ is __________________
DROP FROM CUSTOMER
UPDATE FROM CUSTOMER
REMOVE FROM CUSTOMER
DELETE FROM CUSTOMER WHERE
SQL query to find all the cities whose humidity is 95.
SELECT city WHERE humidity = 95
SELECT city FROM weather WHERE humidity = 95
SELECT humidity = 89 FROM weather
SELECT city FROM weather
What does SQL stand for?
Standard Query Language
Sequential Query Language
Structured Question Language
Structured Query Language
Match the following SQL term with a description - FROM
The criteria which must be met
The fields to display
The field and order used to sort the results
The table used in the query
Match the following SQL term with a description - SELECT
The fields to display
The table used in the query
The criteria which must be met
The field and order used to sort the results
Match the following SQL term with a description - WHERE
The table used in the query
The fields to display
The field and order used to sort the results
The criteria which must be set
What is a field?
A collection of information
A single item of information
A list of information
A group of records
Which of the following is not a database data type?
text
number
array
date
Which statement is used to extract data from a database?
Extract
Get
Open
Select
If you were wanting to filter data, which clause would you use?
Where
Order by
From
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
Which query would return only the fields DesignerID and Designer?
SELECT * FROM Designers
SELECT DesignerID, Name FROM Designers
SELECT DesignerID AND Designer FROM Designers
SELECT DesignerID, Designer FROM Designers
When examining a row in a table, we refer to it as a...
row number
result number
record
result
When examining a column in a table, we refer to it as a...
field name
folder name
column number
table name
When defining a table, each field name has both a ...
table name and a database
command and an argument
goal and a purpose
name and a data type
varchar is better than varchar2
yes
no
Create a table of your own choice, demonstrate varchar, char, number, varchar2 data type.
