1
Q
What is SQL
A
Structured Query Language
2
Q
What can SQL be used for?
A
To search tables in a database for specific data
3
Q
Order of keywords
A
‘SELECT’ fieldname ‘FROM’ nameoftable
4
Q
What is ‘WHERE’ used for?
A
To specify conditions that a record must satisfy before it is returned
WHERE can be followed with Boolean operators to make the search more specific
Computer Science
flashcards
Decks in class (45)
# Cards
-
The CPU16
-
Memory6
-
CPU and System Performance5
-
Secondary Storage12
-
Systems Software - The OS13
-
System Software - Utilities6
-
Units8
-
Characters4
-
Storing Images9
-
Storing Sound7
-
Compression7
-
Networks - LANs and WANs9
-
Networks - Hardware11
-
Client-Server and Peer-to-Peer Networks7
-
Network Topologies6
-
Network Protocols15
-
Networks - The Internet9
-
Network Security Threats20
-
Ethical and Cultural Issues22
-
Environmental Issues5
-
Computer Legislation6
-
Open Source and Proprietary Software8
-
Design, Testing and IDEs16
-
Computational Thinking4
-
Writing Algorithms - Pseudocode3
-
Writing Algorithms - Flowcharts10
-
Search Algorithms4
-
Sorting Algorithms10
-
Programming Basics - Data Types12
-
Programming Basics - Operators8
-
Constants and Variables3
-
Strings2
-
Program Flow11
-
Boolean Logic7
-
Random Number Generation3
-
Arrays7
-
Storing Data7
-
Searching Data4
-
Sub Programs12
-
Structured Programming9
-
Defensive Design13
-
Testing16
-
Trace Tables3
-
Translators12
-
Integrated Development Environments5
