Perform sql queries given a database
Data Intern Interview Questions
7,489 data intern interview questions shared by candidates
Can u give me a small presentation of yourself ? Why did u apply for amazon? Wht wud the minimum components to boot a PC ? Booting a system without any local storage : Network Boot. Example PXE Diff between SSD and HDD; Advantages and Disadvantages. What types of connections do the Hard drives hve to mother board wht is RAID disk Monitoring / Health boards for Disk/Servers ? Ans : SMARTS Types of RAM ECC in RAM Wht is Bios. Changing mother board changes BIOS ? Wht is mac address nd why is it needed. Wht protocol is needed to translate btwn mac and IP address : ARP What is NAT ? What is SFP transceiver ? Single mode fiber used for long distance communication bcos ???? Switching and Routing, OSI Model Physical address of a network equipment How to check the IP address ? Types of Fiber - Single mode and Multi Mode Describe ethernet cable Linux distribution used; Basic commands of Linux like the current directory, 'ls' command, Create a new folder Wht is Linux kernel Wht kinda systems u use to prevent data threats. Ans : RAID Connectors that connect hard drive to motherBoard : SATA, nvem Behavioral When u dont know how to solve a challenging problem and wht to do next. How did you solve ? U made a decision without consulting ur manager, What and why ? Coolest thing tht u hve learnt on ur own nd tht mde u perform well in ur job The hardest decision that you took for a long term goal by sacrificing a shrt term goal
Behavioral and technical questions related to sql and basic python
ML related theory questions and behavioral questions.
Obtain the first occurrence of grouping by certain condition
1. System Design question 2. Ask few questions on SQL and Python 3. Code 4. Behavioral questions
I was asked to design a database for a usecase. I was asked basic questions like joins and indexing. It was somewhat resume based too, so your previous experience matters.
Schreiben Sie eine Query, die nach Thema "X" sucht, wobei das Thema mindestens 5 mal erwähnt wurde
What is a data warehouse
Situational Interview question: In your experience, what did you do when someone on your team didn't take on their responsibilities.
Viewing 1631 - 1640 interview questions