Latihan Basic Mysql

What does SQL stand for?

• Structured Query Language

• Structured Question Language

• Strong Question Language

• None of the above

What does DML stand for?

• Data Manipulation Language

• Data Modeling Language

• Data Markup Language

• Data Migration Language

INSERT INTO EMP VALUES(101,'SUMAN','MANAGER');

Which kind of statement is this ?

• DDL

• DML

• Value

• Python statement

Which of the following is not a keyword of MYSQL?

• Select

• Top

• Group

• Insert

Which of the following query is correct to get Current Date from Query?

A. SELECT DATE ( NOW() ) as today;

B. SELECT DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) as today;

• A. SELECT DATE ( NOW() ) as today;

• B. SELECT DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) as today;

• Both A and B

• None

Which of the following is not a valid aggregate function?

• COUNT

• MIN

• COMPUTE

• MAX

SQL is not case sensitive. SELECT is the same as select.

• TRUE

• FALSE

The _________ statement is used to delete a table.

• DROP TABLE

• DELETE TABLE

• DEL TABLE

• REMOVE TABLE

Which one of the following sorts rows in SQL?

• SORT BY

• ALIGN BY

• GROUP BY

• ORDER BY

The SQL statement that queries or reads data from a table is __________ .

• USE

• SELECT

• READ

• QUERY