Adaface Sample Sybase Questions

In a Sybase ASE database, there's a table named ‘employees’ with the following columns:
            
            - emp_id (int)
            - emp_name (varchar)
            - date_joined (datetime)
            
            You are tasked with fetching the names of employees who joined the company in January 2022. Which of the following pseudocode SQL statements would correctly give you the desired result?

In Sybase ASE, you're tasked with optimizing some database operations. You come across two types of temporary tables being used: local temporary tables (dynamic) which have names prefixed with a single '#' and global temporary tables (static) which have names prefixed with '##'. Now, consider the following scenarios:
            
            1. You need a table that should be available to all connections and users until the database is restarted.
            2. A table that is required to exist only for the duration of a single stored procedure.
            3. A table that should store a large amount of data that would benefit from creating indexes.
            
            Which of the following options correctly pairs the type of temporary table (dynamic or static) with the given scenarios?

You are working with a Sybase ASE database that has two tables: orders and products.
            
            The orders table has columns:
            
            - order_id (int)
            - product_id (int)
            - quantity (int)
            
            The products table has columns:
            
            - product_id (int)
            - product_name (varchar)
            - price (float)
            
            You're tasked with writing a query that lists product names that have been ordered more than 5 times in total, along with their average price and total quantity ordered. Which of the following pseudocode SQL statements would achieve this?

Imagine you're the database administrator for a large online retail platform using Sybase ASE. During Black Friday sales, the platform experiences a significant increase in traffic, leading to concurrent database transactions.
            
            Scenario 1: The finance team runs a transaction to tally total sales every hour. They need an absolute accurate count and cannot afford any discrepancy due to ongoing transactions.
            
            Scenario 2: The product recommendation engine constantly fetches product data to make real-time recommendations to users. The engine favors speed over absolute data accuracy, as a slight delay in fetching data can lead to a sluggish user experience.
            
            Which of the following transaction isolation levels would be the most suitable for the scenarios described?