You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results? （）A、CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;B、CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;C、GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results? （）
- A、CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;
- B、CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;
- C、GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
相关考题：
You need to perform. some initial configuration tasks on a new Ezonexam switch. What is the purpose of assigning an IP address to a switch?A．To provide local hosts with a default gateway addressB．To allow remote management of the switch.C．To allow the switch to respond to ARP requests between two hostsD．To ensure that hosts on the same LAN can communicate with each other.E．None of the above
You need to connect to your computer by using the Remote Desktop Connection client.Which two actions should you perform?() A.AB.BC.CD.DE.E
You are the network administrator at TestKing. You need to perform password recovery on Router TK1. What must you modify in the password recovery process?（）A、Configuration registerB、NVRAMC、Boot flashD、CMOSE、Flash
You are the network administrator for All network servers run Windows Server 2003. Recently, another network administrator create a scheduled task to perform a normal backup of Microsoft Exchange Server 2003 compuer every Saturday night. You need to perform maintenance tasks on the Exchange server on this Saturday night only. If the backup starts while you are performing the maintenance tasks,data might be corrupted. You need to ensure that the backup task does not start while you perform the maintenance tasks. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution.（）Choose two.)A、In the Backup utility, clear the Enabled (scheduled tasks runs at specified time) check box.B、In Control Panel, use Scheduled Tasks to pause Task Scheduler.C、Run the Schtasks command with the /end /p parameters.D、Use the Services snap-in to change the startup type of the Task Scheduler service from Automatic to Manual.
You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）A、 You do not need to restore all the data files.B、 You do not need to open the database with the RESETLOGS operationC、 You do not need to perform a full backup after the RESETLOGS operation.D、 You do not need to recover all the data files to the same system change number （SCN）.
You host 16 virtual machines that are distributed evenly across an 8-node Windows Server 2008 R2 Hyper-V failover cluster. You plan to perform live migrations of the VMs to prepare for the installation of software updates on the cluster. You need to perform the maximum number of simultaneous live migrations. How many live migrations should you perform simultaneously？（）A、oneB、twoC、fourD、eight
You have three computers that run Windows 7. You use Windows PowerShell to perform remote administration tasks on all three computers. You need to remotely administer all three computers by usingPowerShell. Which PowerShell cmdlet should you use?（）A、Enable-PSRemotingB、Enable-PSSessionConfigurationC、New-PSDriveD、New-PSSession
You are the administrator of the TestKing company network. The network consists of a single Active Directory domain named The network includes 20 member servers running Windows Server 2003 and 4 domain controllers running Windows Server 2003. All client computers run Windows XP Professional. A member server named TestKingSrvA functions as a file server. TestKingSrvA has a locally attached tape device. You need to create a backup schedule for TestKingSrvA. All data on TestKingSrvA must be backed up once a week. Every day, you need to back up only the data that was changed after the last weekly backup. You need to minimize the amount of time taken to restore the data in the event of a hardware failure. What should you do? （）(Choose two)（）A、Perform a normal backup every week.B、Perform a copy backup every week.C、Perform a differential backup every week.D、Perform an incremental backup every weekE、Perform a normal backup every day.F、Perform a copy backup every day.G、Perform a differential backup every day.H、Perform an incremental backup every day.
Your company has an Active Directory forest that contains only Windows Server 2008 domain controllers. You need to prepare the Active Directory domain to install Windows Server 2008 R2 domain controllers. Which two tasks should you perform（）A、Run the adprep /forestprep command.B、Run the adprep /domainprep command.C、Raise the forest functional level to Windows Server 2008.D、Raise the domain functional level to Windows Server 2008.
You use a mobile device that runs Microsoft Windows Mobile 5.0 Pocket PC Phone Edition. You perform the following tasks： Read e-mail messages and attachments. Edit Microsoft Word documents. Review Microsoft PowerPoint presentations. Chat through Microsoft Pocket MSN. Read information through Microsoft Pocket Internet Explorer. When you attempt to open a custom line-of-business （LOB） application， you receive a low memory error. You need to open the LOB application to enter new sales information. What are two possible ways to achieve this goal？（）A、Move all applications to an external storage card.B、Perform a soft reset of the Windows Mobilebased device.C、Perform a hard reset of the Windows Mobilebased device.D、Stop all applications by using the Running Programs list.
You use Windows 2000 Professional on your desktop Computer. You schedule a task to run an MMC snap-in to perform configuration tasks on other computers. You notice that the task is not completing correctly. You manually start MMC. You add the snap-in. You are then able to successfully run the task. You verify that all of your other tasks are working correctly. You want to enable your tasks to complete successfully. What should you do？（）A、Use Scheduled Tasks to configure the task to run under the security context of your account.B、Configure the Task Scheduler service account to use a local Administrator account and password.C、Use Computer Management to start the Messenger service and to configure the Messenger service to start automatically. D、Use Computer Management to start the Task Scheduler service and to configure the Task Scheduler service to start automatically.
You are the network administrator for your company. A Windows Server 2003 computer named Router11 is used to connect the network to the Internet. You find out that some computers on the network are infected with a worm， which occasionally sends out traffic to various hosts on the Internet. This traffic always uses a certain source TCP port number.You need to identify which computers are infected with the worm. You need to configure a solution on Router11 that will perform the following two tasks： Detect and identify traffic that is sent by the worm. Immediately send a notification to a network administrator that the infected computer needs to be repaired. What should you do？（）A、Configure a WMI event trigger.B、Configure a Network Monitor capture filter.C、Configure a Network Monitor trigger.D、Configure a System Monitor alert.
You are a database administrator for your company. You are configuring a new SQL Server 2005 computer named SQL1. SQL1 will run Reporting Services. It will also be configured to automatically perform database backups and other maintenance tasks. There are no other SQL Server computers in the network environment. All access to SQL1 will be made by using SQL1s DNS name. You need to disable any unnecessary services on SQL1. Which service or services should you disable？（）A、Internet Information ServicesB、SQL Server BrowserC、SQL Server AgentD、Microsoft Distributed Transaction Coordinator
You have a Windows Server 2008 R2 Hyper-V server. One of the virtual machines （VMs） that is hosted on the server has a directly attached physical disk. You need to back up the VM. What should you do？（）A、Perform a full server backup on the VM.B、Perform a critical-volume backup on the VM.C、Perform a full server backup on the host server.D、Perform a critical-volume backup on the host server.
You are the network administrator for TestKing. The network consists of a single Active Directory domain named testking.com. All domain controller run Windows Server 2003. employes three database administrators who administer seven databases servers that run Windows Server 2003. The database administrators occasionally restore a database server after a disaster. To restore a server, database administrators need the rights required to perform the following tasks: 1. Back up files and folders 2. Restore files and folders. 3. Restore the System State data. You need to assign the database administrators the rights that they require to perform the specified tasks. For security reasons, you must not assign the administrators more rights than they require to perform the tasks. What should you do?（）A、Add the database administrators' user accounts to the Administrators group on each of the database servers.B、Add the database administrators' user accounts to the Power Users group on each of the database servers.C、Add the database administrators' user accounts to the Backup Operators group on each of the database servers.D、Add the database administrators' user accounts to the Backup Operators group on one of the domain controllers.E、Add the database administrators' user accounts to the Server Operators group on one of the domain controllers.
多选题You are the network administrator for All network servers run Windows Server 2003. Recently, another network administrator create a scheduled task to perform a normal backup of Microsoft Exchange Server 2003 compuer every Saturday night. You need to perform maintenance tasks on the Exchange server on this Saturday night only. If the backup starts while you are performing the maintenance tasks,data might be corrupted. You need to ensure that the backup task does not start while you perform the maintenance tasks. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution.（）Choose two.)AIn the Backup utility, clear the Enabled (scheduled tasks runs at specified time) check box.BIn Control Panel, use Scheduled Tasks to pause Task Scheduler.CRun the Schtasks command with the /end /p parameters.DUse the Services snap-in to change the startup type of the Task Scheduler service from Automatic to Manual.
多选题You are the network administrator at TestKing. You need to perform password recovery on Router TK1. What must you modify in the password recovery process?（）AConfiguration registerBNVRAMCBoot flashDCMOSEFlash
单选题You are deploying a custom Windows 7 system image to a new computer. You perform the following tasks:.Start the new computer by using the Windows Preinstallation Environment (Windows PE) .Connect to ashared network location that contains the Windows 7 image file You need to apply the Windows 7 image tothe computer. What should you do before you apply the image?（）AMount the image.BConfigure Windows Firewall.CConfigure and format the hard disk drive.DInitialize the Boot Configuration Data （BCD） store.
多选题Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？ （）Aopen the database with the RESETLOGS optionBopen the database with the RESTRICTED optionCrecover all the data files to the same system change number （SCN）Drecover to the required SCN only that data file in which the error occurred
单选题You need to design a method for junior IT administrators to perform more IT support tasks. Your solution must meet business and security requirements. What should you do？（）ADelegate appropriate Active Directory permissions to the junior IT administratorsBAdd the junior IT administrators’ user accounts to the Domain Admins user groupCCreate a custom Microsoft Management Console （MMC） that uses taskpad views to enable the appropriate tasks for the junior IT administratorsDMake the junior IT administrators’ domain user accounts member of the local Administrators group on all client computersECreate new domain user accounts for each junior IT administrator. Make the new accounts members of the Domain Admins group and instruct junior IT administrators to use the new accounts only for appropriate administrative tasks
单选题You are developing an application to assist the user in conducting electronic surveys.The survey consists of 25 true-or-false questions.You need to perform the following tasks： Initialize each answer to true.Minimize the amount of memory used by each survey. Which storage option should you choose？（）ABitVector32 answers = new BitVector32（1）；BBitVector32 answers = new BitVector32（-1）；CBitArray answers = new BitArray （1）；DBitArray answers = new BitArray（-1）；
单选题You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）A You do not need to restore all the data files.B You do not need to open the database with the RESETLOGS operationC You do not need to perform a full backup after the RESETLOGS operation.D You do not need to recover all the data files to the same system change number （SCN）.
多选题Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）Aopen the database with the RESTRICTED optionBopen the database with the RESETLOGS optionCrecover to the required SCN only that data file in which the error occurredDrecover all the data files to the same system change number （SCN）
单选题You need to perform an automated installation of an Exchange Server 2010 server.Which Command should you include in your script？（）Asetup.exeBsetup.comCmsiexec.exeDlpsetupui.exe
多选题Your company has an Active Directory forest that contains only Windows Server 2003 domain controllers. You need to prepare the Active Directory domain to install Windows Server 2008 domain controllers. Which two tasks should you perform（）ARun the adprep /forestprep command.BRun the adprep /domainprep command.CRaise the forest functional level to Windows Server 2008.DRaise the domain functional level to Windows Server 2008.
单选题You need to identify which tool the help desk users must use to perform administrative tasks. Which tool should you identify？（）ARemoteAppBRemote AssistanceCRemote DesktopDRemote Server Administration Tools （RSAT）
单选题You have three computers that run Windows 7. You use Windows PowerShell to perform remote administration tasks on all three computers. You need to remotely administer all three computers by usingPowerShell. Which PowerShell cmdlet should you use?（）AEnable-PSRemotingBEnable-PSSessionConfigurationCNew-PSDriveDNew-PSSession