SQL Basics MCQs with Answers

In which area of database management does the privilege 'CREATE TABLESPACE' apply?

• A.User Authentication
• B.Data Manipulation
• C.Schema Definition
• D.Server Administration

Past Paper MCQ

An function is a dynamic mathematical calculation that displays a single value for a specific field in a dataset.

• A.Aggregate
• B.Logical
• C.String
• D.Date

After creating a table in a database, which of the following actions can still be performed?

• A.Only data can be modified, but the structure remains fixed
• B.The table name cannot be changed under any circumstances
• C.Fields can be added and deleted as needed
• D.The primary key cannot be altered once the table is created

Which fixed database role allows for adding or removing user IDs in a database?

• A.db_ddladmin
• B.db_securityadmin
• C.db_accessadmin
• D.db_owner

Why is the following SQL query incorrect? SELECT dept_name, ID, avg(salary) FROM instructor GROUP BY dept_name;

• A.The FROM clause is missing a JOIN condition
• B.The GROUP BY clause cannot be used with aggregate functions
• C.The AVG function cannot be used on the salary column
• D.The SELECT clause contains non-aggregated columns not in GROUP BY clause

Which type of SQL join includes all rows from the left table and matches them with rows from the right table, filling in NULLs for non-matching entries from the right table?

• A.INNER JOIN
• B.LEFT JOIN
• C.RIGHT JOIN
• D.FULL OUTER JOIN

What is the purpose of the Cascade Delete option in a database management system?

• A.To automatically update foreign key values when a parent record is modified
• B.To ensure all related records are deleted when a parent record is deleted
• C.To prevent deletion of a parent record if any child records exist
• D.To create a backup of related records before deleting the parent record

Which SQL query retrieves all records where the job title is 'Clerk' from the EMP table?

• A.SELECT * FROM EMP WHERE Job EQUALS 'Clerk';
• B.SELECT ALL FROM EMP WHERE Job = 'Clerk';
• C.SELECT * FROM EMP WHERE Job == 'Clerk';
• D.SELECT * FROM EMP WHERE Job = 'Clerk';

When setting up a new table in a database, which method allows you to select fields from standard databases and tables?

• A.Create Table by entering data
• B.Create Table in design view
• C.Create Table using wizard
• D.Create Table using SQL query

Which logging option should be enabled to create a binary log index file in a database system?

• A.--binary-log-index
• B.--binlog-index
• C.--log-index-bin
• D.--log-bin-index