Coursera_web_2

DBA stands for

Structured Query Language (SQL) is used to (check all that apply)

• Insert data

• Delete data

• Create a table

• Run php

Which statement is the right syntax to make a new database using command line?

• CREATE people;

• CREATE DATABASE people;

• MAKE people;

• MAKE people;

"INSERT INTO" is the keyword used to insert data into tables.

• True

• False

Which keyword is used to add conditions to your query?

• ONLYIF

• IF

• SELECT

• WHERE

Which command is used to retrieve all records from the table?

• SELECT all FROM Users

• RETRIVE * FROM Users

• RETRIVE all FROM Users

• SELECT * FROM Users

Which keyword will cause the results of the query to be displayed in sorted order?

• None of these

• GROUP BY

• WHERE

• ORDER BY

The LIMIT clause reduces the number of rows returned by a query.

• True

• False

A [_____] column allocates a string with a variable amount of space depending on the data length that is actually stored.

A column of type CHAR cannot be indexed.

• True

• False