Databases (MySQL)

• ICT
• MBO
• Studiejaar 1

wat doet de SQL-methode CHAR_LENGTH()?

I.p.v. CHAR_LENGTH() meteen bij de SQL-query in te stoppen, kun je ook in php de lengte van een string opvragen. Met welke functie kan dat?

INSTR( str , substr ) geeft de positie van de eerste gevonden substr in str; welke php-functie doet hetzelfde?

Wat doet de SQL-methode LOWER()?

Welke php-functie doet hetzelfde als LOWER()?

Wat doet de SQL-methode
REPLACE( string , vervang , door)

Welke functie in php doet hetzelfde als REPLACE() in SQL?

Wat doet de SQL-stringmethode RIGHT()?

Welke PHP-functie doet hetzelfde als SQL-methode RIGHT()

Wat doet de stringmethode LTRIM()?

Welke PHP-functie doet hetzelfde als SQL-methode LTRIM()

Wat denk je dat de SQL-stringmethode REVERSE() doet? (niet opzoeken)

Wat doet de SQL-Date-methode CURDATE()?

Wat doet de SQL-DATE-methode DAYNAME()?

Wat doet de SQL-DATE-methode DATEDIFF()?

Pasfoto's!!!!

With SQL, how do you select all the columns from a table named "Persons"?

1. SELECT *.Persons
2. SELECT Persons
3. SELECT [all] FROM Persons
4. SELECT * FROM Persons

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

1. SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'
2. SELECT * FROM Persons WHERE FirstName='Peter'
3. SELECT * FROM Persons WHERE FirstName<>'Peter'
4. SELECT [all] FROM Persons WHERE FirstName='Peter'

Which SQL statement is used to create a database table called 'Customers'?

1. CREATE DB Customers
2. CREATE DATABASE TABLE Customers
3. CREATE TABLE Customers
4. CREATE DATABASE TAB Customers

Which SQL statement is used to extract data from a database?

1. SELECT
2. EXTRACT
3. GET
4. OPEN

Which SQL statement is used to update data in a database?

1. MODIFY
2. SAVE AS
3. SAVE
4. UPDATE

Which SQL statement is used to delete data from a database?

1. COLLAPSE
2. REMOVE
3. DELETE

Which SQL statement is used to insert new data in a database?

1. ADD RECORD
2. ADD NEW
3. INSERT NEW
4. INSERT INTO

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

1. EXTRACT FirstName FROM Persons
2. SELECT FirstName FROM Persons
3. SELECT Persons.FirstName

With SQL, how do you select all the columns from a table named "Persons"?

1. SELECT * FROM Persons
2. SELECT Persons
3. SELECT *.Persons
4. SELECT [all] FROM Persons

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

1. SELECT [all] FROM Persons WHERE FirstName='Peter'
2. SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'
3. SELECT * FROM Persons WHERE FirstName='Peter'
4. SELECT * FROM Persons WHERE FirstName<>'Peter'

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

1. SELECT * FROM Persons WHERE FirstName='%a%'
2. SELECT * FROM Persons WHERE FirstName='a'
3. SELECT * FROM Persons WHERE FirstName LIKE '%a'
4. SELECT * FROM Persons WHERE FirstName LIKE 'a%'

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

1. TRUE
2. FALSE

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

1. SELECT FirstName='Peter', LastName='Jackson' FROM Persons
2. SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'
3. SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

Which SQL statement is used to return only different values?

1. SELECT DISTINCT
2. SELECT DIFFERENT
3. SELECT UNIQUE

Which SQL keyword is used to sort the result-set?

1. SORT
2. SORT BY
3. ORDER
4. ORDER BY

Tabel: 'adressen'
Kolom: 'straat'
SQL-vraag: selecteer de eerste drie karakters (letters) van alle straten

Tabel: 'adressen'
Kolom: 'straat'
SQL-vraag: selecteer alle records waarvan de straatnaam eindigt op 'weg'

Database: 'persoonsgegevens'
SQL-vraag: maak een tabel 'straat' aan met de kolommen 'straat_id', 'straatnaam' en 'plaats_id'

Tabel: 'straat'
Kolommen: 'straat_id', 'straatnaam' en 'plaats_id'
SQL-vraag: voeg een rij toe met de gegevens: 'Trekweg' en '3' (voor de plaats_id)

Tabel: adres
Kolommen: 'straatnaam', 'huisnummer' en 'plaatsnaam'
SQL-vraag: selecteer de adressen uit de tabel waarbij de straat, huisnr en de plaatsnaam achter elkaar aan geplakt zijn