A) A key that allows access to all records in a table. B) A key that is not indexed. C) A unique identifier for each record in a table. D) A key used for encryption of data.
A) Structured Query Logic for manipulating files. B) Structured Query Language used to manage and query relational databases. C) Syntax Query Language for text documents. D) Simple Query Language for non-relational databases.
A) All Columns Indexed Directly. B) Atomicity, Consistency, Isolation, Durability. C) Automated Computation and Integration Delivery. D) Access Control In Database.
A) MongoDB B) MySQL C) Redis D) Elasticsearch
A) A table with no records. B) An index created on a column for faster retrieval. C) A data type used for storing images. D) A virtual table that presents data from one or more tables based on a query.
A) FILTER B) SELECT C) GROUP D) SORT
A) A table containing data records. B) A set of rules for defining relationships. C) A collection of metadata that describes the data and structure of the database. D) A database index for quick data retrieval.
A) SELECT B) FILTER C) GROUP BY D) WHERE
A) A key that consists of multiple columns to uniquely identify a record. B) A key that is not indexed. C) A primary key for composite data types. D) A key that is stored in multiple tables.
A) A software tool for database management. B) A logical design that represents the structure of the database. C) The physical storage location of the database files. D) A type of encryption algorithm.
A) MERGE B) INSERT C) ADD D) UPDATE
A) CHANGE B) UPDATE C) MODIFY D) ALTER
A) To combine multiple tables into one. B) To improve the speed of data retrieval operations. C) To encrypt sensitive data in the database. D) To define relationships between tables.
A) A method for filtering data. B) A process of creating new records in a table. C) A method to combine rows from two or more tables based on a related column. D) An operation to pivot table data.
A) MAX B) MAXIMUM C) TOP D) FIRST
A) A query that selects a random subset of data. B) A query that returns all records in a table. C) A query nested within another query. D) A query that retrieves data from multiple tables.
A) LEFT JOIN B) RIGHT JOIN C) OUTER JOIN D) INNER JOIN
A) SELECT. B) INSERT INTO. C) UPDATE. D) DELETE.
A) UPDATE B) INSERT C) DROP D) ALTER |