polaryeti

Currently in my company, we're using VPN->Then RDP. And inside RDP, we access remote server. While some servers are directly accessible, some are not. We need to do tunneling for it. I'm failing to understand the point of tunneling. I've read articles after articles like this(https://www.gaia-gis.it/fossil/virtualpg/wiki?name=port-forwarding), but it's not entering my head. Can't anyone who knows the server IP and has company VPN; tunnel and get access to that server? I know they can, but what's the point of that tunnel? They could've just filtered by requests coming via a particular IP say xx.xx.xx.xx to be allowed and reject everything else. What's the point of tunneling? What's the problem that tunneling is trying to solve?

1) Oracle 1Z0-149 2) Oracle Database SQL 1Z0-071 3) Oracle Database 12c: SQL Fundamentals 1Z0-061 4) or any other oracle exams? I've no idea about it. I've finished learning a 20hrs sql course. It took me probably 100hrs to finish the course as I went slow. I'm confident with the basics. But few things I need more practice on(not that I don't know them but still confused). They're: 1) Aggregate functions and GROUP BY. 2) Transactions & concurrency control 3) Procedures, Views 4) Subqueries I thought the obvious next step would be take some oracle certification (I won't give exams as I don't earn that much, just study for the exam). If there are other DBA certification except Oracle, do tell me? We use microsoft sql server and mysql at work but I've already learnt enough sql for work. (we just need basic select query at work)

I've read tidbits of pages from around 10 books, and I can safely say I am even more confused than before. Earlier I'd just set everything in .bashrc file. LOL. Say I've scenarios like these: 1) I want to set system variables for user "jacky", what should I use? 2) I want to set system variables for all users, what should I use? 3) I want to set alias for user "jacky", what should I use? 4) I want to set alias for all users, what should I use? What are interactive/non-interactive login/non-login shells? I've asked chatgpt but it gave me convoluted reply. So, it was not very clear.

Which both command?

I'm still not clear about this topic. This is confusing as hell. How do I select a column to group by? What should be the properties of that column? Is it necessary for that column I choose to group by to functionally determine other columns presented in the select query except the aggregated column(eg, column where count is being used or sum is being used)?

thank you for your answer.

thank you @kicken

So if I want to find: 1) A file with setuid field set regardless of other permissions. Which command do I need to use?

I want to know the exact difference between these commands with examples. I've read the man pages.

Quoting from the man pages.

I'm asking this question because I'm seeing multiple variants of this command. 1) find / -perm /u=s file_name or find / -perm -u=s file_name 2) find / -perm 4666 or find / -perm 4000 or find / -perm /4000 Source of my confusion: https://unix.stackexchange.com/questions/180867/how-to-search-for-all-suid-sgid-files

We want to know the best customer of Northwind database by the highest total amount spent. https://brucebauer.info/assets/ITEC3610/Northwind/Northwind-Sample-Database-Diagram.pdf This is the northwind database diagram. My try SELECT contactname FROM customers WHERE orderid IN (SELECT orderid FROM orderdetails HAVING MAX(unitprice * quantity)); This is producing the below error: Error Code: 1054. Unknown column 'orderid' in 'IN/ALL/ANY subquery' This is the answer provided. SELECT * FROM customers WHERE customerid = (SELECT customerid FROM orders WHERE orderid = (SELECT orderid FROM orderdetails GROUP BY orderid ORDER BY SUM(unitprice * quantity) DESC LIMIT 1)); I am trying to understand sub queries since five hours, but nothing is getting into my head. Can you please guide me towards some good tutorials/books/courses that'd help me understand subqueries. I prefer books at this moment.

https://linux-training.be/funhtml/ch18.html echo hello > greetings.txt I feel it's telling before counting the number of arguments, redirection operator is ignored. But later it says how it affects output erasing file case. [paul@RHELv4u3 ~]$ cat winter.txt It is cold today! [paul@RHELv4u3 ~]$ zcho It is cold today! > winter.txt -bash: zcho: command not found [paul@RHELv4u3 ~]$ cat winter.txt [paul@RHELv4u3 ~]$ So can you explain how zcho It is cold today! > winter.txt command processes internally? My estimate 1) > is ignored 2) Number of arguments are count. There are 2 arguments "It is cold today!" and winter.txt 3) then what? i don't know.

I think you didn't get my question. I specifically want to use DESC in order by and find the fourth lowest salary. (I realize possibility of same salary but that's my next question).

I've this database. https://brucebauer.info/assets/ITEC3610/Northwind/Northwind-Sample-Database-Diagram.pdf I want to find fourth lowest salary. SELECT * FROM employees ORDER BY salary DESC LIMIT 1 OFFSET (Number_of_rows_of_table-3); I can solve this by using order by ASC pretty easily with LIMIT 1 OFFSET 3. I'm wondering if there's an way to solve it via order by DESC? Here's my try which didn't work. SELECT count(*) as no_of_rows_of_table, salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET (no_of_rows_of_table-3);