Vyom Labs x OmnePresent Walk-In Round 1 Database Developers[email protected]2021-10-14T13:25:38+00:00 Vyom Labs x OmnePresent Walk-In Round I 1. Please enter the same mail ID which was used during registration. 2. The test will be of 120 minutes. 3. The question set is divided into two sections - Personal Details & Technical Hands-on 4. The test will get auto disabled after 120 minutes, so be sure you submit on-time. *Required Email * Next START YOUR RECORDING NOW Once your recording has started, go to the next section... BackNext Job Description Oracle & SQL Developers: Ready to learn new technologies like Snowflake.com and PowerBI. Job description: - Strong MS SQL Server experience - In-depth knowledge of logical/physical database design. (Good Knowledge of Oracle DB architecture) - Strong experience with Oracle SQL and PL/SQL. - At least 2 to 7 years experience in T-SQL (Queries, Views, Procedures). - Experience in T-SQL Optimization. - Experience in SSRS or SSMS 2016 and above. - Able to write and work with very complex stored procedures. - Experience in when to apply different levels of normalization and demoralization. - Experience with transferring data quickly between platforms by performing efficient delta refreshes. - Solid understanding of N-tier architectures and troubleshooting. BackNext Registration Form Full Name * Phone Number * Graduation Year * Graduation Stream (BCA, BE, BScIT, etc.) * Post Graduation Year (NA for Not Applicable) * Post Graduation Stream (MCA, MScIT, MCS, MTech, etc.) (NA for Not Applicable) * Percentage/CGPA of highest qualification: * Total Years of Experience: * Notice Period: * Immediately Available< 30 Days30 Days to 60 Days>60 Days Current CTC? * Expected CTC? Are you open to learning latest career marking technologies like: Advanced Snowflake, PowerBI, Tableau, and more? * YesNo Do you have an i5 or above configuration laptop / desktop? (i5 or above; 8 GB RAM or above) - We have BYOD - thus, this minimum configuration system is mandatory. * YesNo Do you have broadband internet connectivity? - Due to work from home currently, this is mandatory. * YesNo Are you ready to travel if necessary (after COVID)? * YesNo Are you willing to work in shifts? (This is optional) * YesNo Are you willing to sign a 2.5 years' service agreement with the company? - This is mandatory for onboarding. * YesNo Do you have a passport ? * YesNoBackNext About YourSelf... You need to CONTINUE recording your screen and yourself (with webcam) and voice (Mic) Verbally talking about this point BackNext Technical Questions - Explain your answer in detail. - Ensure your recording is ON. Answer The Questions Verbally While Recording Is On BackNext 1. Scripting / Development Questions - Use Assumptions in case you're not clear - Code Database queries the answer section. - Explain the scripts and code WHILE you are typing. - Continue recording your screen, mic and webcam - they are mandatory HR Schema - --------------------START RECORDING [do NOT stop the recording] 1. Write a query to display job title, minimal salary with 10% increased minimal salary * 2. Write a query to get employee names with hire date greater than January 1st,2017 and salary less than $5,000. * 3. Write a query to find cities with states or provinces * 4. Write a query to count the Employees * 5. Write a query to find average salary for each department * 6. Write a query to display the greatest number in a list of 4, 8 and 2. * 7. Extract YEAR from April 4th, 2017 * 8. Write a query in SQL to display the full name of the employees and the department names. * 9. Create a view named v_employees to display the names and salary fields from the Employees table. * 10. Write a query to display the year portion of the system date. * BackNext [CONTINUE RECORDING, DO NOT STOP] 2. Scripting / Development Questions - Use Assumptions in case you're not clear - Code Database queries the answer section. - Explain the scripts and code WHILE you are typing. - Continue recording your screen, mic and webcam - they are mandatory Create an empty table from an existing above table? * Write HOW to Fetch common records from two tables? * Fetch alternate records from a table? (Odd and Even) * Select unique records from a table? * Command used to fetch first 10 characters of the string? * Share example of UNIQUE CONSTRAINT * CONTINUE RECORDING - DO NOT STOP MOVE TO THE NEXT SECTION - DO NOT SUBMIT UNLESS INSTRUCTED BackNext STOP RECORDING Share the video recording url here. Paste the video recording URL as per the instructions below: * BackNext Thank you! Thank you for attending our walk-in. I hope you loved the innovative way it was conducted. Our team will go through the results and contact the shortlisted candidates for final HR round. We wish you all the best! You can have a look at our company website for more details about us: https://omnepresent.com/ Back
