A virtual table created from a SELECT query, A database view is best described as, SQL command is used to create a view, CREATE VIEW, Which of the following is an advantage of using views, It simplifies complex queries and can hide sensitive data., Which component improves data search and query speed, Index, What type of index is automatically created when using PRIMARY KEY, Unique index, Which SQL command is used to make an index, CREATE INDEX, Which of the following is NOT a transaction property (ACID), Accuracy, A transaction that completes fully or not at all follows which principle, Atomicity, SQL command is used to confirm all changes in a transaction, COMMIT, command is used to cancel a transaction, ROLLBACK, backup strategy stores everything every time, Full backup, the primary purpose of database backup, To protect data and allow recovery if data is lost or damaged., backup method is fastest for daily updates, Incremental backup, disaster recovery mainly for, Restoring systems and data after major failures or disasters., NoSQL stand for, Not Only SQL, NoSQL database type stores data using keys and values, Key-Value database, type stores flexible JSON-like data, Document database, database structure uses nodes edges relationships, Graph database, MongoDB is an example of, Document-based NoSQL database, Neo4j is a, Graph database, Visual or virtual table based on a SELECT query, View, Logical structure that improves data-retrieval performance, Index, A database operation that fully succeeds or fully cancels, Transaction, SQL command used to undo a transaction, ROLLBACK, Saving a full copy of data for safety purposes, Backup, Backup that only stores changes since the last full backup, Differential backup, NoSQL format that stores JSON-like documents, Document-based NoSQL, NoSQL model used to map relationships using nodes and edges, Graph model, The property of transactions that ensures data remains saved permanently, Durability, The process of connecting multiple modules and making them work together, Integration, List four (4) types or examples of NoSQL databases, Key-Value Database (Redis), Document Database (MongoDB), Graph Database (Neo4j), Column-based Database (Cassandra), four (4) purposes of database backup, Protect data from loss, Recover data after failure, Disaster recovery, Maintain data availability, four (4) ACID properties of database transactions, Atomicity, Consistency, Isolation, Durability, four (4) advantages or uses of database views, Simplifies complex queries, Improves data security, Hides sensitive columns, Makes queries reusable, four (4) key elements commonly stored in a document-based NoSQL model (like MongoDB), Document ID, Fields (keys), Values, Nested objects or arrays.

Info management

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

)
Continue editing: ?