The equals (=) comparison operator can’t be used with a subquery that returns mo

Question

The equals (=) comparison operator can’t be used with a subquery that returns more than one row of results.

True

False

Which of the following statements are false?

Consistency means that a read operation on the database sees all previously completed write operations and availability means that read and write operations always succeed.

Partition tolerance means that the guaranteed properties are maintained even when network failures prevent some machines from communicating with others.

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.

You have to issue a new GRANT statement for each priviledge like INSERT, DELETE, and so on.

True

False

Durability refers to which attribute?

Overhead

Speed

Recovery

Strength

Consistency means that a read operation on the database sees all previously completed write operations and availability means that read and write operations always succeed.

Partition tolerance means that the guaranteed properties are maintained even when network failures prevent some machines from communicating with others.

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.

You have to issue a new GRANT statement for each priviledge like INSERT, DELETE, and so on.

True

False

Durability refers to which attribute?

Overhead

Speed

Recovery

Strength

Six questions require you to derive the Astronoshow ERD into a relational model, this is one of them model choose 'None-Star is not a relation in the relational mode Star_Name Temperature Coordinates A ID Discovery-Date Location Picture_Date None - Star is not a relation in the relational model Last_Name P-ID First_Name

Explanation / Answer

1.The equals (=) comparison operator can’t be used with a subquery that returns more than one row of results.

Answer: TRUE

explanation:When a subquery returns more than one row, it is not possible to use only use comparison operator, since a single value can't compare with multiple values using '='

2.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.

this option is FLASE

Explanation: availability means that read and write operations always succeed. and tolerant mechanism provide consistenct on each divided nodes

3.You have to issue a new GRANT statement for each priviledge like INSERT, DELETE, and so on.

TRUE

Explanation : A privilege is a right to execute a particular type of SQL statement , you can grant the privileges to select, insert, update, and delete records

4.Recovery

Explanation: Durability refers to the ability of the system to recover committed transaction updates if either the system or the storage media fails

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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