Disabling connections from named pipes or socket files (depending on the operating system of the server)
Enabling and using SSL for connections to the Mysql database
Installing Mysql on the application server, and running the database and application on the same server
Starting the server with – bind- address=0.0.0.0 specified
Running the server with – skip-networking specified
Limiting logins to originate from the application server or the server's subnet'
第1题:
Mysqldump was used to create a single schema backup; Shell> mysqldump –u root –p sakila > sakila2013.sqlWhich two commands will restore the sakila database without interfering with other running database?()
A.Mysql> USE sakila; LOAD DATA INFILE ‘sakila2013.sql‘;
B.Shell> mysql –u root –p sakila sakila2013.sql
C.Shell> mysql import –u root –p sakila sakila2013.sql
D.Shell> mysql –u root -p –e ‘use sakila; source sakila2013.sql‘
E.Shell> mysql –u root –p –silent < sakila2013.sql
第2题:
Multiple users are trying to telnet to the AIX server. They are able to ping the server successfully, but are getting the following error message: telnet: connect: A remote host refused an attempted connect operation Which of the following could be the cause of this problem?()
第3题:
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.
第4题:
A medium-sized company with 500 employees has a rapidly growing storage infrastructure with clustered mail, database, and file and print core business applications running on six servers. Using current direct attached SCSI storage pools to each server leads to inefficient utilization of storage space.They also have a backup device attached to each server. They want to consolidate their storage and backup infrastructure into a scalable, high availability and high performance solution. The customer’s top priorities are performance, cost, and availability. Which of the following backup solutions best satisfies the customer requirements?()
第5题:
Which of the following is a correct statement about Workload Partitions (WPARs)?()
第6题:
Mysqldump was used to create a single schema backup; Shell> mysqldump –u root –p sakila > sakila2013.sql Which two commands will restore the sakila database without interfering with other running database?()
第7题:
Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace()
第8题:
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
第9题:
Company.com has four pSeries servers in their data center and wants to deploy multiple Micro-Partitions. Which of the following data center servers can be used for this purpose?()
第10题:
Which statement must you issue to an already-running Automatic Storage Management (ASM) instance to prevent database instances from connecting to the ASM instance?()