New Activity
New Activity
All the activities
Play Froggy Jumps
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()