搜题

【多选题】

A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ.<br /> Which two will optimize the security of this setup?（）<br />

A、Disabling connections from named pipes or socket files (depending on the operating system of the server)

B、Enabling and using SSL for connections to the Mysql database

C、Installing Mysql on the application server, and running the database and application on the same server

D、Starting the server with – bind- address=0.0.0.0 specified

E、Running the server with – skip-networking specified

F、Limiting logins to originate from the application server or the server's subnet'

查看正确答案

更多“ A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ.<br /> Which two will optimize the security of this setup?（）<br /> ”相关的问题

第1题

[单选题] MySQL is installed on a Linux server and has the following configuration: What is the purpose of changing ownership of datadir to the ‘mysql’ user?（）

A、MySQL requires correct file ownership while remaining secure B、MySQL needs to be run as the root user, but file cannot be owned by it C、MySQL cannot be run as the root user

点击查看答案

第2题

[多选题] Which two statements are true regarding an Automatic Storage Management (ASM) instance?（） (Choose two.)

A、As ASM instance mounts an ASM control file B、An ASM instance uses the ASMB process for rebalancing of disks within a disk group C、Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly D、An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

点击查看答案

第3题

[单选题] You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions. C: \＞ mysqld – install Mysql56 – defaults – file = C :\my –opts.cnf What is the expected outcome?（）

A、Mysql is installed as the Windows service name Mysql56, and uses c: \my-opts.cnf as the configuration file B、An error message is issued because – install is not a valid option for mysqld C、A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: \my-opts.cnf D、Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: \my-opts.cnf configuration file

点击查看答案

第4题

[] Which two statements are true regarding an Automatic Storage Management (ASM) instance? （）

A、A. As ASM instance mounts an ASM control file B、B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group C、C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly D、D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

点击查看答案

第5题

[单选题] You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance : SQL> shutdown immediate; What is the result of executing this command?（）

A、The ASM instance is shut down, but the other instances are still running. B、It results in an error because other database instances are connected to it. C、All the instances, including the ASM instance, are shut down in the IMMEDIATE mode. D、HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.

点击查看答案

第6题

[单选题] A user executes the statement; PURGE BINARY LOGS TO 'mysql-bin.010'; What is the result?（）

A、It deletes all binary log files, except 'mysql-in.010' B、It deletes all binary log files up to and including 'mysql-bin.010' C、It deletes all binary log files before 'mysql-bin.010' D、It deletes all binary log files after 'mysql-bin.010'

点击查看答案

第7题

[单选题] You use—login-path to access a MySQL server on a Linux installation. Which statement is true about the – login-path option that is created by using mysql_config_editor?（）

A、All system users have access to the MySQL server via—login path local B、login-path can be used only for MySQL servers running on a local machine C、login-path allows you to provide login credentials without passing clear text passwords on the command line D、When using – login-path to connect to a remote MySQL server, the remote server version must be 5.6 or later

点击查看答案

第8题

[单选题] You have been assigned to manage a set of databases. The previous DBA did not leave you notes regarding the structure of each of the databases. While analyzing an instance， you notice that the system identifier （SID） for the instance is set to ’+ASM’. What is the purpose of this instance？（）

A、 This instance is being used to manage the operating system files. B、 This instance is being used to manage the files of other databases. C、 This instance is being used to manage the instances of other databases. D、 This instance is being used to manage the background processes of other instances.

点击查看答案

第9题

[单选题] 关于mysql_db_query与mysql_query说法正确的是：（）

A、mysql_db_query与mysql_query在执行sql语句后的返回值是一样的，成功返回资源号，失败返回FALSE B、不能用mysql_query函数临时在另一个数据库上执行sql语句，而mysql_db_query可以 C、mysql_db_query不会切换回先前连接到的数据库 D、mysql_query在功能上等于mysql_select_db（）+mysql_db_query（）

点击查看答案

账号：登录

答题记录

我的收藏

我的题库

客服

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服