Want to create interactive content? It’s easy in Genially!

Get started free

QUIZ INTRODUCTION TO DATABASES

DAVID ALEJANDRO VILLA GONZALEZ

Created on March 15, 2023

Measure your knowledge acquired up to this point

Start designing with a free template

Discover more than 1500 professional designs like these:

Transcript

QUIZ

Introduction to databases

empezar

01/11

What's a database?

A database is a tool for collecting and organizing information.

Multiple servers running the RD Session Host

Managaeble information collection

02/11

What's SQL?

A programming language for storing and processing information in a relational database.

Open source languaje for serial file manipulation

High-level programming language interpreted to develop applications

03/11

What is SQL for?

To manipulate massive amount of information

To work with a collection of data and the relationships between them

Help finding errors in a database

04/11

How are the fields defined?

Program capable of storing a large amount of data, related and structured

Objects or structures that contain the data organized in rows and columns

Fields are the components that provide structure to a table.

05/11

There are some database managers that exist

ThunderBird, Microsoft Outlook, Em client

Python, SQL, C++

PostgreSQL,MySQL, MySQL Microsoft Server

06/11

These are some data types supported by SQL

Float,Char,Int

class, void, main

True, False, 123, Maria

07/11

What is the job of a database architect?

Develop, manage, and test backup and recovery plans

Create and design a database that suits a company’s various needs

Ensure the performance and security of a database

08/11

_________ are in charge of making the database perform efficiently. They also ensure that data is only available to authorized users

Database architects

Database administrators

Specialized Users

09/11

The easiest way to represent an entity model

Using the entity relationship model

Using a flowchart

Creating a database whose features do not include an entity-relation model

10/11

Actions you can perform to a database

Index the information

Send it using a file transfer protocol

Create, modify, delete, query

11/11

These are properties of a table

Inside there is a set of tables with different names

Include rows, all rows in a table have the same columns, each field has a data type and a name

Contains a collection of a data type

Congratulations you're a genius :p!

Error!

You'll have to try again