SQL

Question 1

What Does SQL Stand For?

Answer 1

Structured Query Language

Question 2

Where Do Most Companies Store Their Data?

Answer 2

In Databases

Question 3

What is a Relational Database?

Answer 3

A relational database is a database that stores related information across multiple tables and allows you to query information in more than one table at the same time.

Question 4

What is SQL Used For?

Answer 4

SQL is Used to Communicate with Databases

Question 5

A Relational Database Contains One or More Objects Called……?

Answer 5

Tables

Question 6

What is the ‘Select’ Statement Used For?

Answer 6

It is used to query the database and retrieve selected data that matches the criteria that you specify.

Question 7

What is the ‘Create Table’ Statement Used For?

Answer 7

To Create a new Table

Question 8

What is the ‘Insert’ Statement Used for?

Answer 8

The insert statement is used to insert or add a row of data into the table

Question 9

What is the ‘Update’ Statement Used for?

Answer 9

The update statement is used to update or change records that match a specified criteria

Question 10

What is the ‘Delete’ statement Used for?

Answer 10

The delete statement is used to delete records or rows from the table.

Question 11

Who at IBM Developed SQL?

Answer 11

Raymond Boyce and Donald Chamberlin developed SQL at IBM in the early 1970s

Question 12

What Does ANSI Stand For?

Answer 12

American National Standards Institute

Question 13

What Does ISO Stand For?

Answer 13

International Organisation for Standardisation

Question 14

Information is Stored in Tables and, in Turn, the tables are Stored in…….?

Answer 14

Databases

Question 15

What Does DBMS Stand For?

Answer 15

Database Management System

Question 16

What Does DDL Stand For?

Answer 16

Data Definition Language

Question 17

What Does DML Stand For?

Answer 17

Data Manipulation Language

Question 18

What Do Tables Consist of?

Answer 18

Columns and Rows

Question 19

What are the Commands that we use to Retrieve Information from a Database Called?

Answer 19

Queries

Question 20

Where are the SQL Commands Written?

Answer 20

In a Command Editor

Question 21

What is the Process the Database Follows when it Receives an SQL Query

Answer 21

1 - Sees Query
2 - Looks at 'FROM' to Identify Table
3 - Looks at Condition (WHERE) to Eliminate Rows
4 - Looks at SELECT to Eliminate Columns
5 - Displays Results

Question 22

Although SQL isn’t Case Sensitive, what do we Need to Ensure about text held between the Parenthesis?

Answer 22

We have to ensure that the text between the parenthesis is EXACTLY the same as it is in the database.

Question 23

What are Operators Used For?

Answer 23

Operators are Used to Compare Information

Question 24

What are the 6 Operators we Use?

Answer 24

> Greater Than
< Less Than
= Equals To
!= Not Equals To
>= Greater Than or Equal To
<= Less Than or Equal To

Question 25

What is a database

Answer 25

A Database is a repository for Data

Question 26

What percentage of the Oracle Exam is about Writing Queries?

Answer 26

60%

Question 27

What Exam is this Study Preparing you for?

Answer 27

Oracle Database SQL 1Z0-071

Question 28

Is SQL Case Sensitive?

Answer 28

No

Question 29

What Select Command would you use to retrieve all Rows and Columns from a Table called ‘Emp’?

Answer 29

SELECT *

FROM Emp;

Question 30

What Select Command Would you use to return all rows from the ‘Emp’ Table but only show the ‘Job’ Column?

Answer 30

SELECT Job

FROM Emp;

Question 31

What is an SQL Query?

Answer 31

An SQL Query is a command that asks the database to return information without adding data, changing data, updating data, modifying data etc…

Question 32

What SQL Query would return the ‘DeptName’ and the ‘DeptLocation’from the ‘Dept’ Table?

Answer 32

SELECT DeptName, DeptLocation

FROM Dept;

Question 33

What SQL Query would you use to return the unique job titles from a table called ‘Emp’?

Answer 33

SELECT DISTINCT JobTitle

FROM Emp;