In an ACID-compliant DBMS, a transaction that fails due to a disk crash fails due to:

Durability

Consistency

Atomicity

Isolation

What is a major rule when using UNIONs?

All tables in the databases must have the same number of columns

You can only use two SELECT statements in a UNION

You can only union numeric data

The number of columns for each SELECT statement has to match

MySQL is:

Expensive

Not used in web development

Open source

Proprietary

Indexes should be placed on columns that:

		Are queried frequently
		Are updated often
		Have a lot of unique values
		All of the above
		None of the above

Six questions require you to derive the Astronoshow ERD into a relational model, this is one of them. Use the Astronoshow relation model to select which attributes would be present in the Astronomer relation. If Astronomer doesn't appear in the relational model choose 'None - Astronomer is not a relation in the relational model None - Astronomer is not a relation in the relational model First_Name Temperature O P.ID Last Name Location O Star Name Picture_Date iscovery Date O Coordinates A ID