Database Structures And SQL

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 statement is used to remove a table entirely from the database?

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

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

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

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

Which TWO of the following statements about SQL are true?

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?

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

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

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

Which THREE of the following are standard SQL aggregate functions?

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

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

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

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

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

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

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

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

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

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

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

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

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 NoSQL structure is best suited for scenarios where data relationships are complex and frequently traversed?

Which TWO of the following are common database maintenance tasks?

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

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

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

Which THREE of the following are standard SQL join types?

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

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

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

Which THREE of the following are benefits of database indexing?

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?

Which THREE of the following are common SQL constraints?

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?

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

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