Connectez-vous
Créer une activité
Types d'activités
Centre d'aide
Entrez votre Game Pin
Blog
Premium
English
Español
Français
Créer une activité
Connectez-vous
Toutes les activités
Jouer Froggy Jumps
Imprimer Froggy Jumps
Week 09
Author :
Dezarea Bryan
1.
This is a standard language used to perform tasks such as retrieval, updation, insertion and deletion of data from a database.
A
PG-Promise
B
MySQL
C
SQL
2.
This SQL command extracts data from a database
A
*
B
SELECT
C
GET
3.
This SQL command updates data in a database
A
PUT
B
POST
C
UPDATE
4.
This SQL command deletes data from a database
A
DELETE
B
DELETED
C
DROPPED
5.
This SQL command inserts new data into a database
A
POST
B
ADD
C
INSERT INTO
6.
This SQL command modifies a database
A
GET
B
CHANGE DB
C
ALTER DATABASE
7.
This SQL command creates a new table
A
CREATE:TABLE
B
ADD TABLE
C
CREATE TABLE
8.
This SQL command modifies a table
A
CHANGE TABLE
B
ALTER TABLE
C
ALTER:TABLE
9.
This SQL command deletes a table
A
DROP TABLE
B
DELETE TABLE
C
table.delete()
10.
This SQL command deletes an index
A
DELETE INDEX
B
DROP INDEX
C
DELETE:INDEX
11.
PG-Promise: This query method expects one row or errors out
A
db.none()
B
db.result()
C
db.one()
12.
PG-Promise: This query method has no expectations.
A
db.none()
B
db.any()
C
db.result()
13.
PG-Promise: This query method expects no rows or results, to be resolved with null.
A
db.any()
B
db.none()
C
db.many()
14.
PG-Promise: This query method expects one or more rows
A
db.many()
B
db.any()
C
db.all()
15.
PG-Promise: This query method returns the raw results, useful for insert, update, and deletes.
A
db.result()
B
db.return()
C
db.raw()