What is the most used database type in computing?
NoSQL Database
Relational Database
Flat File Database
Which one of the following is an advantage of storing data in tables?
Tables let you store large amounts of data.
Tables provide a simple and clear view of data
Tables offer the ability to encrypt data.
In a bookshop database, the complete information about one specific book is referred to as a ______________.
Table
Record
Column
What makes SQL a very popular database language? Select all that apply.
SQL is a portable programming language.
SQL works with different relational database management systems.
SQL requires very little coding skills to use.
Which SQL command is used to update data in a database table?
UPDATE command
MODIFY command
EDIT command
Which of the following database management systems uses the SQL language? Select all that apply.
Oracle
MySQL
PostgreSQL
What is the importance of a candidate key in a database?
A candidate key can be used to drop a table.
A candidate key can be used to uniquely identify rows in a table.
A candidate key can be used to encrypt data in a table.
In the following student table, which attribute could be used as a primary key?
| Student first name | Student last name | Mobile number | | --- | --- | --- | | Carl | Merlo | 07445532123 | | Mark | Nero | 07456532327 |
Student last name
Mobile number
Student first name
'CREATE TABLE student;' is the right syntax to create a student table in SQL.
False
True
Choose the right syntax to create a club database in SQL. Select all correct answers.
create club database;
create database club;
CREATE DATABASE CLUB;
CREATE CLUB DATABASE;
