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