Database Structures And SQL

A database administrator needs to store unstructured data that scales horizontally across multiple servers while maintaining high availability. Which database structure should be selected?

A user wants to add a new column to an existing table named 'Employees'. Which SQL statement should be executed?

To improve read performance on a table frequently queried by a specific column, which database object should be created?

A database administrator is investigating performance degradation during heavy concurrent write operations. Which isolation level provides the highest level of data consistency but the lowest concurrency?

A developer needs to ensure that a 'Customer_ID' field in a 'Orders' table always references a valid ID in the 'Customers' table. Which constraint should be applied?

Which SQL command is used to permanently remove all rows from a table while keeping the table definition intact?

Which type of join should be used to return all records from the 'Left' table and only matching records from the 'Right' table?

An analyst is writing an SQL query to retrieve total sales per region, but the result must only show regions with more than 100 transactions. Which clause is required?

Which SQL keyword is used to eliminate duplicate values from a query result set?

Which DML statement is used to update existing records in a database table?

A database developer needs to combine the results of two different SELECT queries into a single result set. Which operator should be used?

An application requires an automatic timestamp for every row inserted into an 'Audit' table. Which feature should the developer implement?

When migrating data between two different relational databases, which DDL-related issue is most likely to cause failure if ignored?

To prevent unauthorized access to specific columns in a 'Salary' table, which object should be created for the reporting team?

A business user needs to calculate the average age of customers, but some age fields are NULL. Which function should be used to treat NULL as 0?

A transaction involves multiple updates that must either all succeed or all fail. Which command ensures this behavior?

Which command is used to restrict a user's access to a specific table?

Which NoSQL structure is best suited for scenarios where data relationships are complex and frequently traversed?

Which operator is used to search for a pattern in a string column?

An application is experiencing deadlocks. Which strategy would effectively reduce the frequency of deadlocks?

Which scenario best justifies the use of a relational database over a NoSQL database?

A developer needs to calculate the running total of sales. Which SQL feature is most appropriate?

What is the primary purpose of a 'Normalization' process in database design?

A query is slow due to excessive scanning of a large table. The execution plan shows a 'Table Scan'. What is the most likely missing element?

Which SQL statement is used to remove a table entirely from the database?

Which SQL clause is used to sort the result of a query by one or more columns?

Which THREE of the following are considered ACID properties in database transactions?

Which TWO of the following are common types of NoSQL databases?

A database administrator wants to check the current connection count. Which system catalog or dynamic management view would typically provide this information?

To implement a secure 'Multi-Tenant' architecture, which design approach is most effective for data separation?

Which THREE of the following are standard SQL aggregate functions?

Which TWO of the following are DDL (Data Definition Language) commands?

Which THREE of the following are benefits of database indexing?

Which TWO of the following are potential issues when denormalizing a database?

Which THREE of the following are common SQL constraints?

Which TWO of the following scenarios are best suited for using a 'View'?

Which THREE of the following are standard SQL join types?

Which TWO of the following statements about SQL are true?

Which TWO of the following are common database maintenance tasks?

Which THREE of the following are components of a database connection string?