SQL PRE-ASSESSMENT (MOTIVATION)

It is a very popular, open-source database. And officially pronounced “my Ess Que Ell” (not my sequel).

It handles very large databases; very fast performance.

• Oracle

• MySQL

• SQL

• MariaDB

What software is used to access SHELL and PHPMYADMIN?

• Control Panel

• SQL

• XAMPP Control Panel

• Oracle

To run XAMPP Control Panel, what ports should be started?

• FileZilla and MySQL

• Tomcat and Mercury

• MySQL and Apache

• Apache and Tomcat

To enter MariaDB, what setting should we click to access the MariaDB environment?

• Shell

• Config

• Netstat

• Services

To access the localhost, what are the following commands to run access MariaDB?

• mysql -u root -p -h 127.0.0.1

• sql root 127.0.0.1

• ENTER DATABASE;

• CREATE DATABASE;

BASIC QUERIES: Which of the following is a correct syntax to select the current version and date?

• SELECT version, current date ();

• SELECT version (), current_date;

• SELECT * version (), current date;

• SELECT version (), current date();

BASIC QUERIES: Which of the following commands is the correct syntax to show databases?

• CREATE DATABASE;

• DISPLAY DATABASES;

• SHOW DB;

• SHOW DATABASES;

BASIC QUERIES: Which of the following commands is the correct syntax to show tables?

• CREATE TABLES;

• SHOW TABLES;

• DISPLAY TABLES;

• DESCRIBE TABLES;

BASIC QUERIES: Which of the following commands is the correct syntax to show table structure?

• TABLE STRUCTURE tbl_name;

• SHOW tbl_name;

• DESCRIBE tbl_name;

• STRUCTURE tbl_name;

BASIC QUERIES: Which of the following commands is the correct syntax to use existing database?

• USE db_name;

• USE DATABASE;

• OPEN db_name;

• OPEN DATABASE;