Assume you are the senior database engineer working at the QUT Bank. You have observed that your RDBMS system (say, Oracle) is under stress because of the increasing volume of deposit/withdraw operations performed by the customers of the bank. You are considering replacing your RDBMS with a document-based NoSQL database. Which of the following decisions/motivations is the most sensible given the use case?

I would replace the existing RDBMS with a NoSQL solution because this represents a cutting edge solution to scale operations for incresing large big data volumes.

I would not consider adopting a NoSQL solution because NoSQL software is still immature and unstable.

I would not consider adopting a NoSQL solution because this would require a complete restructuring of the bank information system.

I would not consider adopting a NoSQL solution because, while NoSQL ensures Availability and Partition tolerance, it does not ensure Consistency.

I would consider adopting a NoSQL solution because, while NoSQL ensures Consistency and Partition tolerance, it does not ensure Availability. However, we can ensure availability by replicating NoSQL databases in multiple servers.

Which of the following are not DDL statements?

		CREATE
		UPDATE
		DROP
		SELECT
		ALTER
		INSERT

Transactions that are atomic are said to be:

		All or nothing
		Consistent
		Very small
		Compliant

Match the definitions with the correct acronym. This database sub-language is used to create the database schema. Statements include creating, modifying, and removing database objects such as tables, indexes and users. a. DCL b. DML C. TCL d. DDL This database sublanguage is used to both read and update the database. Statements include selecting, inserting, deleting and updating This database sublanguage includes COMMIT and ROLLBACK statements This database sublanguage controls permissions and access