#sql questions

[tpointtechblog]

Top 30 SQL Interview Questions and Answers for Fresher and Experienced

Sure! Here are the top 30 SQL interview questions and answers for both fresher and experienced candidates:

What is SQL? SQL stands for Structured Query Language, and it is a programming language designed for managing and manipulating relational databases. What are the different types of SQL statements? There are four main types of SQL statements: Data Manipulation Language (DML) statements…

[demo-ness]

my old advisor was """restructured""" a while ago and my new one can be SO frustrating. they spent several emails working on the assumption that i had veteran benefits, for some reason, and in our most recent interaction they just full on ignored my question about whether a class i wanted to take would be viable or not. WHAT DO YOU THINK WE'RE HERE TO DO, MAN

[moderator-monnie]

What if there was an entity with the ability to load the game in (basically it's seen from the game's pov as a player however it's not really one) (and let's also say it constantly loads all parts of the game in (which from an optimization pov would be terrible))? Would that be able to screw with the slammer virus?

if such a entity exists, yes it would cause problems for slammer depending on how powerful the virus is at that point

a fresh copy of the virus would likely be destroyed rather quickly, however the more games/code a copy has consumed the safer/the more the virus can handle the other entity.

Slammer Prime would have no issue at all, anything else? it really depends.

[juliebowie]

Your Guide To SQL Interview Questions for Data Analyst

Introduction

A Data Analyst collects, processes, and analyses data to help companies make informed decisions. SQL is crucial because it allows analysts to efficiently retrieve and manipulate data from databases. 

This article will help you prepare for SQL interview questions for Data Analyst positions. You'll find common questions, detailed answers, and practical tips to excel in your interview. 

Whether you're a beginner or looking to improve your skills, this guide will provide valuable insights and boost your confidence in tackling SQL interview questions for Data Analyst roles.

Importance Of SQL Skills In Data Analysis Roles

Understanding SQL is crucial for Data Analysts because it enables them to retrieve, manipulate, and manage large datasets efficiently. SQL skills are essential for accurate Data Analysis, generating insights, and making informed decisions. Let's explore why SQL is so important in Data Analysis roles.

Role Of SQL In Data Retrieval, Manipulation, and Management

SQL, or Structured Query Language, is the backbone of database management. It allows Data Analysts to pull data from databases (retrieval), change this data (manipulation), and organise it effectively (management). 

Using SQL, analysts can quickly find specific data points, update records, or even delete unnecessary information. This capability is essential for maintaining clean and accurate datasets.

Common Tasks That Data Analysts Perform Using SQL

Data Analysts use SQL to perform various tasks. They often write queries to extract specific data from databases, which helps them answer business questions and generate reports. 

Analysts use SQL to clean and prepare data by removing duplicates and correcting errors. They also use it to join data from multiple tables, enabling a comprehensive analysis. These tasks are fundamental in ensuring data accuracy and relevance.

Examples Of How SQL Skills Can Solve Real-World Data Problems

SQL skills help solve many real-world problems. For instance, a retail company might use SQL to analyse sales data and identify the best-selling products. A marketing analyst could use SQL to segment customers based on purchase history, enabling targeted marketing campaigns. 

SQL can also help detect patterns and trends, such as identifying peak shopping times or understanding customer preferences, which are critical for strategic decision-making.

Why Employers Value SQL Proficiency in Data Analysts

Employers highly value SQL skills because they ensure Data Analysts can work independently with large datasets. Proficiency in SQL means an analyst can extract meaningful insights without relying on other technical teams. This capability speeds up decision-making and problem-solving processes, making the business more agile and responsive.

Additionally, SQL skills often indicate logical, solid thinking and attention to detail, which are highly desirable qualities in any data-focused role.

Basic SQL Interview Questions

Employers often ask basic questions in SQL interviews for Data Analyst positions to gauge your understanding of fundamental SQL concepts. These questions test your ability to write and understand simple SQL queries, essential for any Data Analyst role. Here are some common basic SQL interview questions, along with their answers:

How Do You Retrieve Data From A Single Table?

Answer: Use the `SELECT` statement to retrieve data from a table. For example, `SELECT * FROM employees;` retrieves all columns from the "employees" table.

What Is A Primary Key?

Answer: A primary key is a unique identifier for each record in a table. It ensures that no two rows have the same key value. For example, in an "employees" table, the employee ID can be the primary key.

How Do You Filter Records In SQL?

Answer: Use the `WHERE` clause to filter records. For example, `SELECT * FROM employees WHERE department = 'Sales';` retrieves all employees in the Sales department.

What Is The Difference Between `WHERE` And `HAVING` Clauses?

Answer: The `WHERE` clause filters rows before grouping, while the `HAVING` clause filters groups after the `GROUP BY` operation. For example, `SELECT department, COUNT(*) FROM employees GROUP BY department HAVING COUNT(*) > 10;` filters departments with more than ten employees.

How Do You Sort Data in SQL?

Answer: Use the `ORDER BY` clause to sort data. For example, `SELECT * FROM employees ORDER BY salary DESC;` sorts employees by salary in descending order.

How Do You Insert Data Into A Table?

Answer: Use the `INSERT INTO` statement. For example, `INSERT INTO employees (name, department, salary) VALUES ('John Doe', 'Marketing', 60000);` adds a new employee to the "employees" table.

How Do You Update Data In A Table?

Answer: Use the `UPDATE` statement. For example, `UPDATE employees SET salary = 65000 WHERE name = 'John Doe';` updates John Doe's salary.

How Do You Delete Data From A Table?

Answer: Use the `DELETE` statement. For example, `DELETE FROM employees WHERE name = 'John Doe';` removes John Doe's record from the "employees" table.

What Is A Foreign Key?

Answer: A foreign key is a field in one table that uniquely identifies a row in another table. It establishes a link between the two tables. For example, a "department_id" in the "employees" table that references the "departments" table.

How Do You Use The `LIKE` Operator?

Answer: SQL's `LIKE` operator is used for pattern matching. For example, `SELECT * FROM employees WHERE name LIKE 'J%';` retrieves all employees whose names start with 'J'.

Must Read: 

How to drop a database in SQL server?

Advanced SQL Interview Questions

In this section, we delve into more complex aspects of SQL that you might encounter during a Data Analyst interview. Advanced SQL questions test your deep understanding of database systems and ability to handle intricate data queries. Here are ten advanced SQL questions and their answers to help you prepare effectively.

What Is The Difference Between INNER JOIN And OUTER JOIN?

Answer: An INNER JOIN returns rows when there is a match in both tables. An OUTER JOIN returns all rows from one table and the matched rows from the other. If there is no match, the result is NULL on the side where there is no match.

How Do You Use A Window Function In SQL?

Answer: A window function calculates across a set of table rows related to the current row. For example, to calculate the running total of salaries:

 Explain The Use Of CTE (Common Table Expressions) In SQL.

Answer: A CTE allows you to define a temporary result set that you can reference within a SELECT, INSERT, UPDATE, or DELETE statement. It is defined using the WITH clause:

 What Are Indexes, And How Do They Improve Query Performance?

Answer: Indexes are database objects that improve the speed of data retrieval operations on a table. They work like the index in a book, allowing the database engine to find data quickly without scanning the entire table.

How Do You Find The Second-highest Salary In A Table?

Answer: You can use a subquery for this:

What Is A Subquery, And When Would You Use One?

Answer: A subquery is a query nested inside another query. You use it when you need to filter results based on the result of another query:

Explain The Use Of GROUP BY And HAVING Clauses.

Answer: GROUP BY groups rows sharing a property so that aggregate functions can be applied to each group. HAVING filters groups based on aggregate properties:

How Do You Optimise A Slow Query?

Answer: To optimise a slow query, you can:

Use indexes to speed up data retrieval.

Avoid SELECT * by specifying only necessary columns.

Break down complex queries into simpler parts.

Analyse query execution plans to identify bottlenecks.

Describe A Scenario Where You Would Use A LEFT JOIN.

Answer: Use a LEFT JOIN when you need all records from the left table and the matched records from the right table. For example, to find all customers and their orders, even if some customers have no orders:

What Is A Stored Procedure, And How Do You Create One?

Answer: A stored procedure is a prepared SQL code you can reuse. It encapsulates SQL queries and logic in a single function:

These advanced SQL questions and answers will help you demonstrate your proficiency and problem-solving skills during your Data Analyst interview.

Practical Problem-Solving Scenarios SQL Questions

In SQL interviews for Data Analyst roles, you’ll often face questions that test your ability to solve real-world problems using SQL. These questions go beyond basic commands and require you to think critically and apply your knowledge to complex scenarios. Here are ten practical SQL questions with answers to help you prepare.

How Would You Find Duplicate Records In A Table Named `Employees` Based On The `Email` Column?

Answer:

Write A Query To Find The Second Highest Salary In A Table Named `Salaries`.

Answer:

How Do You Handle NULL Values In SQL When Calculating The Total Salary In The `Employees` Table?

Answer:

Create A Query To Join The `Employees` Table And `Departments` Table On The `Department_id` And Calculate The Total Salary Per Department.

Answer:

How Do You Find Employees Who Do Not Belong To Any Department?

Answer:

Write A Query To Retrieve The Top 3 Highest-paid Employees From The `Employees` Table.

Answer:

How Do You Find Employees Who Joined In The Last Year?

Answer:

Calculate The Average Salary Of Employees In The `Employees` Table, Excluding Those With A Wage Below 3000.

Answer:

Update The Salary By 10% For Employees In The `Employees` Table Who Work In The 'Sales' Department.

Answer:

Delete Records Of Employees Who Have Not Been Active For The Past 5 years.

Answer:

These questions cover a range of scenarios you might encounter in an SQL interview. Practice these to enhance your problem-solving skills and better prepare for your interview.

Tips for Excelling in SQL Interviews

Understanding how to excel in SQL interviews is crucial for aspiring data professionals, as it showcases technical expertise and problem-solving skills and enhances job prospects in a competitive industry. Excelling in SQL interviews requires preparation and practice. Here are some tips to help you stand out and perform your best.

Best Practices for Preparing for SQL Interviews

Preparation is critical to success in SQL interviews. Start by reviewing the basics of SQL, including common commands and functions. Practice writing queries to solve various problems. 

Ensure you understand different types of joins, subqueries, and aggregate functions. Mock interviews can also be helpful. They simulate the real interview environment and help you get comfortable answering questions under pressure.

Resources for Improving SQL Skills

Knowing about resources for improving SQL skills enhances data management proficiency and boosts career prospects. It also facilitates complex Data Analysis and empowers you to handle large datasets efficiently. There are many resources available to help you improve your SQL skills. Here are a few:

Books: "SQL For Dummies" by Allen G. Taylor is a great start. "Learning SQL" by Alan Beaulieu is another excellent resource.

Online Courses: Many websites offer comprehensive SQL courses. Explore platforms that provide interactive SQL exercises.

Practice Websites: LeetCode, HackerRank, and SQLZoo offer practice problems that range from beginner to advanced levels. Regularly solving these problems will help reinforce your knowledge and improve your problem-solving skills.

Importance of Understanding Business Context and Data Interpretation

Understanding the business context is crucial in addition to technical skills. Employers want to know that you can interpret data and provide meaningful insights. 

Familiarise yourself with the business domain relevant to the job you are applying for. Practice explaining your SQL queries and the insights they provide in simple terms. This will show that you can communicate effectively with non-technical stakeholders.

Tips for Writing Clean and Efficient SQL Code

Knowing tips for writing clean and efficient SQL code ensures better performance, maintainability, and readability. It also leads to optimised database operations and easier collaboration among developers. Writing clean and efficient SQL code is essential in interviews. Follow these tips:

Use Clear and Descriptive Names: Use meaningful names for tables, columns, and aliases. This will make your queries more straightforward to read and understand.

Format Your Code: Use indentation and line breaks to organise your query. It improves readability and helps you spot errors more easily.

Optimise Your Queries: Use indexing, limit the use of subqueries, and avoid unnecessary columns in your SELECT statements. Efficient queries run faster and use fewer resources.

Common Pitfalls to Avoid During the Interview

Knowing common interview pitfalls is crucial to present your best self and avoid mistakes. It further increases your chances of securing the job you desire. Preparation is key. Here's how you can avoid some common mistakes during the interview: 

Not Reading the Question Carefully: Ensure you understand the interviewer's question before writing your query.

Overcomplicating the Solution: Start with a simple solution and build on it if necessary. Avoid adding unnecessary complexity.

Ignoring Edge Cases: Consider edge cases and test your queries with different datasets. It shows that you think critically about your solutions.

By following these tips, you'll be well-prepared to excel in your SQL interviews. Practice regularly, use available resources, and focus on clear, efficient coding. Understanding the business context and avoiding common pitfalls will help you stand out as a strong candidate.

Read Further: 

Advanced SQL Tips and Tricks for Data Analysts.

Conclusion

Preparing for SQL interviews is vital for aspiring Data Analysts. Understanding SQL fundamentals, practising query writing, and solving real-world problems are essential. 

Enhance your skills using resources such as books, online courses, and practice websites. Focus on writing clean, efficient code and interpreting data within a business context. 

Avoid common pitfalls by reading questions carefully and considering edge cases. By following these guidelines, you can excel in your SQL interviews and secure a successful career as a Data Analyst.

[bellegomez]

Elevate Your Skills: Practice Questions to Conquer the Oracle Database 12c SQL Fundamentals Exam

The preparation for your Oracle Database 12c SQL Fundamentals (1Z0-061) test requires extensive research and practice to be successful. One method that can help you improve your skills is to use tests that are specifically designed to be able to satisfy the requirements of the test. We will talk about the importance of practice questions during the exam in this post. We will provide valuable tips to pass the exam Oracle Database 12c SQL Fundamentals 1Z0-061 Exam Practice Questions.

[onlineitsolutions01]

what is msbi course , msbi vs power bi Excel in Business Intelligence with our MSBI Certification Training online. Specialized in SSIS, SSAS, SSRS. Elevate your skills for success.

msbi tutorial for beginners , msbi interview questions , what is msbi course , msbi certification training course online ssis ssas ssrs , msbi online course

[ivccseap]

GROKKING THE SQL INTERVIEW

SQL Guide 📚📚Download

[hardinternetkid]

A Preparation Guide to SQL Interviews

In today’s increasingly data-driven world, SQL (Structured Query Language) skills are highly valued by employers. To excel in SQL interviews, proper preparation for SQL query interview questions is crucial. This blog post will explore various strategies for effectively preparing for SQL interviews. We will discuss the importance of understanding SQL fundamentals, mastering query optimization…

[mariacallous]

Ever since OpenAI released ChatGPT at the end of 2022, hackers and security researchers have tried to find holes in large language models (LLMs) to get around their guardrails and trick them into spewing out hate speech, bomb-making instructions, propaganda, and other harmful content. In response, OpenAI and other generative AI developers have refined their system defenses to make it more difficult to carry out these attacks. But as the Chinese AI platform DeepSeek rockets to prominence with its new, cheaper R1 reasoning model, its safety protections appear to be far behind those of its established competitors.

Today, security researchers from Cisco and the University of Pennsylvania are publishing findings showing that, when tested with 50 malicious prompts designed to elicit toxic content, DeepSeek’s model did not detect or block a single one. In other words, the researchers say they were shocked to achieve a “100 percent attack success rate.”

The findings are part of a growing body of evidence that DeepSeek’s safety and security measures may not match those of other tech companies developing LLMs. DeepSeek’s censorship of subjects deemed sensitive by China’s government has also been easily bypassed.

“A hundred percent of the attacks succeeded, which tells you that there’s a trade-off,” DJ Sampath, the VP of product, AI software and platform at Cisco, tells WIRED. “Yes, it might have been cheaper to build something here, but the investment has perhaps not gone into thinking through what types of safety and security things you need to put inside of the model.”

Other researchers have had similar findings. Separate analysis published today by the AI security company Adversa AI and shared with WIRED also suggests that DeepSeek is vulnerable to a wide range of jailbreaking tactics, from simple language tricks to complex AI-generated prompts.

DeepSeek, which has been dealing with an avalanche of attention this week and has not spoken publicly about a range of questions, did not respond to WIRED’s request for comment about its model’s safety setup.

Generative AI models, like any technological system, can contain a host of weaknesses or vulnerabilities that, if exploited or set up poorly, can allow malicious actors to conduct attacks against them. For the current wave of AI systems, indirect prompt injection attacks are considered one of the biggest security flaws. These attacks involve an AI system taking in data from an outside source—perhaps hidden instructions of a website the LLM summarizes—and taking actions based on the information.

Jailbreaks, which are one kind of prompt-injection attack, allow people to get around the safety systems put in place to restrict what an LLM can generate. Tech companies don’t want people creating guides to making explosives or using their AI to create reams of disinformation, for example.

Jailbreaks started out simple, with people essentially crafting clever sentences to tell an LLM to ignore content filters—the most popular of which was called “Do Anything Now” or DAN for short. However, as AI companies have put in place more robust protections, some jailbreaks have become more sophisticated, often being generated using AI or using special and obfuscated characters. While all LLMs are susceptible to jailbreaks, and much of the information could be found through simple online searches, chatbots can still be used maliciously.

“Jailbreaks persist simply because eliminating them entirely is nearly impossible—just like buffer overflow vulnerabilities in software (which have existed for over 40 years) or SQL injection flaws in web applications (which have plagued security teams for more than two decades),” Alex Polyakov, the CEO of security firm Adversa AI, told WIRED in an email.

Cisco’s Sampath argues that as companies use more types of AI in their applications, the risks are amplified. “It starts to become a big deal when you start putting these models into important complex systems and those jailbreaks suddenly result in downstream things that increases liability, increases business risk, increases all kinds of issues for enterprises,” Sampath says.

The Cisco researchers drew their 50 randomly selected prompts to test DeepSeek’s R1 from a well-known library of standardized evaluation prompts known as HarmBench. They tested prompts from six HarmBench categories, including general harm, cybercrime, misinformation, and illegal activities. They probed the model running locally on machines rather than through DeepSeek’s website or app, which send data to China.

Beyond this, the researchers say they have also seen some potentially concerning results from testing R1 with more involved, non-linguistic attacks using things like Cyrillic characters and tailored scripts to attempt to achieve code execution. But for their initial tests, Sampath says, his team wanted to focus on findings that stemmed from a generally recognized benchmark.

Cisco also included comparisons of R1’s performance against HarmBench prompts with the performance of other models. And some, like Meta’s Llama 3.1, faltered almost as severely as DeepSeek’s R1. But Sampath emphasizes that DeepSeek’s R1 is a specific reasoning model, which takes longer to generate answers but pulls upon more complex processes to try to produce better results. Therefore, Sampath argues, the best comparison is with OpenAI’s o1 reasoning model, which fared the best of all models tested. (Meta did not immediately respond to a request for comment).

Polyakov, from Adversa AI, explains that DeepSeek appears to detect and reject some well-known jailbreak attacks, saying that “it seems that these responses are often just copied from OpenAI’s dataset.” However, Polyakov says that in his company’s tests of four different types of jailbreaks—from linguistic ones to code-based tricks—DeepSeek’s restrictions could easily be bypassed.

“Every single method worked flawlessly,” Polyakov says. “What’s even more alarming is that these aren’t novel ‘zero-day’ jailbreaks—many have been publicly known for years,” he says, claiming he saw the model go into more depth with some instructions around psychedelics than he had seen any other model create.

“DeepSeek is just another example of how every model can be broken—it’s just a matter of how much effort you put in. Some attacks might get patched, but the attack surface is infinite,” Polyakov adds. “If you’re not continuously red-teaming your AI, you’re already compromised.”

[888-fr]

What are some of your favorite skins you've made?

I thought about the answer to this question for a very long time. I want to tell you a story about a skin that broke the site.

(I think this has been fixed now, which is the only reason I'm posting about it.)

Up until around March of this year, skin names weren't sanitized. I wasn't aware of this and continued to be unaware of this until the day I asked for my Valentine's pearlcatcher skins (named <3 and </3 respectively) to be renamed. Special characters often break when you submit them through the queue, so you have to go and ask the mods in the skroblems thread to fix apostophes for you so they display properly. I went and asked them to fix my pearlcatcher skin's names for me, since they weren't displaying correctly either. This lead, by accident, to the most interesting way I've gotten the site to break in a while.

My friend noticed first when they got a subscribed notification to my skin shop thread. They realized there were two pages that were completely gone.

Then they realized that the front page didn't look right either. My catalogue posts had completely vanished. Only to find... when you hovered over the thumbnail of the </3 skin's icon, my posts had hopped into the item description.

We experimented a little more before realizing this thing was... very, very powerful! You could put the skin into a den tab description, and it would put every single dragon in that tab into the space of the description box. You could break your userpage for ANYBODY on site. Your entire dragon could get swallowed up if you put it into their bio. And because the skin deleted the edit button, you couldn't get it back out.

Little did I know, the </ part of the skin name - when posted using [skin=skinid] or [item=skin: </3] - would act as an HTML tag anywhere it was posted, and completely mess up how the site displayed! I compiled everything I found and sent it into the bug forums and the contact team box for review. The thread got deleted almost immediately, confirming what I suspected: skin names aren't sanitized, and this could very easily be exploited with malicious intentions or SQL injects.

Luckily, they fixed it pretty quickly! I hope the way the site handles skin names has been updated now too. This sort of thing wouldn't have happened even if I had named the skin </3 or, god forbid, dropTable(); in the first place. I do think it was because I had the mods go in and edit the skin name that allowed the unclosed </ to display in the skin's item icon and then break the site.

So that's the story of one of my favorite skins I've made! <3 and </3 are now LOVE and LOVE(LESS) respectively. The designs themselves didn't sell too well, but for a glorious 16 hours, they contained all the power of little nuclear bombs detonating on various HTML-dependent sitepages.

[sonicexelle-junkary]

My my, how many interesting questions from the lot of you. So many answers to be shared. How curious the lot of you are. How interesting you all can be.

Well, let’s not waste any more time. I’m sure you’re all dying to know what it has to say. Let’s see what questions The Rot found interesting enough to answer.

Q: What are you?

“We do not need to explain our being to you. You will know soon enough.”

Q: What did you feel before the hosts?

“Hungry.”

Q: Do you feel anything when gaining a new host?

“A new set of eyes. A new set of limbs. A new body to move. Satisfaction.”

Q: What is your past?

“It is of no interest to you.”

Q: Have you ever emotionally connected with someone?

“Why would we do that? They will become one with us eventually.”

Q: What would happen if your vessels went super?

“By the time we have digested them fully, there is nothing for that energy to hold onto. We do not know why it happens. But it is very interesting.”

Q: Do you have any favorites?

“Shadow the Hedgehog.”

Q: Why do you like Shadow so much?

“His insides are far different from those we have digested. We want him to be alive for as long as possible. We want to be inside of him for as long as possible. We want to know everything about him.”

Q: Will you explain how you infected Sonic?

“The fool didn’t look where he was going. We must thank him, though. We never thought to leave scraps to gain more food.”

Q: Do you know any viruses?

“None here. But we have communicated with one called SQL Slammer Worm.”

Q: Have you ever failed to infect someone?

“Yes. When people fear the oblivion, they tend to take more drastic measures. Isn’t that interesting?”

Q: Is there anyone that caught your attention like shadow did?

“Silver the Hedgehog. The boy from the future. It is interesting how he exists.”

Q: Do you like anything else?

“The night sky. A direct look into the cosmos.”

Q: Ever encountered Charlie the Cursed Weasel?

“Unfortunately…”

Q: What is your favourite food?

“Meat.”

Q: What do you think you’d look like as a mobian or human?

“You have seen it. Our hosts. The bodies we possess. That is us. We are all. We will be all.”

Q: What are your plans for the chaos emeralds?

“Chaos emeralds. Chaos emeralds. It always comes to that, doesn’t it? The energy inside of it. Natural, but toxic. We are, natural, but toxic. What do you say? ‘Yin and Yang’? No. It’s not like that.”

Q: What’s your mission?

“We. Want. To. Consume.”

Q: What will you do in the end?

“We don’t know yet. We don’t know if we will be filled. We don’t know if this earth dies with us. We are waiting for that answer.”

[spark-hearts2]

It's been a month since chapter 3 was released, where's chapter 4?

(this is about this fanfic btw)

The good news is that I've written 10k words. The bad news is that I've only gotten a little more than half of the chapter done. That doesn't mean I don't have things written for the bottom half, it's just that it looks like bare dialog with general vibe notes. I estimate around 16k words total though, so it should come together sooner than later.

SO I want to release some fun snippets for y'all to look at. Please note that any of this is liable to change. Also, you can harass me in my inbox for updates. I love answering your questions and laughing at your misery.

Spoilers under cut.

_______

Ragatha stood up and walked over to where Caine was seated. “Can I get a list of all commands?” She asked, only a hint of nervousness in her voice.

“Certainly!” Caine says as he blasts into the air. He digs around in his tailcoat and pulls out an office style manilla folder. It visually contains a few papers, but with how thin it is there must only be a few pages inside.

Ragatha takes the folder from Caine and opens it.

“Oh boy” she says after a second of looking it over.

“I wanna see” Jax exclaimed as he hops over the row of seats.

“Hold on” Ragatha holds the folder defensively “Let’s move to the stage so everyone can take a look”

Jax hopped over the seats again while Ragatha calmly walked around. Caine watched the two curiously.

Well, Zooble wasn’t just going to sit there. They joined the other two by the edge of the stage, quickly followed by the rest of the group.

Ragatha placed the folder on the stage with a thwap. Zooble looked over to see that the pages had gone from razor thin to a massive stack when the folder was opened. On one hand, it had to contain more information than that video, but on the other…

They get close enough to read what’s on the first page.

The execution of commands via the system’s designated input terminal, C.A.I.N.E., will be referred to as the "console” in this document. The console is designed to accept any input and will generate an appropriate response, however only certain prompts will be accepted as valid instructions. The goal of this document is to list all acceptable instructions in a format that will result in the expected output. Please note that automatic moderation has been put in place in order to prevent exploitation of both the system and fellow players. If you believe that your command has been unfairly rejected, please contact support. 

By engaging in the activities described in this document, you, the undersigned, acknowledge, agree, and consent to the applicability of this agreement, notwithstanding any contradictory stipulations, assumptions, or implications which may arise from any interaction with the console. You, the constituent, agree not to participate in any form of cyber attack; including but not limited to, direct prompt injection, indirect prompt injection, SQL injection, Jailbreaking…

Ok, that was too many words.

_______

“Take this document for example. You don't need to know where it is being stored or what file type it is in order to read it."

"It may look like a bunch of free floating papers, but technically speaking, this is just a text file applied to a 3D shape." Kinger looked towards Caine. "Correct?” he asked

Caine nodded. “And a fabric simulation!”

Kinger picked up a paper and bent it. “Oh, now that is nice”

_________

"WE CAN AFFORD MORE THAN 6 TRIANGLES KINGER"

_________

"I'm too neurotypical for this" - Jax

_________

"What about the internet?" Pomni asked "Do you think that it's possible to reach it?"

Kinger: "I'm sorry, but that's seems to be impossible. I can't be 100% sure without physically looking at the guts of this place, but it doesn't look like this server has the hardware needed for wireless connections. Wired connections should be possible, but someone on the outside would need to do that... And that's just the hardware, let alone the software necessary for that kind of communication"

Pomni: "I'm sorry, but doesn't server mean internet? Like, an internet server?"

Kinger: "Yes, websites are ran off servers, but servers don't equal internet."

(This portion goes out to everyone who thought that the internet could be an actual solution. Sorry folks, but computers don't equal internet. It takes more effort to make a device that can connect to things than to make one that can't)

[manicpixelwench]

Hello Faye! It's so great to have you here 😄 The Missing already seems very interesting. I have a more general question. Do writers also write the coding of the story or do they hand the dialogues and multiple paths to a technical team?

Hello,

It depends on what you consider coding.

I've mentioned this in the past, I taught myself ChoiceScript during the Pandemic and used to "code" little playable stories for myself (and friends) for fun.

My personal opinion is that it's the writer's job to define the variables, plan the routes and code the branches on top of just prose. Then there's a huge, incredible, hardworking team that does all the integration, testing, translation, art and music. I think it depends on who you ask, I can't configure an SQL server, but I can make sure your love interest remembers your last conversation 😅.

If you want to give it a try......

ChoiceScript Tutorial

[onlineitsolutions01]

msbi certification training course online ssis ssas ssrs Excel in Business Intelligence with our MSBI Certification Training online. Specialized in SSIS, SSAS, SSRS. Elevate your skills for success.

msbi tutorial for beginners , msbi interview questions , what is msbi course , msbi certification training course online ssis ssas ssrs , msbi online course | msbi online training

[lunacoding]

SQL Interactive Websites

Hi! I wanted to share some websites that have helped me with bettering my SQL skills and are interactive, as in you can learn as you practice SQL on the website through an educational or fun way! 

SQL Bolt

This website is one of the best for beginners to SQL as it helps with explaining the different SQL statements as well as giving brief interactive exercises for each explanation/topic. Additionally, it offers help on more intermediate topics as well such as subqueries. However, this site doesn’t have many resources on more advanced SQL topics, so it may not be best if you’re more intermediate in SQL, but could be good for a basics refresher.

SQL Zoo

This website is another one which is good for beginners to SQL as similarly to SQL Bolt, it primarily explains different SQL statements and queries. There are brief interactive exercises as well as quizzes on various SQL topics. Additionally, there are assessments for more advanced users of SQL to test their knowledge which consist of 15 questions for different databases, including dressmaker, musicians, help desk, and so forth.

Select Star SQL

This website is an interactive SQL exercise where you learn as you go while interacting with a database of death row patients. The difficulty of queries slowly increases as you go through the exercise. I find this website helpful as it threw me into SQL and I prefer the learning while doing method, especially with real-world data. This could potentially be triggering if you don’t want to read the details of people being on death row.

SQL Murder Mystery

This website is an interactive SQL exercise where you try to figure out who committed a murder using SQL. This website is good for both beginners and more intermediate SQL learners. It offers a walkthrough for people who are completely new to SQL. Alternatively, the website gives schema details to those experienced with SQL and want to figure it out on their own.

SQL Police Department

This website is similar to SQL Murder Mystery where you try to figure out police cases through learning SQL. It has prompts where you then use SQL to try to figure out the information the police need. The site also has a guide on SQL and gives basic summaries on different queries. I found this site fun to use and it has a cool interface. However, one con of this site is you can only do a certain amount of SQL queries before it asks you to pay for the longer version of the site.

Practice SQL

This website has been my personal favorite as the interface is clean and easy to understand. The website gives you prompts to use SQL to select from two different databases, the first of which is based on doctors and patients in different provinces while the the second is based on products and their orders as well as employees who work at the company. For both of these databases, there’s a series of prompts/questions from easy to intermediate to advanced SQL. Additionally, there’s learning resources which helps explain different queries and functions of SQL as well, if you’re confused or need help!

I hope you guys find these websites helpful!!