T1

30. Which of the following theses are true regarding SQL and DBMS? * - Indexes work by creating a separate data structure that contains copies of the indexed columns in sorted order. When executing a query, the DB engine searches the index for rows matching the query conditions, and then retrieves the actual data from the table; - No DBMS can guarantee adherence to the CAP theorem; - A DBMS does not support one-to-many relationships; - A DBMS can operate on behalf of a user with root privileges; 31. What is a subquery in SQL? * - An embedded function of the language for automatic query optimization; - A syntactic construct that allows querying unknown data within the scope of the executing query; - An outdated function of some DBMS; - The ability to search for information not within a single table, but across the entire existing database;

Where are application logs stored in Linux OS? * What are signs of memory leaks in a JAVA application? * Serious performance degradation during long-term operation of the application; Errors in logs like memeryEmpty; FatalErrors leading to emergency shutdown of the application; Occurrence of lock screens;

23. List existing Linux command-line utilities? cat; ls; grep; version; top; interfaces; unlock; systemctl; grep; less; ns; nmap; 24. List the main theses of the Linux way.

48. Command to start a container? docker start; docker continue; docker init; docker run; 49. How to view the list of running docker containers? docker ps; docker ls; docker ll; docker –procces; 50. What is CI/CD? A monitoring tool for OS; A methodology that combines continuous integration and deployment processes;

34. What is NAT technology for? * - Increasing the default number of VLANs; - To restrict incoming, outgoing, and intra-network traffic; - Ensuring conflict-free addressing in the internet; - Assigning DNS gateway and creating network tables; 35. What are TCP/IP ports? * - An abstraction at the level of different OS regulating communication between applications over TCP or UDP protocols; - A utility built into some OS, allowing to "port" utilities and applications between OS; - Network equipment interfaces; - OS kernel interfaces through which interaction with the OS is possible; 36. OSI/ISO model levels? *

45. What is a docker file? - Local docker image repository; - A file with instructions for building a docker image; - Docker configuration file; - Official docker documentation; 46. What is the primary process in a container? - FROM; - RUN; - initd; - run.deamon; 47. Command to build a docker image?

58. What does Kafka need to operate?

28. Какие потоки данных в Linux вы знаете? 29. Укажите варианты запросов которые выполнятся без ошибок - select * from processing_db where user_id=413; - SELECT user_id FROM processing_db; - select * from processing_db where user_id=413 - select * from pg_state_activity where db_name="processing_db"; - select * form instruct;

41. What can cause memory leaks in JAVA applications? * - Improper object management in the heap; - No garbage collector usage; - Incorrect use of static variables; - Excessive use of recursive functions; - Incorrect use of constructors; 42. Types of memory leaks in JAVA applications? * - Through unclosed resources; - Using incorrect data structures; - Incorrect use of garbage collector; - Incorrect use of data streams; 43. What is Docker? *

24. State the main theses of the Linux way - Everything is a file; - Root user locking is mandatory; - One utility solves one task well; - System calls are designed for easier process management; 25. Which utility can you use to view system load? - ps as; - top; - ls -la; - sudo apt-get;

What is Jenkins? - One of the most well-known implementations of delivery and deployment pipelines; - Software designed for monitoring remote network nodes; - An application for network node geolocation; - One of the main processes of the Linux OS; What are the main entities of Kubernetes? - Deployment; - Limits; - Endpoint; - ConfigMap; - Secrets; - Levels; - Pod; - ReplicaSet;

What is statistical power?