Coding interview preparation

PostgreSQL Interview Questions and Answers What is the purpose of Overlay function of PostgreSQL? What is the purpose of String_Agg function in PostgreSQL? How will you create your aggregate function using PostgreSQL? What is CBRT function in PostgreSQL?how can we simulate the same in SQL Server? What is Cube Root Operator(||/) in PostgreSQL? 🔗Article Link

Top 20 Neo4j Interview Questions & Answers (2022 Update) 1) Explain what is Neo4j? 2) For what Neo4j is widely used for? 3) Mention what is the difference between Neo4j graph database and MySQL? 4) Mention some of the important characteristics of neo4j? 5) Explain the role of building blocks like Nodes, Relationships, Properties and Labels in Neo4j? 🔗Article Link

15 Basic MySQL Interview Questions for Database Administrators 1. How would you check if MySql service is running or not? 2. If the service is running/stop how would you stop/start the service? 3. How will you login to MySQL from Linux Shell? 4. How will you obtain list of all the databases? 5. How will you switch to a database, and start working on that? 🔗Article Link

28 MongoDB NoSQL Database Interview Questions and Answers MongoDB is the best free open source NoSQL document oriented database. If you are preparing for the technical interview on MongoDB NoSQL database, must prepare the following MongoDB NoSQL database interview questions. These MongoDB NoSQL database interview questions cover basic concepts of NoSQL databases, Replication, Sharding, Transactions and Locking, Profiler, Nuances, Journalling features etc. Lets have a look on following MongoDB NoSQL database interview questions: 🔗Article Link

Top 16 Microsoft Access Database Interview Questions & Answers (2022) 1) Explain how you can import data from other sources into Access database? 2) Explain what is the size limitation for an Access database? 3) Between different data’s what are the types of relationship can be formed? 4) Explain how you can build a relationship between the different databases in Access? 5) Name some of the file extension for MS Access? 6) Explain what do you mean by queries? 7) Explain what joins are and how you can open the database in Access? 8) Mention how you can create a simple query in Access 2013? 9) Explain how you can export data in Excel format? 10) Explain how you can create a table using MAOL (Microsoft Access Object Library)? 🔗Article Link

10 Essential WordPress Interview Questions 👉Is WordPress safe from brute force login attempts? If not, how can you prevent such an attack vector? 👉How would you change all the occurrences of “Hello” into “Good Morning” in post/page contents, when viewed before 11AM? 👉Suppose you have a non-WordPress PHP website with a WordPress instance in the “/blog/” folder. How can you show a list of the last 3 posts in your non-WordPress pages? 🔗Article Link

10 Essential Swift Interview Questions Toptal sourced essential questions that the best Swift developers and engineers can answer. Driven from our community, we encourage experts to submit questions and offer feedback. 🔗Article Link

Typescript Interview Questions 1) What is Typescript? 2) What are generics in TypeScript? 3) List some features of Typescript? 4) List some benefits of using Typescript? 5) List the built-in types in Typescript? 6) How to compile a Typescript file? 7) What are Modules in Typescript? 8) What are Mixins in TypeScript? 9) Who developed Typescript and what is the current stable version of Typescript? 10) Tell the minimum requirements for installing Typescript. Also, mention the steps involved in it. 🔗Article Link

Top 50 Shell Scripting Interview Questions & Answers (2022) 1: What is a shell? 2: What are the different types of commonly used shells on a typical Linux system? 3: What is the equivalent of a file shortcut that we have a window on a Linux system? 4: What is the difference between soft and hard links? 5: How will you pass and access arguments to a script in Linux? 6: What is the significance of $#? 🔗Article Link

Top 23 Cassandra Interview Questions and Answers for 2022 In this article, we have created a handpicked list of Apache Cassandra interview questions and answers for freshers and experienced candidates. These Cassandra Database interview questions are likely to be asked during your job interview, and they will help you easily crack the interview. 1) Explain what is Cassandra? 2) What is the use of Cassandra and why to use Cassandra? 3) Explain what is composite type in Cassandra? 4) How Cassandra stores data? 5) Mention what are the main components of Cassandra Data Model? 🔗Article Link