A) Organizing data in a database to reduce redundancy. B) Creating duplicate records. C) Deleting old data. D) Adding extra data to improve accuracy.
A) Aggregate, Consistency, Isolation, Duration. B) Atomicity, Consistency, Isolation, Durability. C) Atomicity, Convergent, Isolation, Dispersion. D) Asset, Consistency, Independence, Durability.
A) Encrypting data. B) Improving the speed of data retrieval operations. C) Adding security to the database. D) Deleting records.
A) Copy, Remove, Use, Delete. B) Create, Refresh, Undo, Dump. C) Calculate, Rank, Update, Delete. D) Create, Read, Update, Delete.
A) A security warning. B) A type of encryption. C) An error message. D) Automated response to a specific event in a database.
A) Changing the primary key. B) Deleting duplicate records. C) Separating data into different tables. D) Combining rows from two or more tables based on a related column.
A) Data Backup and Migration Service. B) Dynamic Business Model Software. C) Digital Banking Management System. D) Database Management System.
A) Establish Table Licensing. B) Extract, Transform, Load data from various sources into a data warehouse. C) Enable Table Linking. D) Encrypt, Transmit, Log data.
A) Rules that define acceptable values or conditions for data in the database. B) A physical database backup. C) A database user's access level. D) A report produced by the database.
A) A report generation tool. B) A file containing all database records. C) A type of database model. D) A data structure that improves the speed of data retrieval operations on a database table.
A) To design the physical database schema. B) To develop database applications. C) To manage and maintain the database system. D) To delete data from the database.
A) A database replication process. B) A database error. C) A request for data or information from a database table. D) A type of database model.
A) To make data unavailable for querying. B) To slow down data retrieval. C) To encrypt all data. D) To create a visual representation of the database structure.
A) An extra security measure. B) A rule that ensures the referential integrity of the data. C) A key that allows duplicate values. D) A key that cannot be changed.
A) Sequential Query Language B) Structured Query Logic C) Series Query Language D) Structured Query Language
A) MySQL B) Oracle Database C) MongoDB D) SQLite
A) Indexing B) Denormalization C) Normalization D) Optimization
A) SELECT B) WHERE C) ORDER BY D) FROM
A) MySQL B) SQL Server C) PostgreSQL D) DB2
A) Left Join B) Cross Join C) Inner Join D) Full Outer Join |