NEW
Font size
WorksheetsSQL PRE-ASSESSMENT (MOTIVATION)
Total questions: 10
Worksheet time: 3mins
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;
