SQL Flashcards

1
Q

What is a primary key?

A

A unique ID to identify a row in the same tabel

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

What are 4 primare SQL operations

A
  1. Insert
  2. Select
  3. Update
  4. Delete
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is a foreign key

A

A key that can identify a unique row in another table.

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

What is a SQL injection?

A

is the placement of malicious code in SQL statements, via web page input. SQL injection is one of the most common web hacking techniques. SQL injection is a code injection technique that might destroy your database.

So place user input outside of the SQL Query

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