Relational Database Quiz

Relational model -

• this is a set of tables called relationships

• This type of computer database supports storing all data types. Data is stored as objects

• This type of database computer stores application procedures that help users access data even from a remote location.

• Everything is correct

• It is mainly used in the field of marketing, employee relations, customer service, and databases.

Who proposed the relational model ?

• none

• Charles Bachman

• Peter Chen

• Steve Jobs

• Edgar Codd

What is SQL?

• standard language for working with relational databases

• This type of database computer stores application procedures that help users access data even from a remote location.

• Graph-oriented databases use graph theory to store, display, and query relationships

• OLTP is another type of database that can quickly process requests and maintain data integrity in multiple available environments

• This type of DBMS uses parent-generation relationships to store data

In SQL, XML functions, etc. in what year did window functions appear ?

• 2002

• 2003

• 2004

• 1999

• 2000

News of 1989?

• The first version in SQL history was released

• Microsoft releases MS access, a custom DBMS that replaces all other custom DBMS products

• Charles Bachman created the first DBMS system

• object-oriented DBMS are being developed.

• the first internet applications for databases.

News of 1978?

• IBM has released a product called System/R

• a Structured Query Language appeared.

• IBM developed a prototype of a relational database standardized by ANSI.

• The first version in SQL history was released

• none

the year in which Dr. Edgar F. Ted Codd described the relational database model ?

• 1971

• 1980

• 1970

• 1976

• 1990

How many types of SQL queries exist?

• 6

• 4

• 3

• 5

• 7

CREATE -

• defines the database structure schema

• inserts data into the row of a table

• updates data in a database

• removes one or more rows from a table

• selects the attribute based on the condition described by the WHERE clause

INSERT-

• inserts data into the row of a table

• updates data in a database

• removes one or more rows from a table

• selects the attribute based on the condition described by the WHERE clause

• removes tables and databases