A MySQL database has two tables. Table "test_users" has columns "id", "name", and "email". Table "test_orders" has columns "id", "user" (which is a reference to test_users id), "item", "and "price". Every order has a corresponding user, but not every user has an order. Write an SQL query to return all orders, and for each order their corresponding user. (Return all columns for the matching records.
Fix the mistake in the following Apache configuration to redirect a user from plain HTTP to HTTPS.
<VirtualHost *:443>
ServerName example.com
RewriteEngine On
RewriteCond %{HTTPS} off
RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI}
</VirtualHost>
A Linux server is reporting high load averages, but CPU usage is low. What could be the cause?
While using "top" at a Linux server console you find you need to pause it, run "Is" to check something, and then resume using "top" again. There is no remote access to the server. How would you do this?
What configuration setting would you change to fix the problem? maximum number of connections exceeded: 2048/2048
What SIP request method is used to transfer a call when a user presses the "Transfer" button on their telephone?
Why might a SIP telephone send another INVITE on a call that's already been answered?
Where in a SIP dialog is the expiry time of a registration specified?
The nightly crontab entry to run "apachectl restart" gives a "command not found" error, but you can run it successfully from your shell. What could the problem and solution be?
A server runs a web based tool that listens only on 127.0.0.1 port 888. You have SSH access to the server. How would you use command-line SSH to access web tool from a web browser on your own computer
You receive a ticket from a customer with the following problem report. What would your first reply to them be? Write your actual reply. "One of our telephones has had problems making calls today. Can you please check the system?"
A customer asks you to set up telnet service on a Linux server they own and let them know the root password. You SSH into the server and see that the telnet service is not installed. What will you do?
Programming challenge! Write a command-line Perl program or Bash shell script which gets a date from the user, and then tells the user if that date is in the past or future.
https://chatgpt.com/