MySQL & PHP Basic MCQs

MySQL & PHP Basic MCQs

Professional Development

20 Qs

quiz-placeholder

Similar activities

Novels

Novels

Professional Development

16 Qs

Indirect Quesitons

Indirect Quesitons

Professional Development

16 Qs

Unit 3 - World English 3

Unit 3 - World English 3

Professional Development

15 Qs

Rigel A

Rigel A

10th Grade - Professional Development

15 Qs

ART OF FILM

ART OF FILM

7th Grade - Professional Development

21 Qs

VRESEC-24.01.2024-AN-1-3

VRESEC-24.01.2024-AN-1-3

Professional Development

15 Qs

Business Writing

Business Writing

Professional Development

20 Qs

Group E Live quiz

Group E Live quiz

KG - Professional Development

20 Qs

MySQL & PHP Basic MCQs

MySQL & PHP Basic MCQs

Assessment

Quiz

English

Professional Development

Practice Problem

Hard

Created by

shwetha Asoftlab

Used 3+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which command is used to create a new database?

CREATE NEW DATABASE dbname;

MAKE DATABASE dbname;

CREATE DATABASE dbname;

ADD DATABASE dbname;

2.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which command is used to remove a database?

DROP DATABASE dbname;

DELETE DATABASE dbname;

REMOVE DATABASE dbname;

DESTROY DATABASE dbname;

3.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which statement is used to retrieve data from a database?

FIND

GET

SELECT

RETRIEVE

4.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which keyword is used to sort the result set in ascending order?

ORDER BY ASC

SORT ASC

ASCEND

SORT BY

5.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which function is used to count rows?

COUNT()

SUM()

ROWS()

TOTAL()

6.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which SQL statement is used to add new data to a table?

INSERT INTO

ADD TO

UPDATE

APPEND

7.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which SQL keyword is used to update existing data?

CHANGE

MODIFY

UPDATE

ALTER

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?