You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as the administrator of a SQL Server 2005 computer， and the computer is named SQL1. Microsoft Windows Server 2003 is run by all servers. All the servers belong to a Microsoft Active Directory domain. According to the company written security policy， strong passwords are mandated for all domain， local， and application accounts. The company utilizes a Group Policy object （GPO） to deploy the proper domain password policy. MS-DOS-based or UNIX-based operating systems are run by many of the company’s computers. Varying levels of access to a database named Services on SQL1 is requested by the computers. Since you are the database administrator， you are required to confirm that the Services database can be accessed by these computers. And the company’s written security policy should not be violated. Which action should be performed by you？（） A domain account should be created for each of the company’s users. And then， each domain account should be offered with access to SQL1 and the Services database.。 A local logon account should be created on SQL1 for each of the company’s users. And then， each logon account should be offered with access to SQL1 and the Services database.。 One SQL Server logon account should be created for all of the company’s computers running MS-DOS or UNIX-based operating systems. And then， the Enforce password policy option should be enabled for users’ accounts. At last， the logon accounts should be provided with access to the Services database.。 A SQL Server logon account should be created for each of the company’s users. And then， the Enforce password policy option should be enabled for each logon account. At last， each logon account should be offered with access to the Services database.。 A virtual directory should be configured through Internet Information Services （IIS） for access to SQL1. And then， users should be directed to the virtual directory for data access.。
土壤、地形条件在草地形成中的主要作用是如何体现的。
You executed the following command in Recovery Manager （RMAN）： RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed？（） back up the control file to trace。 bring database to the MOUNT state。 open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database。 set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog。
以下对于配送中心选址问题的描述，错误的是（） 配送中心应尽可能与生产地和配送区域形成短距离优化。 配送中心应靠近交通枢纽。 应选择地价最低的地区建设配送中心。 在选址时应考虑当地的地质和水文条件等。
Which statement correctly describes SQL and /SQL*Plus? （） Both SQL and /SQL*plus allow manipulation of values in the database.。 /SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.。 /SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.。 /SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.。
Examine the commands executed in a DBA session：SQL> CREATE BIGFILE TABLESPACE MRKT
2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created.
SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered.
Which two statements are trueregarding the MRKT tablespace（）
