Database Introduction

What is File-based database?

• A database is a comprehensive collection of related data organized for convenient access

• Collection of application programs that perform services for the end users (e.g. reports)

• Shared collection of logically related data

• Designed to meet the information needs of an organization and accessible through a network

Which is not a type of Database?

• Oracle

• Microsoft Access

• MySQL

• Microsoft Outlook

Which is the type of Database Engine used in our class

• MongoDB

• MySQL

• MariaDB

• PostgreSQL

What MYSQL Cannot Do?

• SQL Can Create Beautiful Application

• SQL can insert records in a database

• SQL can update records in a database

• SQL can delete record from a database

What is the syntax to create a connection to database?

• mysqli_create

• mysqli_start

• mysqli_connect

• mysqli_open

What is "pbu" stand for?

• Connection table

• Database name

• Connection name

• Database table

What is the syntax for selecting data from tables?

• mysqli_fetch_assoc

• mysqli_fetch_array

• mysqli_connect($link,"SELECT * FROM mydb");

• mysqli_query($link,"SELECT * FROM mydb");

the following are characteristics of MYSQL database EXCEPT

• MYSQL can be used by multiple people at one time

• MYSQL has licensing fees

• handle large databases with many transactions

• MySQL is compatible with most operating system