NEW
Font size
WorksheetsDatabase Questions
Total questions: 31
Worksheet time: 16mins
1. What MySQL function is use to retrieve data?
SELECT
UPDATE
DELETE
INSERT
What optimal data type for a `status` field which holds value of only 0,1,2,3 ?
tinyint
smallint
int
bigint
Is a process used to organize database into tables and columns?
Normalization
Sharding
Scaling
Join
What is a MySQL feature which enhances the speed execution of a select query?
Indexing
sharding
scaling
viewing
What MySQL keyword is used alongside other keyword to analyze your queries?
explain
group by
hash
where
What MySQL feature is used to combine rows from 2 or more tables based on related column between them?
join
inner join
outer join
select
Is a virtual table based on the result-set of an SQL statement?
views
query
select
update
What data type is optimal if it accepts date & time?
date_time
currdatetime
timestamp
date
What is the alternative to avoid using OR while still be able to use indexing?
union
full
select
update
A query nested inside a larger query
sub-queries
intersect
join
inner join
A practice of separating one table into multiple different tables
sharding
normalization
scaling
join
What is SQL
Structured Query Language
Standard Query Language
Stored Query Language
Structured Queue Language
What is NoSQL
non-relational database
normalized database
none object database
relational database
What is RDBMS?
relational database management system
relational database microsoft system
role database microsoft system
running database on microsoft system
Is installed and run on the premises of the person or organization?
on-premise
cloud
localhost
local network
A database that typically run on a cloud computing platform?
cloud database
local database
rdbms
sharding
Can you Identify this logo?
MariaDB
MySQL
MsSQL
Dolphin
Can you identify this logo?
Amazon Web Services
Microsoft Azure
Tencent
Redis
Can you identify this logo?
Tencent
Alibaba
Amazon Web Services
Microsoft Azure
Can you identify this logo?
Amazon Web Services
Tencent
Azure
Can you identify this logo?
OracleDB
Redis
MySQL
MsSQL
Can you identify this logo?
MsSQL
MySQL
Redis
Oracle
Can you identify this logo?
Sahara
SQLite
Siri
SequelPro
Can you identify this logo?
CouchDB
Couchbase
Oracle
Redis
Can you identify this logo?
Alibaba Cloud
Google Cloud
Amazon Cloud
Oracle Cloud
Can you identify this logo?
Redis
Oracle
MySQL
DynamoDB
Can you identify this logo?
Cassandra
Apache
Apache Kafka
Oracle
Can you identify this logo?
MySQL
MSSQL
Azure
Apache
Can you identify this logo?
PostgreSQL
MySQL
SQLite
PHP
Can you identify this logo?
Google Cloud
Alibaba Cloud
Tencent Cloud
Amazon Cloud
Can you identify this logo?
Huawei Cloud
Alibaba Cloud
Google Cloud
Amazon Cloud
