SQL

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

One specific piece of information about a person or thing is called:

• Field
• File
• Record
• Table

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