DBMS #1

what is the string type in postgreSQL? Choose 2 statements

• int

• text

• numeric

• date

• varchar

Types of DBMS:

• adventure, role-playing, simulation, strategy

• batch, distributed, multitasking, network

• multipartite, overwrite, direct

• hierarchical, network, relational, object-oriented

• personal, network, local, wireless, metropolitan

select name from products where price BETWEEN 160 AND 290 and producer_id is not null; What will you get according to that query?

• milk 2.5%, tvorog

• milk 2.5%, milk 2.5%

• tvorog

• tvorog, 4ebureki

• pirojki, 4ebureki

Popular relational database management systems:

• Ruby, Golang, PHP

• MySQL, OracleDB, PostgreSQL

• NodeJS, TypeScript

• Python, Kotlin, Java

• Go, Clojure, Scala

The most common type of relationship, where a record in one entity can be referenced by multiple records in another entity:

• One-to-some

• One-to-many

• Many-to-many

• One-to-one

• Many-to-one

Data manipulation language (DML) includes statements that modify the _____ of a database.

• structure

• size

• data

• computer

• users

_____ is a DML statement used to query records from a database.

• update

• delete

• insert

• query

• select

To remove data from a database, use the _____ DML command.

• remove

• update

• truncate

• delete

• drop

If you were wanting to filter data, which clause would you use?

• group by

• where

• select

• from

• order by

Less than or equal to?

• <=

• =<

• >

• <

• >=