Namo's Database Quiz

Which of these are database types? (choose more than one)

• Flat File

• NoSQL

• JSON

• Relational

Which are SQL commands? (choose more than one)

• DELETE

• SELECT

• RUN

• INSERT

Which systems are RDBMS? (choose more than one)

• MangoDB

• Oracle

• MySQL

• PostgreSQL

What is a primary key in a database?

• Unique identifier

• Index

• Field

• Foreign key

Which SQL clause is used to filter records?

• ORDER BY

• WHERE

• GROUP BY

• HAVING

What does SQL stand for?

• Simple Query Language

• Structured Query Language

• Sequential Query Language

• System Query Language

Which command adds a new record to a table?

• DELETE

• SELECT

• INSERT

• UPDATE

What does a JOIN operation do?

• Combines rows from two tables

• Creates a new table

• Updates rows

• Deletes rows

Which type of database is MongoDB?

• Graph

• Object-oriented

• NoSQL

• Relational

What is normalization in databases?

• Securing data

• Backing up data

• Creating indexes

• Organizing data to reduce redundancy