Test: Database System Architectures - 2 - Software Development MCQ

Which of the following is true about distributed database systems?

Which of the following is a disadvantage of distributed database systems?

Consider the following SQL query:

SELECT COUNT(*) FROM employees WHERE salary > 50000;
What will be the output of the above query?

Consider the following Python code snippet:

my_list = [1, 2, 3, 4, 5]
new_list = [x * 2 for x in my_list if x % 2 == 0]
print(new_list)
What will be the output of the above code?

Consider the following SQL query:

SELECT AVG(salary) FROM employees WHERE department = 'Sales';
What will be the output of the above query?

Consider the following Python code snippet:

def factorial(n):
    if n == 0:
        return 1
    else:
        return n * factorial(n - 1)

result = factorial(5)
print(result)
What will be the output of the above code?

Consider the following SQL query:

SELECT MAX(salary) FROM employees;
What will be the output of the above query?

Consider the following SQL query:

SELECT e.employee_name, d.department_name
FROM employees e
JOIN departments d ON e.department_id = d.department_id
WHERE e.salary > (SELECT AVG(salary) FROM employees)
ORDER BY e.employee_name;
What does the above query return?

Consider the following Python code snippet:

def fibonacci(n):
    if n <= 1:
        return n
    else:
        return fibonacci(n - 1) + fibonacci(n - 2)

result = fibonacci(6)
print(result)

What will be the output of the above code?

Consider the following SQL query:

SELECT DISTINCT department_id FROM employees;
What does the above query return?

Consider the following Python code snippet:

my_dict = {'a': 1, 'b': 2, 'c': 3}
result = sum(my_dict.values())
print(result)
What will be the output of the above code?

Consider the following SQL query:

SELECT COUNT(DISTINCT department_id) FROM employees;
What does the above query return?