LPI 102 - Shells, Scripting And Data Management 1- Marcus Vinicius Braga Alcantara

1. O comando test -x /bin/sync tem qual finalidade ?

Testa se o arquivo existe e tem permissão de leitura.

Testa se o arquivo existe e tem permissão de execução.

Testa se o arquivo existe e tem permissão de escrita.

Testa se o arquivo existe e é um diretório.

The command "test -x /bin/sync" is used to test if the file "/bin/sync" exists and has execute permission.

Explanation

The command "test -x /bin/sync" is used to test if the file "/bin/sync" exists and has execute permission.

2. A primeira linha de um shell script deve sempre conter dois caracteres no início desta linha. Quais são eles?

The first line of a shell script should always start with the characters #!. This is known as the shebang or hashbang and it is used to specify the interpreter that should be used to execute the script. In this case, the #! indicates that the script should be interpreted by the shell.

Explanation

The first line of a shell script should always start with the characters #!. This is known as the shebang or hashbang and it is used to specify the interpreter that should be used to execute the script. In this case, the #! indicates that the script should be interpreted by the shell.

Submit

3. Qual comando exclui a variável de ambiente FOOBAR?

unset FOOBAR

del $FOOBAR

export FOOBAR

export FOOBAR=

The correct answer is "unset FOOBAR." This command is used to remove or delete the environment variable named FOOBAR.

Explanation

The correct answer is "unset FOOBAR." This command is used to remove or delete the environment variable named FOOBAR.

4. Qual dos comandos abaixo, irá exibir informações sobre as variáveis de ambiente no seu sistema ?

builtin

join

env

source

The command "env" will display information about the environment variables in the system.

Explanation

The command "env" will display information about the environment variables in the system.

5. Na confecção de um novo script bash, qual deve ser o valor de sua primeira linha ?

!bash -x

#bash_script

#!/bin/bash

!#/bin/bash

The correct answer is "#!/bin/bash". This is because the "#!" symbol is known as the shebang, and it is used to specify the interpreter that should be used to execute the script. In this case, the shebang specifies that the script should be executed using the bash interpreter.

Explanation

The correct answer is "#!/bin/bash". This is because the "#!" symbol is known as the shebang, and it is used to specify the interpreter that should be used to execute the script. In this case, the shebang specifies that the script should be executed using the bash interpreter.

6. Você está escrevendo um script e gostaria de testar o estado de saída deste processo. Qual das opções abaixo é verdadeira?

O valor de saída normal difere.

Você não pode testar o valor de saída normal.

O valor de saída normal é de $EXIT.

O valor de saída normal é 0.

The correct answer is "O valor de saída normal é 0." This is because in programming, a return value of 0 typically indicates a successful execution or completion of a process. Therefore, if you want to test the exit status of a process, you would check if the return value is 0 to determine if it exited normally.

Explanation

The correct answer is "O valor de saída normal é 0." This is because in programming, a return value of 0 typically indicates a successful execution or completion of a process. Therefore, if you want to test the exit status of a process, you would check if the return value is 0 to determine if it exited normally.

7. Qual comando que fecha uma estrutura de condição if ?

fi

endfi

end

done

The correct answer is "fi". In shell scripting, "fi" is used to close an if statement. It marks the end of the if block and allows the program to continue executing the code after the if statement.

Explanation

The correct answer is "fi". In shell scripting, "fi" is used to close an if statement. It marks the end of the if block and allows the program to continue executing the code after the if statement.

8. Qual o comando que remove uma variável definida no shell corrente ?

The "unset" command is used to remove a defined variable in the current shell. It allows the user to unset or delete the value and attributes associated with a variable, making it no longer available for use in the shell.

Explanation

The "unset" command is used to remove a defined variable in the current shell. It allows the user to unset or delete the value and attributes associated with a variable, making it no longer available for use in the shell.

Submit

9. Quais são os dois arquivos no diretório home de um usuário que são usados para personalizar o ambiente bash?

bash e .bashrc

bashrc e bash_conf

bashrc e bashprofile

.bashrc e .bash_profile

bash.conf e .bash_profile

The correct answer is .bashrc and .bash_profile. These two files are used to customize the bash environment for a user. The .bashrc file contains specific configurations and settings for the bash shell, such as aliases, functions, and environment variables. It is executed every time a new shell is opened. On the other hand, the .bash_profile file is executed only during the login process and can be used to set up environment variables and execute commands or scripts. Together, these files allow users to personalize their bash environment according to their preferences.

Explanation

The correct answer is .bashrc and .bash_profile. These two files are used to customize the bash environment for a user. The .bashrc file contains specific configurations and settings for the bash shell, such as aliases, functions, and environment variables. It is executed every time a new shell is opened. On the other hand, the .bash_profile file is executed only during the login process and can be used to set up environment variables and execute commands or scripts. Together, these files allow users to personalize their bash environment according to their preferences.

10. Qual das opções abaixo pode ser utilizada para criar uma variável chamada LINUX com a atribuição do valor; lpi ?

LINUX=lpi

linux=lpi

$LINUX=lpi

N.D.A

The correct answer is "LINUX=lpi" because it follows the correct syntax for creating a variable in Linux. In Linux, variables are typically written in uppercase letters, and the assignment of a value is done using the "=" sign. Therefore, "LINUX=lpi" is the correct way to create a variable called LINUX with the value "lpi".

Explanation

The correct answer is "LINUX=lpi" because it follows the correct syntax for creating a variable in Linux. In Linux, variables are typically written in uppercase letters, and the assignment of a value is done using the "=" sign. Therefore, "LINUX=lpi" is the correct way to create a variable called LINUX with the value "lpi".

11. Qual comando remove um alias do shell já definido ?

rmalias

rm

delalias

unalias

The correct answer is "unalias". This command is used to remove an alias that has been previously defined in the shell.

Explanation

The correct answer is "unalias". This command is used to remove an alias that has been previously defined in the shell.

12. Qual das opções abaixo pode ser utilizada para exibir o conteúdo da variável LINUX ?

print $LINUX

env $LINUX

echo $LINUX

echo LINUX

export LINUX

The correct answer is "echo $LINUX" because the "echo" command is used to display the value of a variable in the terminal, and "$LINUX" refers to the variable named LINUX. By using "echo $LINUX", the content of the LINUX variable will be displayed on the screen.

Explanation

The correct answer is "echo $LINUX" because the "echo" command is used to display the value of a variable in the terminal, and "$LINUX" refers to the variable named LINUX. By using "echo $LINUX", the content of the LINUX variable will be displayed on the screen.

13. Qual dos comandos abaixo irá incluir um registro na tabela CLIENTES ?

SELECT

DELETE

UPDATE

INSERT

The INSERT command is used to add a new record to a table in a database. In this case, the command "INSERT" is the only option that explicitly states the action of adding a record to the table CLIENTES. The SELECT command is used to retrieve data from a table, the DELETE command is used to remove records from a table, and the UPDATE command is used to modify existing records in a table. Therefore, the correct answer is INSERT.

Explanation

The INSERT command is used to add a new record to a table in a database. In this case, the command "INSERT" is the only option that explicitly states the action of adding a record to the table CLIENTES. The SELECT command is used to retrieve data from a table, the DELETE command is used to remove records from a table, and the UPDATE command is used to modify existing records in a table. Therefore, the correct answer is INSERT.

14. Qual instrução SQL que modifica dados já inseridos em uma tabela ?

WHERE

DELETE

INSERT

UPDATE

The correct answer is UPDATE. The UPDATE statement in SQL is used to modify existing data in a table. It allows you to change the values of one or more columns in a specific row or multiple rows based on a specified condition using the WHERE clause. This statement is commonly used to update records with new values or to correct existing data in a database table.

Explanation

The correct answer is UPDATE. The UPDATE statement in SQL is used to modify existing data in a table. It allows you to change the values of one or more columns in a specific row or multiple rows based on a specified condition using the WHERE clause. This statement is commonly used to update records with new values or to correct existing data in a database table.

15. Qual o comando que torna uma variável do shell como sendo do tipo GLOBAL ?

The command "export" is used to make a shell variable global. When a variable is exported, it can be accessed by other processes or subshells. This allows the variable to be shared and used throughout the entire shell environment, rather than being limited to a specific shell or script.

Explanation

The command "export" is used to make a shell variable global. When a variable is exported, it can be accessed by other processes or subshells. This allows the variable to be shared and used throughout the entire shell environment, rather than being limited to a specific shell or script.

Submit

16. Qual o valor da variável especial $! do shell BASH ?

Contém o PID do último processo executado pelo shell.

Contém o nome do último login que acessou o sistema.

O nome da variável é inválido e a mesma não faz parte das variáveis do shell BASH.

Armazena o valor PID do processo init.

The correct answer is "Contém o PID do último processo executado pelo shell." This means that the variable $! in the BASH shell contains the Process ID (PID) of the last process that was executed by the shell.

Explanation

The correct answer is "Contém o PID do último processo executado pelo shell." This means that the variable $! in the BASH shell contains the Process ID (PID) of the last process that was executed by the shell.

17. Como eu posso verificar o sucesso ou não de um comando executado ?

Através do comando show_erros que faz parte dos comandos build-in do shell.

Pelo valor escrito em terminal do comando executado.

Através do valor presente na variável $?

Pela mensagem de erro do comando executado.

The correct answer is "Através do valor presente na variável $?". This is because the value of the $? variable in the shell stores the exit status of the previously executed command. By checking the value of this variable, you can determine whether the command was successful or not.

Explanation

The correct answer is "Através do valor presente na variável $?". This is because the value of the $? variable in the shell stores the exit status of the previously executed command. By checking the value of this variable, you can determine whether the command was successful or not.

18. Qual das alternativas abaixo pode ser utilizada para criar uma função chamada "palavra" que contenha as seguintes sequencias de comandos; cd /home/root ; echo "Linha Acrescentada" >> teste_func

palavra() {cd /home/root;echo "Linha Acrescentada" >> teste_func;}

palavra {cd /home/root;echo "Linha Acrescentada" >> teste_func;}

palavra[] {cd /home/rootecho "Linha Acrescentada" >> teste_func;}

N.D.A

The correct answer is the first option, "palavra() { cd /home/root; echo "Linha Acrescentada" >> teste_func; }". This is because it correctly defines a function named "palavra" and includes the desired sequence of commands within the curly braces. The "cd /home/root" command changes the directory to "/home/root", and the "echo "Linha Acrescentada" >> teste_func" command appends the string "Linha Acrescentada" to the file "teste_func".

Explanation

The correct answer is the first option, "palavra() { cd /home/root; echo "Linha Acrescentada" >> teste_func; }". This is because it correctly defines a function named "palavra" and includes the desired sequence of commands within the curly braces. The "cd /home/root" command changes the directory to "/home/root", and the "echo "Linha Acrescentada" >> teste_func" command appends the string "Linha Acrescentada" to the file "teste_func".

19. Qual comando impede que um arquivo seja sobrescrito pelo caracter de redirecionamento > do shell ?

chmod o=-w

set -o noclobber

chattr +A

enable -n

The command "set -o noclobber" prevents a file from being overwritten by the shell redirection character ">". This command sets the noclobber option, which means that if a file already exists, the shell will not overwrite it when using the ">" redirection operator. Instead, it will display an error message. This is useful when you want to avoid accidentally overwriting important files.

Explanation

The command "set -o noclobber" prevents a file from being overwritten by the shell redirection character ">". This command sets the noclobber option, which means that if a file already exists, the shell will not overwrite it when using the ">" redirection operator. Instead, it will display an error message. This is useful when you want to avoid accidentally overwriting important files.

20. Qual o comando incorporado ao shell BASH que lista todos os alias definidos ?

The correct answer is "alias". In the BASH shell, the "alias" command is used to list all the aliases that have been defined. Aliases are shortcuts or alternate names for commands, allowing users to create their own custom commands or abbreviations for frequently used commands. By using the "alias" command, users can see a list of all the aliases they have set up in their BASH shell.

Explanation

The correct answer is "alias". In the BASH shell, the "alias" command is used to list all the aliases that have been defined. Aliases are shortcuts or alternate names for commands, allowing users to create their own custom commands or abbreviations for frequently used commands. By using the "alias" command, users can see a list of all the aliases they have set up in their BASH shell.

Submit

21. Qual é o propósito do arquivo /etc/profile ?

Ele contém variáveis de ambiente que são definidas durante o login dos usuários.

Ele contém perfis de segurança que definem quais usuários têm permissão para fazer login.

Ele contém perfis de aplicação padrão para usuários que executam uma aplicação pela primeira vez.

Ele contém a mensagem de boas-vindas que é exibida após o login.

O arquivo /etc/profile contém variáveis de ambiente que são definidas durante o login dos usuários. Isso significa que ele armazena informações importantes sobre o ambiente de trabalho do usuário, como caminhos de diretório, configurações de idioma e outras variáveis que afetam o comportamento do sistema. Essas variáveis são carregadas durante o processo de login e estão disponíveis para todos os usuários do sistema.

Explanation

O arquivo /etc/profile contém variáveis de ambiente que são definidas durante o login dos usuários. Isso significa que ele armazena informações importantes sobre o ambiente de trabalho do usuário, como caminhos de diretório, configurações de idioma e outras variáveis que afetam o comportamento do sistema. Essas variáveis são carregadas durante o processo de login e estão disponíveis para todos os usuários do sistema.

22. Qual o comando que fecha uma estrutura de seleção case ?

The command "esac" is used to close a case selection structure in shell scripting. The "case" command is used to test a variable against multiple patterns and execute different commands based on the matching pattern. After listing all the patterns and their corresponding commands, the "esac" command is used to indicate the end of the case structure.

Explanation

The command "esac" is used to close a case selection structure in shell scripting. The "case" command is used to test a variable against multiple patterns and execute different commands based on the matching pattern. After listing all the patterns and their corresponding commands, the "esac" command is used to indicate the end of the case structure.

Submit

23. Em qual arquivo posso definir uma variável global que será utilizada por todos os logins do sistema ? (Especifique o caminho completo do arquivo).

The correct answer is /etc/profile. The /etc/profile file is a system-wide configuration file in Unix-like operating systems. It is executed by the login shell for all users upon login. In this file, you can define environment variables that will be available to all users of the system. By setting a variable in this file, it becomes a global variable that can be accessed by any user logging into the system.

Explanation

The correct answer is /etc/profile. The /etc/profile file is a system-wide configuration file in Unix-like operating systems. It is executed by the login shell for all users upon login. In this file, you can define environment variables that will be available to all users of the system. By setting a variable in this file, it becomes a global variable that can be accessed by any user logging into the system.

Submit

24. Qual das opções abaixo pode ser utilizada para remover uma variável chamada LINUX ?

unset $LINUX

unset LINUX

set -r LINUX

unset linux

N.D.A

The correct answer is "unset LINUX". This option can be used to remove a variable called LINUX. The "unset" command is used in Unix-like operating systems to unset or remove a variable from the environment. By specifying the variable name (LINUX) after the "unset" command, the variable is removed from the environment.

Explanation

The correct answer is "unset LINUX". This option can be used to remove a variable called LINUX. The "unset" command is used in Unix-like operating systems to unset or remove a variable from the environment. By specifying the variable name (LINUX) after the "unset" command, the variable is removed from the environment.

25. Qual das opções abaixo pode ser utilizada para tornar a variável LINUX acessível a partir de outros shell (Sub-sequente)?

env LINUX

env $LINUX

export LINUX

export $LINUX

N.D.A

The correct answer is "export LINUX". The "export" command is used to make a variable accessible to other shell processes. By using "export LINUX", the variable LINUX will be available to other shell processes.

Explanation

The correct answer is "export LINUX". The "export" command is used to make a variable accessible to other shell processes. By using "export LINUX", the variable LINUX will be available to other shell processes.

26. Você está olhando para um novo script que você recebeu do administrador sênior. Dentro do script você nota uma linha que inicia com #! seguido por um caminho para um binário. Para esta linha o interpretador de comandos irá:

Ignorar o script.

Usar esse binário para interpretar o script .

Usar esse binário para compilar o script.

Esta linha é somente um comentário.

A linha que começa com #! seguido por um caminho para um binário é chamada de shebang. Essa linha indica qual interpretador de comandos deve ser usado para executar o script. Portanto, a resposta correta é "Usar esse binário para interpretar o script".

Explanation

A linha que começa com #! seguido por um caminho para um binário é chamada de shebang. Essa linha indica qual interpretador de comandos deve ser usado para executar o script. Portanto, a resposta correta é "Usar esse binário para interpretar o script".

27. Qual o valor da variável especial $$ do shell BASH ?

Contém o valor PID do processo em execução.

Contém a versão do BASH em uso.

Contém o tipo de terminal em uso.

Contém o nome do atual script em execução.

A variável especial $$ do shell BASH contém o valor PID do processo em execução.

Explanation

A variável especial $$ do shell BASH contém o valor PID do processo em execução.

28. Qual arquivo do shell BASH é lido após um logout bem sucedido do sistema ?

~/.exit

~/.logout

~/.bash_profile

~/.bash_logout

After successfully logging out of the system, the BASH shell reads the ~/.bash_logout file. This file contains commands or scripts that need to be executed before the user completely logs out of the system. It can be used to clean up temporary files, close connections, or perform any other necessary tasks before the user session ends.

Explanation

After successfully logging out of the system, the BASH shell reads the ~/.bash_logout file. This file contains commands or scripts that need to be executed before the user completely logs out of the system. It can be used to clean up temporary files, close connections, or perform any other necessary tasks before the user session ends.

29. Qual das seguintes palavras é usada para restringir os registros que são retornados de uma consulta SQL SELECT com base em critérios fornecidos para os valores nos registros?

FROM

WHERE

IF

CASE

The word "WHERE" is used in a SQL SELECT statement to restrict the records that are returned based on criteria provided for the values in the records. It allows you to specify conditions that the data must meet in order to be included in the result set.

Explanation

The word "WHERE" is used in a SQL SELECT statement to restrict the records that are returned based on criteria provided for the values in the records. It allows you to specify conditions that the data must meet in order to be included in the result set.

30. Como um processo indica ao shell que encerrou com uma condição de erro?

Imprime uma mensagem de erro em stderr.

Imprime uma mensagem de erro em stdout.

Termina com a variável de código de saída com um valor zero.

Termina com a variável de código de saída com um valor diferente de zero.

Causa uma falta de segmentação.

When a process ends with a condition of error, it indicates this to the shell by terminating with the exit code variable having a value different from zero.

Explanation

When a process ends with a condition of error, it indicates this to the shell by terminating with the exit code variable having a value different from zero.

31. Você quer realizar uma pesquisa em uma base recorrente executando uma série de comandos. Você irá definir a série de comandos disponíveis a partir do início de sua sessão para executar no shell atual. Escolha a melhor solução:

Criar um programa shell.

Criar uma função.

Usar a seta para cima em seu terminal para encontrar os comandos.

Usar o built-in do Bash! função a ser executada na última iteração do comando pelo mesmo nome.

A melhor solução é criar uma função. Isso permitirá que você defina uma série de comandos que serão executados em sequência sempre que você chamar essa função. Dessa forma, você pode reutilizar essa função sempre que precisar executar a mesma série de comandos, tornando o processo mais eficiente e automatizado.

Explanation

A melhor solução é criar uma função. Isso permitirá que você defina uma série de comandos que serão executados em sequência sempre que você chamar essa função. Dessa forma, você pode reutilizar essa função sempre que precisar executar a mesma série de comandos, tornando o processo mais eficiente e automatizado.

32. Qual arquivo será usado para configurar o shell bash interativo de um usuário?

~/.int_bash

.bashrc

.profile

.bash

The correct answer is .bashrc. This file is used to configure the interactive shell for a user in the bash environment. It contains settings and configurations specific to the user's shell session, such as aliases, environment variables, and shell options. When a user logs in or opens a new shell, the .bashrc file is automatically executed, allowing the user to customize their shell environment according to their preferences.

Explanation

The correct answer is .bashrc. This file is used to configure the interactive shell for a user in the bash environment. It contains settings and configurations specific to the user's shell session, such as aliases, environment variables, and shell options. When a user logs in or opens a new shell, the .bashrc file is automatically executed, allowing the user to customize their shell environment according to their preferences.

33. Supondo que você deseje remover um alias chamado ipconfig. Escreva a linha de comando completa para realizar esta tarefa.

The given command "unalias ipconfig" is used to remove an alias called "ipconfig". An alias is a shortcut or alternate name for a command. By running this command, the alias "ipconfig" will be removed and the original command or function it represents will be used instead.

Explanation

The given command "unalias ipconfig" is used to remove an alias called "ipconfig". An alias is a shortcut or alternate name for a command. By running this command, the alias "ipconfig" will be removed and the original command or function it represents will be used instead.

Submit

34. Observe o seguinte script (test.sh) conforme a figura abaixo. Qual será o resultado exibido para o usuário após a execução do script com o seguinte argumento; sh test.sh /bin ?

Este script não pode ser executado.

Não será exibido nenhuma mensagem ao usuário.

0

1

The correct answer is 0.

Explanation

The correct answer is 0.

35. Escrevendo um shellscript você deseja verificar a existência do arquivo foobar e verificar se o mesmo é uma arquivo regular. Qual dos seguintes comandos de teste irá verificar a existência deste arquivo (foobar)?

test -d foobar

test -e foobar

test -b foobar

test -x foobar

test -f foobar

The correct answer is "test -f foobar". This command will check if the file "foobar" exists and if it is a regular file. The "-f" option is used to test if the given file is a regular file.

Explanation

The correct answer is "test -f foobar". This command will check if the file "foobar" exists and if it is a regular file. The "-f" option is used to test if the given file is a regular file.

36. A variável REPLY é utilizada por qual comando quando não definimos uma ?

set

read

goto

if

The variable "REPLY" is used by the "read" command when we do not define a specific variable to store the input. The "read" command is used to take input from the user in a shell script, and if no variable is specified, the input is stored in the default variable "REPLY".

Explanation

The variable "REPLY" is used by the "read" command when we do not define a specific variable to store the input. The "read" command is used to take input from the user in a shell script, and if no variable is specified, the input is stored in the default variable "REPLY".

37. Qual dos seguintes comandos devem ser adicionados ao /etc/bash_profile a fim de mudar o idioma das mensagens para um programa internacionalizado para Português(pt)?

export UI_MESSAGES="pt"

export ALL_MESSAGES="pt"

export LC_MESSAGES="pt"

export MESSAGE="pt"

export LANGUAGE="pt"

The correct answer is "export LC_MESSAGES="pt"". This command sets the LC_MESSAGES environment variable to "pt", indicating that the language for program messages should be changed to Portuguese (pt). By exporting this variable in the /etc/bash_profile file, the change will be applied system-wide, ensuring that all programs using internationalization will display messages in Portuguese.

Explanation

The correct answer is "export LC_MESSAGES="pt"". This command sets the LC_MESSAGES environment variable to "pt", indicating that the language for program messages should be changed to Portuguese (pt). By exporting this variable in the /etc/bash_profile file, the change will be applied system-wide, ensuring that all programs using internationalization will display messages in Portuguese.

38. Qual a diferença entre os comandos SET e ENV ?

SET exibe variáveis do shell corrente e ENV exibe todas as variáveis inclusive as que foram exportadas.

SET define uma variável para ser utilizada e ENV exibe todas as variáveis do Shell.

SET exibe variáveis exportadas e ENV somente as do shell ambiente.

SET e ENV possuem a mesma função. Ambos foram compilados pelo GCC.

SET and ENV are two different commands used in shell scripting. The SET command displays variables specific to the current shell session, while ENV displays all variables, including those that have been exported. Therefore, the correct answer is that SET displays variables from the current shell session, and ENV displays all variables, including exported ones. The other options provided in the question are incorrect.

Explanation

SET and ENV are two different commands used in shell scripting. The SET command displays variables specific to the current shell session, while ENV displays all variables, including those that have been exported. Therefore, the correct answer is that SET displays variables from the current shell session, and ENV displays all variables, including exported ones. The other options provided in the question are incorrect.

39. Para qual tarefa você precisará usar o operador BETWEEN?

Consulta de tabelas com valores desconhecidos.

Consulta de tabelas para uma faixa de valores.

Consulta de tabelas para um tipo de caracte.

Consulta de tabelas para valores específicos de uma lista.

O operador BETWEEN é usado para consultar tabelas para uma faixa de valores. Isso significa que você pode usar o operador BETWEEN para recuperar registros de uma tabela onde um determinado valor está dentro de um intervalo específico. Por exemplo, se você quiser selecionar todos os registros de uma tabela onde o valor de uma coluna esteja entre 10 e 20, você pode usar o operador BETWEEN para realizar essa consulta.

Explanation

O operador BETWEEN é usado para consultar tabelas para uma faixa de valores. Isso significa que você pode usar o operador BETWEEN para recuperar registros de uma tabela onde um determinado valor está dentro de um intervalo específico. Por exemplo, se você quiser selecionar todos os registros de uma tabela onde o valor de uma coluna esteja entre 10 e 20, você pode usar o operador BETWEEN para realizar essa consulta.

40. Digite o caminho completo e o nome do arquivo de configuração global onde geralmente contém o sistema de configuração PATH, umask e ulimit:

The correct answer is "/etc/profile". This is because the file "/etc/profile" is the standard location for the global configuration file that contains system-wide configuration settings such as the PATH, umask, and ulimit. By editing this file, administrators can set environment variables and define system-wide behavior for all users on the system.

Explanation

The correct answer is "/etc/profile". This is because the file "/etc/profile" is the standard location for the global configuration file that contains system-wide configuration settings such as the PATH, umask, and ulimit. By editing this file, administrators can set environment variables and define system-wide behavior for all users on the system.

Submit

41. Qual das seguintes alternativas são requisitos, a fim de executar um shell script como um comando regular a partir de qualquer lugar no sistema de arquivos? (Escolha três respostas corretas).

O usuário que emitir o comando deve pertencer ao grupo do proprietário do script.

O arquivo de script deve ser encontrado no $PATH.

O sistema de arquivos no qual reside o script deve ser montado com os scripts de opção.

O script deve começar com uma shebang-line ( # ! ) Que aponta para o interpretador de comandos correto.

O arquivo de script deve ter permissão de execução.

To execute a shell script as a regular command from anywhere in the file system, the following requirements must be met:
1) The script file must be located in the $PATH, which is the list of directories where the system looks for executable files.
2) The script must start with a shebang-line ( # ! ) that specifies the correct interpreter for the commands in the script.
3) The script file must have execute permission, allowing it to be run as a command.

Explanation

To execute a shell script as a regular command from anywhere in the file system, the following requirements must be met:
1) The script file must be located in the $PATH, which is the list of directories where the system looks for executable files.
2) The script must start with a shebang-line ( # ! ) that specifies the correct interpreter for the commands in the script.
3) The script file must have execute permission, allowing it to be run as a command.

Submit

42. Qual comando pode ser utilizado para listar as funções definidas em um shell bash?

The correct answer is "typeset -f, declare -f, set". These commands can be used to list the functions defined in a bash shell. The "typeset -f" command lists all the function names and their definitions. The "declare -f" command also lists the function names and their definitions. The "set" command displays all the shell functions along with other shell variables and environment variables.

Explanation

The correct answer is "typeset -f, declare -f, set". These commands can be used to list the functions defined in a bash shell. The "typeset -f" command lists all the function names and their definitions. The "declare -f" command also lists the function names and their definitions. The "set" command displays all the shell functions along with other shell variables and environment variables.

Submit

43. Qual das instruções abaixo é uma instrução SQL SELECT válida ?

SELECT nome, telefone FROM contatos;

SELECT FROM contatos nome, telefone;

SELECT nome FROM contatos, telefone;

SELECT contatos FROM nome, telefone;

The correct answer is "SELECT nome, telefone FROM contatos;". This is a valid SQL SELECT statement because it selects the columns "nome" and "telefone" from the table "contatos".

Explanation

The correct answer is "SELECT nome, telefone FROM contatos;". This is a valid SQL SELECT statement because it selects the columns "nome" and "telefone" from the table "contatos".

44. Você está criando um script em que precisa testar se um comando foi executado corretamente. Como você testa corretamente o "exit status" do comando executado?

if [ "$#" -eq "0" ]

if [ "$?" -eq "0" ]

if [ "$#" == 0 ]

if [ "$?" == "0"]

if [ $@ -eq 0 ]

The correct answer is "if [ "$?" -eq "0" ]". In shell scripting, the "$?" variable holds the exit status of the previously executed command. By comparing it to "0" using the "-eq" operator, we can determine if the command executed successfully.

Explanation

The correct answer is "if [ "$?" -eq "0" ]". In shell scripting, the "$?" variable holds the exit status of the previously executed command. By comparing it to "0" using the "-eq" operator, we can determine if the command executed successfully.

45. Qual dos seguintes comandos lista todas as variáveis e funções definidas dentro do Bash ?

set

env -a

env

echo $ENV

The "set" command lists all the variables and functions defined within the Bash environment.

Explanation

The "set" command lists all the variables and functions defined within the Bash environment.

46. Qual das opções abaixo pode ser utilizada para listar apenas o primeiro valor da array FRUTAS?

echo $FRUTAS(1)

echo ${FRUTAS[1]}

echo ${FRUTAS[0]}

N.D.A

The correct answer is "echo ${FRUTAS[0]}". In Bash, arrays are zero-indexed, so the first element of the array FRUTAS can be accessed using the syntax ${FRUTAS[0]}. The options "echo $FRUTAS(1)" and "echo ${FRUTAS[1]}" would access the second element of the array, not the first.

Explanation

The correct answer is "echo ${FRUTAS[0]}". In Bash, arrays are zero-indexed, so the first element of the array FRUTAS can be accessed using the syntax ${FRUTAS[0]}. The options "echo $FRUTAS(1)" and "echo ${FRUTAS[1]}" would access the second element of the array, not the first.

47. De acordo com as informações fornecidas abaixo escreva a instrução SQL que irá listar o nome e o artista de todas músicas cadastradas.

The given SQL query is correct and will retrieve the name and artist of all registered songs from the "Musicas" table. It uses the "select" statement to specify the columns to be included in the result, which are "Nome" (name) and "Artista" (artist). The "from" keyword is used to indicate the table from which the data should be retrieved, which is "Musicas" in this case.

Explanation

The given SQL query is correct and will retrieve the name and artist of all registered songs from the "Musicas" table. It uses the "select" statement to specify the columns to be included in the result, which are "Nome" (name) and "Artista" (artist). The "from" keyword is used to indicate the table from which the data should be retrieved, which is "Musicas" in this case.

Submit

48. Sobre os operadores de comparação numérica do comando test. Associe:

-eq

-ge

-gt

-le

-lt

-ne

Submit

49. Considerando a consulta abaixo, o que é mostrado na coluna SALARY quando um valor NULL é retornado?

0

NULL

SPACES

nothing

Quando um valor NULL é retornado, o que é mostrado na coluna SALARY é o valor 0.

Explanation

Quando um valor NULL é retornado, o que é mostrado na coluna SALARY é o valor 0.

50. Ao escrever um script, o que você precisa para criar um loop, recebendo uma lista de variáveis, onde as declarações a serem realizadas são encontradas entre as palavras-chave _______ e done.

To create a loop in a script, the keyword "do" is used to indicate the beginning of the loop block, and the keyword "done" is used to indicate the end of the loop block. The statements to be executed within the loop are written between these two keywords.

Explanation

To create a loop in a script, the keyword "do" is used to indicate the beginning of the loop block, and the keyword "done" is used to indicate the end of the loop block. The statements to be executed within the loop are written between these two keywords.

Submit

51. Supondo que você deseje criar um alias chamado ipconfig a fim de executar o comando ifconfig. Escreva a linha de comando completa para realizar esta tarefa.

The given correct answer suggests that in order to create an alias called "ipconfig" to execute the command "ifconfig", the complete command to perform this task is either "alias ipconfig="ifconfig"" or "alias ipconfig='ifconfig'". Both of these commands will create an alias named "ipconfig" that will execute the "ifconfig" command when invoked.

Explanation

The given correct answer suggests that in order to create an alias called "ipconfig" to execute the command "ifconfig", the complete command to perform this task is either "alias ipconfig="ifconfig"" or "alias ipconfig='ifconfig'". Both of these commands will create an alias named "ipconfig" that will execute the "ifconfig" command when invoked.

Submit

52. Em um comando SELECT, qual cláusula poderá ser usada para excluir linhas, antes de agrupá-las?

INTO

WHERE

HAVING

ORDER BY

The WHERE clause in a SELECT statement can be used to filter and exclude specific rows before grouping them. It allows you to specify conditions that the rows must meet in order to be included in the result set. By using the WHERE clause, you can effectively eliminate certain rows from the query result before applying any grouping operations.

Explanation

The WHERE clause in a SELECT statement can be used to filter and exclude specific rows before grouping them. It allows you to specify conditions that the rows must meet in order to be included in the result set. By using the WHERE clause, you can effectively eliminate certain rows from the query result before applying any grouping operations.

53. Sobre os operadores de comparação de strings do comando test. Associe:

==

!=

>

-n

-z

Submit

54. O comando seq -w -s ';' 2 12 exibe qual resultado em tela ?

0;2;4;6;8;10;12

02;03;04;05;06;07;08;09;10;11;12

2;3;4;5;6;7;8;9;10;11;12

02;03;04;05;06;07;08;09;010;011;012

The command "seq -w -s ';' 2 12" will display the numbers from 2 to 12 with leading zeros and separated by semicolons. Therefore, the correct answer is "02;03;04;05;06;07;08;09;10;11;12".

Explanation

The command "seq -w -s ';' 2 12" will display the numbers from 2 to 12 with leading zeros and separated by semicolons. Therefore, the correct answer is "02;03;04;05;06;07;08;09;10;11;12".

55. Qual das opções abaixo pode ser utilizada para listar todos os índices/valores da array FRUTAS?

echo $FRUTAS

echo ${FRUTAS[*]}

echo$(FRUTAS)

N.D.A

The correct answer is "echo ${FRUTAS[*]}". This syntax is used to list all the indices/values of the array FRUTAS. By using ${FRUTAS[*]}, the echo command will display all the elements in the array.

Explanation

The correct answer is "echo ${FRUTAS[*]}". This syntax is used to list all the indices/values of the array FRUTAS. By using ${FRUTAS[*]}, the echo command will display all the elements in the array.

56. Na ordem de escrita de uma query, a cláusula order by deve vir depois de qual cláusula abaixo?

GROUP BY

WHERE

HAVING

FROM

A cláusula ORDER BY deve vir depois da cláusula WHERE na ordem de escrita de uma query. A cláusula WHERE é usada para filtrar os registros que atendem a determinada condição, enquanto a cláusula ORDER BY é usada para ordenar os registros resultantes da consulta de acordo com uma determinada coluna. Portanto, primeiro é necessário filtrar os registros com a cláusula WHERE e, em seguida, ordená-los com a cláusula ORDER BY.

Explanation

A cláusula ORDER BY deve vir depois da cláusula WHERE na ordem de escrita de uma query. A cláusula WHERE é usada para filtrar os registros que atendem a determinada condição, enquanto a cláusula ORDER BY é usada para ordenar os registros resultantes da consulta de acordo com uma determinada coluna. Portanto, primeiro é necessário filtrar os registros com a cláusula WHERE e, em seguida, ordená-los com a cláusula ORDER BY.

57. A instrução if [ -n "$NOME"]; then ... será verdadeira se

A variável $NOME contiver um número.

A variável $NOME possuir um ou mais caracteres.

A variável $NOME for nula.

Essa instrução nunca será verdadeira.

The correct answer is "A variável $NOME possuir um ou mais caracteres." This is because the condition "-n $NOME" checks if the variable $NOME is not empty, meaning it has one or more characters. If the variable is not empty, the condition will be true.

Explanation

The correct answer is "A variável $NOME possuir um ou mais caracteres." This is because the condition "-n $NOME" checks if the variable $NOME is not empty, meaning it has one or more characters. If the variable is not empty, the condition will be true.

58. Qual a ordem correta de leitura dos arquivos de configuração do BASH após um login bem sucedido ?

1. ~/.bashrc 2. /etc/profile 3. /etc/bashrc 4. ~/.bash_profile

1. /etc/profile 2. /etc/bashrc 3. ~/.bashrc 4. ~/.bash_profile

1. ~/.bash_profile 2. /etc/profile 3. ~/.bashrc 4. /etc/bashrc

1. /etc/profile 2. ~/.bash_profile 3. ~/.bashrc 4. /etc/bashrc

After a successful login, the BASH configuration files are read in the following order: /etc/profile, ~/.bash_profile, ~/.bashrc, and /etc/bashrc.

Explanation

After a successful login, the BASH configuration files are read in the following order: /etc/profile, ~/.bash_profile, ~/.bashrc, and /etc/bashrc.

59. Quais os dois arquivos agindo em conjunto compõem o ambiente de login de um usuário em uma instalação padrão do Linux?

/etc/profile

/etc/.login

/etc/bashrc

~/.bash_profile

/etc/.profile

The correct answer is /etc/profile and ~/.bash_profile. In a standard Linux installation, these two files work together to compose the user's login environment. The /etc/profile file contains system-wide environment variables and settings that are applied to all users. The ~/.bash_profile file is a user-specific file that allows customization of the user's login environment, such as setting user-specific environment variables and executing specific commands upon login. These two files work in conjunction to provide a personalized login environment for each user.

Explanation

The correct answer is /etc/profile and ~/.bash_profile. In a standard Linux installation, these two files work together to compose the user's login environment. The /etc/profile file contains system-wide environment variables and settings that are applied to all users. The ~/.bash_profile file is a user-specific file that allows customization of the user's login environment, such as setting user-specific environment variables and executing specific commands upon login. These two files work in conjunction to provide a personalized login environment for each user.

Submit

60. Normalmente nós definimos funções e aliases particular de nosso login em qual arquivo ?

~/.bash_login

~/.bash_profile

~/.bashrc

~/.profile

The correct answer is ~/.bashrc. This is because ~/.bashrc is the file where we typically define functions and aliases specific to our login in a Bash shell environment. The other options mentioned are also valid files for defining login-specific configurations, but ~/.bashrc is the most commonly used one.

Explanation

The correct answer is ~/.bashrc. This is because ~/.bashrc is the file where we typically define functions and aliases specific to our login in a Bash shell environment. The other options mentioned are also valid files for defining login-specific configurations, but ~/.bashrc is the most commonly used one.

61. De acordo com as informações fornecidas abaixo escreva a instrução SQL que irá listar os campos nome e data da compra dos cds classificados por data de compra em ordem decrescente.

The given answer is correct because it follows the correct syntax for selecting the fields "Nome" and "DataCompra" from the table "Cds" and ordering the results by the "DataCompra" field in descending order. This will list the names and purchase dates of the CDs in descending order based on the purchase date.

Explanation

The given answer is correct because it follows the correct syntax for selecting the fields "Nome" and "DataCompra" from the table "Cds" and ordering the results by the "DataCompra" field in descending order. This will list the names and purchase dates of the CDs in descending order based on the purchase date.

Submit

62. Quais valores serão mostrados na consulta abaixo?

Somentenomes de tabelas suas.

Somente nomes de objetosseus.

Somente nomes de todosos objetos que você possui acesso.

Somente nomes de todastabelas que você possui acesso.

The correct answer is "Somente nomes de todas tabelas que você possui acesso." This means that the query will only display the names of all the tables that you have access to.

Explanation

The correct answer is "Somente nomes de todas tabelas que você possui acesso." This means that the query will only display the names of all the tables that you have access to.

63. Qual das opções abaixo pode ser utilizada para adicionar um novo valor no índice 3 (4° valor) na array FRUTAS?

FRUTAS[3]=uva

FRUTAS[4]=uva

FRUTAS{(3)=uva}

N.D.A

The correct answer is "FRUTAS[3]=uva" because it uses the correct syntax for adding a new value to the 4th index (3rd value) in the array FRUTAS. The other options either have incorrect syntax or use the wrong index to add the value "uva".

Explanation

The correct answer is "FRUTAS[3]=uva" because it uses the correct syntax for adding a new value to the 4th index (3rd value) in the array FRUTAS. The other options either have incorrect syntax or use the wrong index to add the value "uva".

64. De acordo com as informações fornecidas abaixo escreva a instrução SQL que irá listar todas as músicas (todos os campos) do cd de código 1.

The correct answer includes all the possible variations of the SQL query that will list all the songs (all fields) from the CD with code 1. The variations include using both numeric (1) and string ('1') representations of the code, as well as using both single quotes ('') and backticks (`) for the string representation. This ensures that the query will work regardless of the data type used for the CodigoCd column in the database.

Explanation

The correct answer includes all the possible variations of the SQL query that will list all the songs (all fields) from the CD with code 1. The variations include using both numeric (1) and string ('1') representations of the code, as well as using both single quotes ('') and backticks (`) for the string representation. This ensures that the query will work regardless of the data type used for the CodigoCd column in the database.

Submit

65. Qual o significado do seguinte teste condicional:

A variável $resultado não recebendo nenhum valor, será exibida pelo comando echo.

O teste condicional retorna VERDADEIRO fazendo com que o comando echo exiba seu valor.

O teste não é executado pois existe um erro de sintaxe.

A variável $resultado não será exibida pelo comando echo.

The correct answer is "A variável $resultado não será exibida pelo comando echo." because the conditional test is evaluating if the variable $resultado is not receiving any value. Since it is not receiving any value, the conditional test will return true, and as a result, the command echo will not display the variable's value.

Explanation

The correct answer is "A variável $resultado não será exibida pelo comando echo." because the conditional test is evaluating if the variable $resultado is not receiving any value. Since it is not receiving any value, the conditional test will return true, and as a result, the command echo will not display the variable's value.

66. Escrevendo um shellscript você deseja verificar a existência do arquivo foobar e se o mesmo é de propriedade do usuário que executa o script. Qual das seguintes alternativas irá verificar isso?

test -e foobar

test -r foobar

test -b foobar

test -o foobar

test -O foobar

The correct answer is "test -O foobar". This command checks if the file "foobar" exists and if it is owned by the user who is executing the script.

Explanation

The correct answer is "test -O foobar". This command checks if the file "foobar" exists and if it is owned by the user who is executing the script.

67. Onde são definidos aliases de linha de comando para um usuário ? Digite o caminho completo e o nome do arquivo para o usuário conectado no momento.

The aliases for command line are defined in the file ~/.bashrc. This file is specific to the user currently connected and it contains various settings and configurations for the Bash shell. By editing this file, users can define their own custom aliases for commands, making it easier to execute frequently used commands or to create shortcuts for longer commands.

Explanation

The aliases for command line are defined in the file ~/.bashrc. This file is specific to the user currently connected and it contains various settings and configurations for the Bash shell. By editing this file, users can define their own custom aliases for commands, making it easier to execute frequently used commands or to create shortcuts for longer commands.

Submit

68. Qual das opções abaixo pode ser utilizada para criar uma array chamada FRUTAS?

FRUTAS=[laranja banana maçã]

FRUTAS={laranja banana maçã}

FRUTAS=(laranja banana maçã)

FRUTAS='laranja banana maçã'

The correct answer is "FRUTAS=(laranja banana maçã)". This is because when creating an array in programming, the syntax in this case would use parentheses "( )" to enclose the elements of the array. The other options provided, such as using square brackets "[ ]", curly brackets "{ }", or single quotes "'", are not the correct syntax for creating an array in this programming language.

Explanation

The correct answer is "FRUTAS=(laranja banana maçã)". This is because when creating an array in programming, the syntax in this case would use parentheses "( )" to enclose the elements of the array. The other options provided, such as using square brackets "[ ]", curly brackets "{ }", or single quotes "'", are not the correct syntax for creating an array in this programming language.

69. De acordo com as informações fornecidas abaixo escreva a instrução SQL que irá listar todos os CDs.

The given answer is already the correct SQL statement to list all the CDs. It selects all columns from the table "cds", which will display all the records in the table.

Explanation

The given answer is already the correct SQL statement to list all the CDs. It selects all columns from the table "cds", which will display all the records in the table.

Submit

70. Temos o bash script "~/myscript" mostrado de acordo com a figura. Ao executar o script comforme a seguir: "./myscript alfa beta gamma delta" O que será mostrado no stdout?

alfa

beta

gamma

delta

When the script is executed with the given command "./myscript alfa beta gamma delta", it will display "gamma" on the stdout. This is because the script is using the positional parameters "$3" to access the third argument passed to it, which is "gamma". Hence, "gamma" will be printed as the output.

Explanation

When the script is executed with the given command "./myscript alfa beta gamma delta", it will display "gamma" on the stdout. This is because the script is using the positional parameters "$3" to access the third argument passed to it, which is "gamma". Hence, "gamma" will be printed as the output.

71. De acordo com as informações fornecidas abaixo escreva a instrução SQL que irá Mostrar uma listagem do nome de todas as músicas cadastradas em ordem alfabética.

The given SQL statement selects the column "Nome" from the table "Musicas" and orders the result in alphabetical order based on the "Nome" column. This will display a listing of the names of all the registered songs in alphabetical order.

Explanation

The given SQL statement selects the column "Nome" from the table "Musicas" and orders the result in alphabetical order based on the "Nome" column. This will display a listing of the names of all the registered songs in alphabetical order.

Submit

72. De acordo com as informações fornecidas abaixo escreva a instrução SQL que irá listar os campos nome e data da compra dos cds ordenados por nome.

The given SQL statement is correct and will list the fields "Nome" and "DataCompra" from the table "Cds" in ascending order of the "Nome" field.

Explanation

The given SQL statement is correct and will list the fields "Nome" and "DataCompra" from the table "Cds" in ascending order of the "Nome" field.

Submit

73. Para qual tarefa será mais apropriado usar o comando DISTINCT?

Identificar linhas duplicadas na tabela.

Identificar quais colunas possuem dados únicos.

Eliminar colunas duplicadas na tabela.

Eliminar linhas duplicadas no resultado.

O comando DISTINCT é mais apropriado para eliminar linhas duplicadas no resultado. Quando usado em uma consulta, o comando DISTINCT garante que apenas uma instância de cada valor único seja retornado, eliminando assim as linhas duplicadas.

Explanation

O comando DISTINCT é mais apropriado para eliminar linhas duplicadas no resultado. Quando usado em uma consulta, o comando DISTINCT garante que apenas uma instância de cada valor único seja retornado, eliminando assim as linhas duplicadas.

74. Quais as duas cláusulas contém uma subquery? (Escolha duas opções).

WHERE

SELECT

HAVING

ORDER BY

GROUP BY

The correct answer is WHERE and HAVING. These two clauses in a SQL query allow for the inclusion of subqueries, which are queries nested within the main query. The WHERE clause is used to filter the rows returned by the query based on specified conditions, and it can include a subquery to further refine the results. The HAVING clause is used to filter the results of a GROUP BY query based on specified conditions, and it can also include a subquery to further filter the grouped data.

Explanation

The correct answer is WHERE and HAVING. These two clauses in a SQL query allow for the inclusion of subqueries, which are queries nested within the main query. The WHERE clause is used to filter the rows returned by the query based on specified conditions, and it can include a subquery to further refine the results. The HAVING clause is used to filter the results of a GROUP BY query based on specified conditions, and it can also include a subquery to further filter the grouped data.

Submit

75. Qual das opções abaixo irá remover o valor da array FRUTAS na posição/índice 3?

set -r $FRUTAS[3]

unset ${FRUTAS[3]}

unset FRUTAS(3)

unset FRUTAS[3]

The correct answer is "unset FRUTAS[3]". This command will remove the value at index 3 in the array FRUTAS. The "unset" command is used to unset or remove a variable or array element, and the syntax for unsetting an array element is "unset array[index]". Therefore, "unset FRUTAS[3]" will remove the value at index 3 in the FRUTAS array.

Explanation

The correct answer is "unset FRUTAS[3]". This command will remove the value at index 3 in the array FRUTAS. The "unset" command is used to unset or remove a variable or array element, and the syntax for unsetting an array element is "unset array[index]". Therefore, "unset FRUTAS[3]" will remove the value at index 3 in the FRUTAS array.

76. Um usuário deseja modificar sua variável de ambiente PATH, o arquivo que você deve dizer-lhe para editar em seu diretório home. Escreva somente o nome, nenhum caminho.

The correct answer is ".bash_profile". The user wants to modify their PATH environment variable, and they should edit the ".bash_profile" file in their home directory. This file is responsible for setting up the user's environment when they log in, including defining variables like PATH.

Explanation

The correct answer is ".bash_profile". The user wants to modify their PATH environment variable, and they should edit the ".bash_profile" file in their home directory. This file is responsible for setting up the user's environment when they log in, including defining variables like PATH.

Submit

77. De acordo com as informações fornecidas abaixo escreva a instrução SQL que irá listar todos os cds que são albuns.

The correct answer is any of the options that include "select * from Cds where Album=true;" or "select * from Cds where Album='true';". These options use the correct syntax to filter the Cds table and retrieve only the rows where the Album column is true. The other options use incorrect syntax such as using backticks (`) or double quotes (") instead of single quotes (') to enclose the true value.

Explanation

The correct answer is any of the options that include "select * from Cds where Album=true;" or "select * from Cds where Album='true';". These options use the correct syntax to filter the Cds table and retrieve only the rows where the Album column is true. The other options use incorrect syntax such as using backticks (`) or double quotes (") instead of single quotes (') to enclose the true value.

Submit

78. Em qual arquivo posso definir o diretório /opt/bin como sendo parte dos valores de pesquisa da variável PATH ?

/etc/profile

~/.profile

~/.bash_login

~/.bashrc

As the question asks about the file where the directory /opt/bin can be defined as part of the search values of the PATH variable, the correct answer is /etc/profile, ~/.profile, and ~/.bash_login. These files are commonly used in Unix-like systems to set environment variables, including the PATH variable. The /etc/profile file is a system-wide configuration file, while ~/.profile and ~/.bash_login are user-specific configuration files. By adding the directory /opt/bin to any of these files, the system will include it in the search path when looking for executable files.

Explanation

As the question asks about the file where the directory /opt/bin can be defined as part of the search values of the PATH variable, the correct answer is /etc/profile, ~/.profile, and ~/.bash_login. These files are commonly used in Unix-like systems to set environment variables, including the PATH variable. The /etc/profile file is a system-wide configuration file, while ~/.profile and ~/.bash_login are user-specific configuration files. By adding the directory /opt/bin to any of these files, the system will include it in the search path when looking for executable files.

Submit

79. De acordo com as informações fornecidas abaixo escreva a instrução SQL que irá listar o cd que custou mais caro.

The given SQL statement is selecting the maximum value of the column "ValorPago" from the table "Cds". This means that it will retrieve the CD that has the highest price among all the CDs in the table.

Explanation

The given SQL statement is selecting the maximum value of the column "ValorPago" from the table "Cds". This means that it will retrieve the CD that has the highest price among all the CDs in the table.

Submit

80. Sobre a comparação de arquivos e diretórios utilizando o comando test. Associe:

-d

-e

-f

-r

-s

-w

-x

-O

-G

-L ou -h

arq1 -nt arq2

arq1-ot arq2

Submit