SQL Flashcards

1
Q

What Does SQL Stand For?

A

Structured Query Language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Where Do Most Companies Store Their Data?

A

In Databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is a Relational Database?

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is SQL Used For?

A

SQL is Used to Communicate with Databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

Tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is the ‘Select’ Statement Used For?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is the ‘Create Table’ Statement Used For?

A

To Create a new Table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is the ‘Insert’ Statement Used for?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is the ‘Update’ Statement Used for?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is the ‘Delete’ statement Used for?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Who at IBM Developed SQL?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What Does ANSI Stand For?

A

American National Standards Institute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What Does ISO Stand For?

A

International Organisation for Standardisation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

Databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What Does DBMS Stand For?

A

Database Management System

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What Does DDL Stand For?

A

Data Definition Language

17
Q

What Does DML Stand For?

A

Data Manipulation Language

18
Q

What Do Tables Consist of?

A

Columns and Rows

19
Q

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

20
Q

Where are the SQL Commands Written?

A

In a Command Editor

21
Q

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

A
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
22
Q

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

A

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

23
Q

What are Operators Used For?

A

Operators are Used to Compare Information

24
Q

What are the 6 Operators we Use?

A
> Greater Than
< Less Than
= Equals To
!= Not Equals To
>= Greater Than or Equal To
<= Less Than or Equal To
25
What is a database
A Database is a repository for Data
26
What percentage of the Oracle Exam is about Writing Queries?
60%
27
What Exam is this Study Preparing you for?
Oracle Database SQL 1Z0-071
28
Is SQL Case Sensitive?
No
29
What Select Command would you use to retrieve all Rows and Columns from a Table called 'Emp'?
SELECT * | FROM Emp;
30
What Select Command Would you use to return all rows from the 'Emp' Table but only show the 'Job' Column?
SELECT Job | FROM Emp;
31
What is an SQL Query?
An SQL Query is a command that asks the database to return information without adding data, changing data, updating data, modifying data etc...
32
What SQL Query would return the 'DeptName' and the 'DeptLocation'from the 'Dept' Table?
SELECT DeptName, DeptLocation | FROM Dept;
33
What SQL Query would you use to return the unique job titles from a table called 'Emp'?
SELECT DISTINCT JobTitle | FROM Emp;