As a database designer at a university, you are tasked with creating a student database. You need to determine which attribute should be used as the primary key. Given below are the four types of attributes related to a student, which of the following should be used as a Primary Key?
Given an Employee table with columns - Employee_id, first_name, last_name, salary, manager_id, job_id, department_id, and hiredate. Find the list of questions below -
1. How to display all records of the table.
2. Find employees with a salary above 80,000.
3. Find employees who haven't been assigned a manager yet:
4. Calculate the average salary across all employees.
5. Calculate the average salary for each job title.
6. Find the total number of employees in each department.
7. Find the employee details of the employee who has 3rd highest salary
8. Find employees who joined the company within the last year.
9. Find the employees who joined the company between 2015 and 2018.
10. Find details of those employees whose names start with letters J and D.
Nishtha Nagar
✨ Happy New Year, everyone! ✨
Thank you for being here and supporting the channel.
Here’s to a year of growth, learning, and building amazing things together. 🚀
What’s one thing you’re most excited to try, learn, or create this year? Share it in the comments 👇.
Let’s make 2026 full of learning, growth, and discoveries! 🚀
4 months ago | [YT] | 21
View 3 replies
Nishtha Nagar
Which of the following is not a database management system?
10 months ago | [YT] | 4
View 0 replies
Nishtha Nagar
As a database designer at a university, you are tasked with creating a student database. You need to determine which attribute should be used as the primary key. Given below are the four types of attributes related to a student, which of the following should be used as a Primary Key?
10 months ago | [YT] | 5
View 0 replies
Nishtha Nagar
Top 10 Basic SQL Interview Questions and Answers
Given an Employee table with columns - Employee_id, first_name, last_name, salary, manager_id, job_id, department_id, and hiredate. Find the list of questions below -
1. How to display all records of the table.
2. Find employees with a salary above 80,000.
3. Find employees who haven't been assigned a manager yet:
4. Calculate the average salary across all employees.
5. Calculate the average salary for each job title.
6. Find the total number of employees in each department.
7. Find the employee details of the employee who has 3rd highest salary
8. Find employees who joined the company within the last year.
9. Find the employees who joined the company between 2015 and 2018.
10. Find details of those employees whose names start with letters J and D.
1 year ago (edited) | [YT] | 6
View 2 replies