多选题You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode.   Which two statements are correct in this scenario?()AThe WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.BThe Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.CSetting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA  memory management.DThe SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA  memory management mode.

多选题
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode.   Which two statements are correct in this scenario?()
A

The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.

B

The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.

C

Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA  memory management.

D

The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA  memory management mode.


参考解析

解析: 暂无解析

相关考题:

Your network contains a Distributed File System (DFS) target folder named Folder1 that contains 100 GB of data. You plan to create a new DFS replica of Folder1 on a server named Server2. You need to prestage the data in Folder1 on Server2. The solution must ensure that the amount of initial DFS replication traffic is minimized.Which tool should you use to prestage the Folder1 data?()A. DfscmdB. DfsrmigC. DfsutilD. Wbadmin

You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode. Which two statements are correct in this scenario? ()A、 The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.B、 The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.C、 Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.D、 The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.

Your company has a network that has 100 servers. A server named Server1 is configured as a file server. Server1 is connected to a SAN and has 15 logical drives.You want to automatically run a data archiving script if the free space on any of the logical drives is below 30 percent.You need to automate the script execution.You create a new Data Collector Set. What should you do next?()A、Add the Event trace data collector.B、Add the Performance counter alert.C、Add the Performance counter data collector.D、Add the System configuration information data collector.

You want to migrate your application from the development environment to the production environment. While doing the task, you want the database objects owned by the user DEVUSER in the development environment to be moved to the user APPS in the production environment. Which option of Oracle Data Pump Import would you use to achieve this objective?()A、ownerB、touserC、includeD、schemasE、fromuserF、transformG、remap_schemaH、remap_datafileI、reuse_datafilesJ、remap_tablespace

Your network contains a single Active Directory domain. All servers on the network are members of the domain. You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). Server1 has two NTFS partitions. You create and share a folder named Data in the root of a partition on Server1. You log on to your computer by using the domain Administrator account and discover that you cannot modify files in the Data share. You need to ensure that the Administrator can modify files in the Data share. The solution must use the minimum amount of permissions. What should you do? ()A、Modify the NTFS permissions on the Data folder.B、Modify the share permissions on the Data share.C、Add the domain administrator to the local Administrator’s group on Server1.D、Move the Data folder to a new file allocation table (FAT) partition. Share the folder by using the default permissions.

Your network consists of a single Active Directory domain. You have two file servers named Server1 and Server2 that run Windows Server 2003 Service Pack 2 (SP2). Both servers have a shared folder named Data. You have a computer named Computer1 that runs Windows XP Professional Service Pack 3 (SP3). From Computer1, you view the properties of //server1/data and discover a Previous Versions tab. From Computer1, you view the properties of //server2/data and discover that the Previous Versions tab is missing. You need to ensure that you can access previous versions of files from //server2/data. What should you do? ()A、On Server2, enable Shadow Copies for all volumes.B、On Server2, create an Automated System Recovery (ASR) backup.C、Assign your user account the Full Control share permission to //server2/data.D、On the Customize tab in the //server2/data properties, click Restore Default.

Your company has an Active Directory forest. You plan to install an Enterprise certification authority  (CA) on a dedicated stand-alone server.    When you attempt to add the Active Directory Certificate Services (AD CS) server role, you find that the  Enterprise CA option is not available.    You need to install the AD CS server role as an Enterprise CA.    What should you do first()A、Add the DNS Server server role.B、Join the server to the domain.C、Add the Web Server (IIS) server role and the AD CS server roleD、Add the Active Directory Lightweight Directory Services (AD LDS) server role. .

You are designing a Windows Server 2008 R2 Hyper-V virtualization environment. Your host servers must have the following elements:  A dedicated management network adapter.A dedicated virtual network for child iSCSI network traffic.A dedicated virtual network for child network traffic with VLAN tagging. You need to choose adapters that minimize the host server processing.  Which adapters should you choose?()A、three network adapters that support 802.1pB、two network adapters that support 802.1q, and one iSCSI host bus adapterC、two network adapters that support 802.1p, and one network adapter that supports TCP ChimneyD、two network adapters that support 802.1q, and one network adapter that supports Jumbo frames

You have an Exchange Server 2010 organization. You design a deployment of multiple Mailbox servers.  Your companys Service Level Agreement (SLA) states that servers must support 1,000 concurrent connections to mailboxes while maintaining an RPC latency of less than 20 milliseconds.  You need to verify that your design meets the requirements of the SLA before you deploy servers in the production environment.  Which tool should you use?()A、Exchange Server Jetstress 2010B、Exchange Server User Monitor (ExMon)C、Exchange Server Load Generator (LoadGen) 2010D、Exchange Server Remote Connectivity Analyzer (ExRCA)

Your company has a network that has 100 servers. A server named server1 is configured as a file server . server1 is connected to a SAN and has 15 logical drives. You want to automatically run a data archiving script if the free space on any of the logical drives is below 30 percent. You need to automate the script execution. You create a new data collector set. What should you do next?()A、Add the event trace data collectorB、Add the performance counte ralertC、Add the performance counte rdata collectorD、Add the system configuration datacollector.

Your company has a network that has 100 servers. A server named Server1 is configured as a file server. Server1 is connected to a SAN and has 15 logical drives. You want to automatically run a data archiving script if the free space on any of the logical drives is below 30 percent. You need to automate the script execution. You create a new Data Collector Set. What should you do next?()A、 Add the Event trace data collectorB、 Add the Performance counter alertC、 Add the Performance counter data collectorD、 Add the System configuration data collector

Your company has a Microsoft Hyper-V Server 2008 R2 environment. You manage the virtual environment by using Microsoft System Center Virtual Machine Manager (VMM) 2008 R2. You are creating a virtual test environment by installing two child partitions. The test environment must be completely isolated from all production servers. You need to ensure that the child partitions can communicate with each other. Which connection type should you configure?()A、PrivateB、InternalC、ExternalD、Dedicated host

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now your company CIO assigns a task to you. The company CIO wants you to configure FILESTREAM data and the two requirements below must be met: you must enable FILESTREAM for file I/O streaming access; remote client computers must be able to have streaming access to FILESTREAM data. You must make sure that FILESTREAM data is enabled. Which service should you configure? () A、You should configure SQL Server VSS Writer B、You should configure Distributed File System C、You should configure SQL Server D、You should configure SQL Server Full Text

单选题Your network consists of a single Active Directory domain. You have two file servers named Server1 and Server2 that run Windows Server 2003 Service Pack 2 (SP2). Both servers have a shared folder named Data. You have a computer named Computer1 that runs Windows XP Professional Service Pack 3 (SP3). From Computer1, you view the properties of //server1/data and discover a Previous Versions tab. From Computer1, you view the properties of //server2/data and discover that the Previous Versions tab is missing. You need to ensure that you can access previous versions of files from //server2/data. What should you do? ()AOn Server2, enable Shadow Copies for all volumes.BOn Server2, create an Automated System Recovery (ASR) backup.CAssign your user account the Full Control share permission to //server2/data.DOn the Customize tab in the //server2/data properties, click Restore Default.

单选题You are designing a Windows Server 2008 R2 Hyper-V Virtualization environment. Your host servers must have the following elements: - A dedicated management network adapter. - A dedicated virtual network for child iSCSI network traffic. - A dedicated virtual network for child network traffic with VLAN tagging. You need to choose adapters that minimize the host server processing. Which adapters should you choose?()ATwo network adapters that support 802.1p, and one iSCSI host bus adapterBTwo network adapters that support 802.1p, and one network adapter that supports TCP ChimneyCTwo network adapters that support 802.lq, and one network adapter that supports Jumbo framesDThree network adapters that support 802. 1p

单选题Your SQL Server 2005 database contains a table that has 500 million rows of data. Some of the data is historical and some is current. You need to partition the data on a single server to increase performance and optimize maintenance. What should you do?()AImplement horizontal partitioning.BImplement vertical partitioning.CImplement a raw partition.DImplement distributed partitioning.

单选题The Certkiller has a Windows 2008 domain controller server. This server is routinely backed up over the network from a dedicated backup server that is running Windows 2003 OS. You need to prepare the domain controller for disaster recovery apart from the routine backup procedures. You are unable to launch the backup utility while attempting to back up the system state data for the data controller. You need to backup system state data from the Windows Server 2008 domain controller server. What should you do()AAdd your user account to the local Backup Operators groupBInstall the Windows Server backup feature using the Server Manager feature.CInstall the Removable Storage Manager feature using the Server Manager featureDDeactivating the backup job that is configured to backup Windows 2008 server domain controller on the Windows 2003 server.ENone of the above

单选题You want to migrate your application from the development environment to the production environment. While doing the task, you want the database objects owned by the user DEVUSER in the development environment to be moved to the user APPS in the production environment. Which option of Oracle Data Pump Import would you use to achieve this objective?()AownerBtouserCincludeDschemasEfromuserFtransformGremap_schemaHremap_datafileIreuse_datafilesJremap_tablespace

单选题Your network contains a single Active Directory domain. All servers on the network are members of the domain. You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). Server1 has two NTFS partitions. You create and share a folder named Data in the root of a partition on Server1. You log on to your computer by using the domain Administrator account and discover that you cannot modify files in the Data share. You need to ensure that the Administrator can modify files in the Data share. The solution must use the minimum amount of permissions. What should you do? ()AModify the NTFS permissions on the Data folder.BModify the share permissions on the Data share.CAdd the domain administrator to the local Administrator’s group on Server1.DMove the Data folder to a new file allocation table (FAT) partition. Share the folder by using the default permissions.

单选题Your network contains a Distributed File System (DFS) target folder named Folder1 that contains 100 GB of data. You plan to create a new DFS replica of Folder1 on a server named Server2. You need to prestage the data in Folder1 on Server2. The solution must ensure that the amount of initial DFS replication traffic is minimized. Which tool should you use to prestage the Folder1 data?()ADfscmdBDfsrmigCDfsutilDWbadmin

单选题Your network consists of a single Active Directory domain named contoso.com. The functional level ofthe domain is Windows Server 2003.You have a file server named Server1 that is used to store users’ home folders and profiles.On Server1, you create a folder named D:/data/ and share the folder as UserData. You create a new useraccount named TemplateUser in Active Directory.You need to ensure that each user account you create by copying TemplateUser is configured to have aunique home folder stored in the UserData share. Which home folder path should you specify? ()AD:/data/%homedrive%BD:/data/%username%C//server1/userdata/%homedrive%D//server1/userdata/%username%

单选题The warning level threshold value for a tablespace, DATA1, is set to 60% and the critical level threshold value is set to 80%. The tablespace, DATA1, is infrequently used and is not a part of the production environment. You issued the following command:        SQL EXECUTE   DBMS_SERVER_ALERT.SET_THRESHOLD        (dbms_server_alert.tablespace_pct_full,        dbms_server_alert.operator_ge,80,        dbms_server_alert.operator_ge,90,        1,1,NULL,   dbms_server_alert.object_type_tablespace,’DATA’);   What will be the result of the command?()A The command will be executed successfully only if the tablespace DATA1 is a dictionary-managed tablespace.B The total numbers of alerts that you receive every day will be reduced.C The total number of alerts that you receive every day will be increased.D No more data will be added to the DATA1 tablespace if 80% of the space allocated to the DATA1 tablespace is used.

单选题Your network consists of a single Active Directory domain. You have two file servers named Server1 and Server2 that run Windows Server 2003 Service Pack 2 (SP2). Both servers have a shared folder named Data. You have a computer named Computer1 that runs Windows XP Professional Service Pack 3 (SP3). From Computer1, you view the properties of //server1/data and discover a Previous Versions tab. From Computer1, you view the properties of //server2/data and discover that the Previous Versions tab is missing. You need to ensure that you can access previous versions of files from //server2/data. What should you do? ()AOn Server2, enable Shadow Copies for all volumes.BOn Server2, create an Automated System Recovery (ASR) backup.CAssign your user account the Full Control share permission to //server2/data.DOn the Customize tab in the //server2/data properties, click Restore Default.