Font size
S
M
L
XL
WorksheetsDATABASE
Total questions: 10
Worksheet time: 5mins
Name
Class
Date
1.
Which of the following is not an MS SQL Syntax
a)
CREATE
b)
PURGE
c)
DELETE
d)
TRUNCATE
2.
Independent Software Vendors (ISVs) can embed SQL Server Express with their own software.
a)
True
b)
False
3.
Apple uses what database?
a)
Oracle
b)
SQL Express
c)
OpenSQL
d)
PostgreSQL
4.
PostgreSQL can be a relational and non relational database
a)
True
b)
False
5.
Which of the two can rollback transactions
a)
MS SQL
b)
Oracle
6.
Transact SQL (T-SQL) is used in:
a)
Azure SQL Database
b)
MS SQL
c)
Oracle
d)
Azure SQL Managed Instance
7.
Oracle has an easier syntax than MS SQL
a)
True
b)
False
8.
It deletes the data inside a table but not the table itself
a)
Purge
b)
Prune
9.
Non-relational databases can only store data in rows and columns
a)
True
b)
False
10.
SQL Express only has a maximum database size of 10GB
a)
True
b)
False
Reset
