its one of the main coding languages used to access information in databases
2 of 22
How does SQL work?
SQL injections are pieces of SQL typed into a websites input box which then will reveal sensitive information
3 of 22
How can you prevent SQL injection?
use a web application firewall
4 of 22
Describe one other threat to a website
DOS - denial of service attack - where an attacker tries to stop a user from accessing a part of a website by making it slow or completely inaccessible
5 of 22
1 Ethical question - copying
Data protection act - protecting your data whilst it is sold and who can access your data
6 of 22
2 Ethical question - copying
Computer misuse act - copying and using peoples information with the intention to share sell or promote it without consent
7 of 22
3 Ethical question - copying
Copyright - when you make something it is lawfully yours under this copyright act. It is illegal to claim it is yours or to copy it
8 of 22
4 Ethical question - copying
Creative commons - Creative Commons (CC) licences make it easier and legal to share data online.
9 of 22
What is open source software?
Software where the source code is made freely available and the users can modify the code to create a spin off software which can be shared under the same licence and terms as the original software
10 of 22
Advantages of open source software
usually free, made for everyone to share ideas, can be adapted to suit needs, more collaborative than one programmer in a company and is very reliable and secure as problems are fixed much quicker by the community
11 of 22
Disadvantages of open source software
small projects won't get regular updates meaning they could be buggy, no warranties if something goes wrong, no customer support (however forums) and companies who use it to make custom software may not want their competitors to see their code
12 of 22
What is proprietary software?
Software that is usually paid for where only the compiled code is released, the source code is secret and its licences restrict the modification,copying and redistribution of the software
13 of 22
Advantages of proprietary software
Has customer support, well tested and reliable as the company's reputation depends on this, fixes and updates software regularly and is usually cheaper for companies than developing their own custom built software
14 of 22
disadvantages of proprietary software
expensive, may not fit a users needs and software companies may not maintain older software after warranties expire - the will want people to buy their latest product
15 of 22
What is a syntax error?
This is an error in the spelling or grammar used when coding.A syntax error will be identified by an interpreter as it will be unable to convert the source code into machine code.
16 of 22
What is a logical error?
An error in the logic of the code such as using ˂ instead of ˃ or AND instead of OR. The program will execute the code but will produce unexpected results.
17 of 22
What is an execution error?
An execution error occurs when a program is asked to do something that it cannot, resulting in a ‘crash’
18 of 22
What is an SQL query?
Query language is a written language used only to write specific queries. This is a powerful tool as the user can define precisely what is required in a database. SQL is a popular query language used with many databases.
19 of 22
What is the purpose of testing?
to check if it meets the requirements, is it specific to the design, does it have any errors?,is it secure, does it perform how it should? and is it user friendly
20 of 22
What is iterative testing?
when the program goes through the development cycle a few times to try to get it to match what the customer really wants
21 of 22
What is final testing?
When the program only goes through the development cycle once and all the required features are added at the same time. the program is tested against the initial requirements and the customer will get the bare minimal
22 of 22
Other cards in this set
Card 2
Front
What is SQL used for?
Back
its one of the main coding languages used to access information in databases
Comments
No comments have yet been made