Which of the following statements are false? 1. o Partition tolerance means that

Question

Which of the following statements are false? 1. o Partition tolerance means that the guaranteed properties are maintained even when network O Consistency means that a read operation on the database sees all previously completed write failures prevent some machines from communicating with others oper rations and availability means that read and write oper ations always succee d. O Availability means that the system is easily available on the market and partition tolerance means that the system can be distributed across multiple servers without redundancy mechanisms. 2. It is possible to insert multiple rows of data in MySQL at once, in a single SQL statement. False You hayeto issue a new GRANT statement for each privilege like INSERT, DELETE, and so on. False 3. What is a major rule when using UNIONs? All tables in the databases must have the same number of columns o Ihenumber of columns for each SELECT statement has to match o You can only use two SELECT statements in a UNION o You can only union numeric data Indexes should be placed on columns that Are queried frequently Are updated often 4. Have a lot of unique values Allof the above None of the above In order to transform a relation from first normal form to second normal form we must remove which of the following? 5. O All partial-key dependencies All inverse partial-key dependencies All repeating groups All transitive dependencies None of the above options are correct o

Explanation / Answer

1.option b

2.true

we can insert multlple rows in mysql at once

you have to issue a new grant statement for each privilege like insert delete

ans true

3.all tables in the database must have the same number of columns

The number of columns for each select statement has to match

4.none of the above

5.all repeating groups

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.