You execute the following command to change the status of the SALES tablespace： SQL ALTER TABLESPACE sales OFFLINE； Which statements describe the effect of the command（）A、The tablespace would require recovery to go back online.B、A checkpoint is taken on all data files that are associated with the SALES tablespace.C、The sessions that subsequently try to access the objects in the SALES tablespace receive an error.D、The new status of the SALES tablespace is recorded in the control file when the database instance is closed.
You execute the following command to change the status of the SALES tablespace： SQL> ALTER TABLESPACE sales OFFLINE； Which statements describe the effect of the command（）
- A、The tablespace would require recovery to go back online.
- B、A checkpoint is taken on all data files that are associated with the SALES tablespace.
- C、The sessions that subsequently try to access the objects in the SALES tablespace receive an error.
- D、The new status of the SALES tablespace is recorded in the control file when the database instance is closed.
相关考题：
You have an SQL query that takes one minute to execute. You use the following code segment to execute theSQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader()You need to execute a method named DoWork() that takes one second to run while the SQL query is executing.DoWork() must run as many times as possible while the SQL query is executing.Which code segment should you use?（）A.B.C.D.
is NOT a concept of White Box Testing.A．You should execute all logical decisions on their tree and false sides.B．You should execute all independent paths within a module at least once.C．You should execute all loops at their boundary conditions.D．You should execute all interfaces at their boundary conditions.
You want to purge job entries older than 5 days from the job log. You do not want to purge window log entries. Which command will you use to accomplish this task？（） A、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（log_history = 5， job_name = ’JOB1’）；B、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history = 5， job_name = ’JOB_LOG’）；C、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history = 5， which_log = ’JOB1’）；D、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history = 5， which_log =’JOB_LOG’）；
As an administrator at Cer-tech .com， you install Web server （IIS） role on a server that runs WindowsServer 2008. You created a new site called Cer-tech .com. You need to install an application on thewebsite called web content. You copy the application to the server. What should you do to add theapplication on the website？（）A、Create a virtual directory and copy the website contents in it. Copy the application in the directory andinstall itB、Execute appcmd command on the command prompt on the serverC、Open the IIS Manager Console and select the website. Select Add ApplicationD、Execute appcmd -t on the command prompt on the server
You plan to execute the following command to perform a Flashback Database operation in your database： SQL FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）； Which two statements are true about this？（）A、 The database must have multiplexed redo log filesB、 The database must be in the MOUNT state to execute the commandC、 The database must be in the NOMOUNT state to execute the commandD、 The database must be opened in RESTRICTED mode before this operationE、 The database must be opened with the RESETLOGS option after the flashback operation
Identify four uses of the Oracle Scheduler.（）A、 enables Oracle database to schedule which processes execute on which processors in a multiple CPU environmentB、 enables Oracle database to do patches according to a DBA-defined scheduleC、 enables you to schedule the execution of jobs based on timeD、 enables you to execute jobs in a clustered environmentE、 enables you to periodically execute operating systemscript files located on the same server as the databaseF、 enables you to create a job that makes use of saved programs and schedulesG、 enables you to automate the management of the jobs that are created using the DBMS_JOB package
You issued the following statement： SQLALTER DATABASE ENABLE RESUMABLE TIMEOUT n； What will be the result of issuing the above statement？（）A、The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.B、 The command will not execute successfully because resumable space allocation is enabled at the session level.C、 The command will execute successfully and resumable space will be allocated at the session level.D、 The command will execute successfully and resumable space will be allocated at the instance level.
You execute the following command to start an Automatic Storage Management （ASM） instance： SQLSTARTUP； In which of the following modes will the ASM instance start？（）A、 OPENB、 MOUNTC、 NORMALD、 NOMOUNT
You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）A、Execute the ALTER DATABASE ARCHIVELOG statement B、Select ARCHIVELOG option in the database control and restart the database to apply the changes. C、Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement. D、Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.
One of the users in the PROD database，Adams，complains that his update on the table，TRANS， is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions，and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table， he should get the highest priority. Which method would you use to overcome this problem？（）A、execute the command， ALTER SESSION KILL ..， to kill the blocking sessionB、execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking sessionC、execute the command， ALTER SYSTEM KILL SESSION ..， to kill the blocking sessionD、execute the command， ALTER SESSION UNLOCK ..， to release the lock for the blocking sessionE、execute the command， ALTER SYSTEM UNLOCK SESSION ..， to release the lock for the blocking session
You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement： SQLALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400； What is the outcome of this statement？ （）A、 The statement will not execute successfully.B、 The statement will execute successfully， and the backups metadata will be maintained in the control file for 400 daysC、 The statement will execute successfully， and the backups metadata will be maintained in the recovery catalog for 400 days.D、 Backups will be deleted from the media after 400 days.
Certkiller .com has a main office and a branch office. Certkiller .com’s network consists of a single Active Directory forest. Some of the servers in the network run Windows Server 2008 and the rest run Windows server 2003. You are the administrator at Certkiller .com. You have installed Active Directory Domain Services （AD DS） on a computer that runs Windows Server 2008. The branch office is located in a physically insecure place. It has not IT personnel onsite and there are no administrators over there. You need to setup a Read-Only Domain Controller （RODC） on the Server Core installation computer in the branch office. What should you do to setup RODC on the computer in branch office（）A、Execute an attended installation of AD DSB、Execute an unattended installation of AD DSC、Execute RODC through AD DSD、Execute AD DS by using deploying the image of AD DSE、none of the above
The corporate network of Certkiller consists of a Windows Server 2008 single Active Directory domain. The domain has two servers named Certkiller 1 and Certkiller 2. To ensure central monitoring of events you decided to collect all the events on one server， Certkiller 1. To collect events from Certkiller 2. and transfer them to Certkiller 1， you configured the required event subscriptions. You selected the Normal option for the Event delivery optimization setting by using the HTTP protocol. However， you discovered that none of the subscriptions work. Which of the following actions would you perform to configure the event collection and event forwarding on the two servers（）A、Through Run window execute the winrm quickconfig command on Certkiller 2.B、Through Run window execute the wecutil qc command on Certkiller 2.C、Add the Certkiller 1 account to the Administrators group on Certkiller 2.D、Through Run window execute the winrm quickconfig command on Certkiller 1.E、Add the Certkiller 2 account to the Administrators group on Certkiller 1.F、Through Run window execute the wecutil qc command on Certkiller 1.
You are upgrading the database servers that are used by all of the companys applications. As the first step in the upgrade, you upgrade the development database servers. You need to verify that the upgrade of the database servers did not introduce any errors into the databases. What should you do?（） A、Execute unit test scripts for each stored procedure in each database.B、Execute the stored procedures in the SQL Server Management Studio debugger, and verify the results.C、Set the database compatibility level on the database servers to 80.D、Execute the application user interface test scripts to verify proper operation.
You need to record package and task outcome in the ETLAudit table. Which components of SSIS should you use?（）A、Custom event handlersB、Data flow error outputC、SSIS log provider for SQL ServerD、Execute SQL tasks with failure precedence constraints
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. There is a database named DB1 in the instance. DB1 has a table which is named Table01 and a stored procedure named Procedure01. Procedure01 choose data from Table01 by using a sp_executesql Transact-SQL statement. You company security rules forbid users to access tables directly in any database. Look at the exception below: "Msg 229, Level 14, State 5, Line 1 The SELECT permission was denied on the object 'Table01', database 'DB1', schema 'dbo'." The exception is raised when Procedure01 is executed by users. You must make sure that e user can successfully execute Procedure1 complying with the company rules. So what action should you perform to achieve this goal?（） A、You should execute the GRANT SELECT ON dbo.Table01 TO User1 Transact-SQL statement. B、You should execute the GRANT EXECUTE ON dbo.Procedure1 TO User1 Transact-SQL statement. C、You should alter Procedure01 and add the WITH EXECUTE AS OWNER option to its header D、You should alter Procedure01 and add the EXECUTE AS USER = apos;dboapos; option immediately before the call to the sp_executesql stored procedure.
You need to design the database permissions for access from the terminals to the database server. Which action or actions should you perform?（）A、Create a database role named BankTerminals.B、Grant the BankTerminals role the Execute permission for the WoodgroveBanking database.C、Grant database access to the Windows Bank Terminals group， and add the group to the BankTerminals role.D、Grant the BankTerminals role the Execute permission for the Bank schema.E、Grant the Windows Bank Terminals group the Execute permission for the Bank schema.F、Grant the BankTerminals role the Execute permission for all stored procedures and user-defined functions in the Bank schema.
ertkiller .com has purchased laptop computers that will be used to connect to a wireless network. You create a laptop organizational unit and create a Group Policy Object （GPO） and configure user profiles by utilizing the names of approved wireless networks. You link the GPO to the laptop organizational unit. The new laptop users complain to you that they cannot connect to a wireless network. What should you do to enforce the group policy wireless settings to the laptop computers（）A、Execute gpupdate/target：computer command at the command prompt on laptop computersB、Execute Add a network command and leave the SSID （service set identifier） blankC、Execute gpupdate/boot command at the command prompt on laptops computersD、Connect each laptop computer to a wired network and log off the laptop computer and then login again.E、None of the above
单选题You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement： SQLALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400； What is the outcome of this statement？ （）A The statement will not execute successfully.B The statement will execute successfully， and the backups metadata will be maintained in the control file for 400 daysC The statement will execute successfully， and the backups metadata will be maintained in the recovery catalog for 400 days.D Backups will be deleted from the media after 400 days.
单选题You issued the following statement： SQLALTER DATABASE ENABLE RESUMABLE TIMEOUT n； What will be the result of issuing the above statement？（）AThe command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.B The command will not execute successfully because resumable space allocation is enabled at the session level.C The command will execute successfully and resumable space will be allocated at the session level.D The command will execute successfully and resumable space will be allocated at the instance level.
单选题You want to purge job entries older than 5 days from the job log. You do not want to purge window log entries. Which command will you use to accomplish this task？（）A EXECUTE DBMS_SCHEDULER.PURGE_LOG（log_history = 5， job_name = ’JOB1’）；B EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history = 5， job_name = ’JOB_LOG’）；C EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history = 5， which_log = ’JOB1’）；D EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history = 5， which_log =’JOB_LOG’）；
多选题You need to design the database permissions for access from the terminals to the database server. Which action or actions should you perform?（）ACreate a database role named BankTerminals.BGrant the BankTerminals role the Execute permission for the WoodgroveBanking database.CGrant database access to the Windows Bank Terminals group， and add the group to the BankTerminals role.DGrant the BankTerminals role the Execute permission for the Bank schema.EGrant the Windows Bank Terminals group the Execute permission for the Bank schema.FGrant the BankTerminals role the Execute permission for all stored procedures and user-defined functions in the Bank schema.
单选题You execute this command in MOUNT mode： ALTER DATABASE ARCHIVELOG； Where is the information that the database is now in ARCHIVELOG mode stored？（）ASPFILEBarchive logCcontrol fileDsystem tablespace
单选题You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously.IAsyncResult ar = cmd.BeginExecuteReader（ ）;You need to execute a method named Do Work（ ） that takes one second to run while the SQL query is executing. DoWork（ ） must run as many times as possible while the SQL query is executing. Which code segment should you use? （）Awhile（ar.AsyncWaitHandle==null）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；Bwhile（!ar.IsCompleted）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；Cwhile（Thread.CurrentThread.ThreadState==ThreadState.Running）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；Dwhile（!ar.AsyncWaitHandle.WaitOne（））{DoWork（）；}dr=cmd.EndExecuteReader（ar）；
单选题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. There is a database named DB1 in the instance. DB1 has a table which is named Table01 and a stored procedure named Procedure01. Procedure01 choose data from Table01 by using a sp_executesql Transact-SQL statement. You company security rules forbid users to access tables directly in any database. Look at the exception below: "Msg 229, Level 14, State 5, Line 1 The SELECT permission was denied on the object 'Table01', database 'DB1', schema 'dbo'." The exception is raised when Procedure01 is executed by users. You must make sure that e user can successfully execute Procedure1 complying with the company rules. So what action should you perform to achieve this goal?（）AYou should execute the GRANT SELECT ON dbo.Table01 TO User1 Transact-SQL statement. BYou should execute the GRANT EXECUTE ON dbo.Procedure1 TO User1 Transact-SQL statement. CYou should alter Procedure01 and add the WITH EXECUTE AS OWNER option to its header DYou should alter Procedure01 and add the EXECUTE AS USER = apos;dboapos; option immediately before the call to the sp_executesql stored procedure.
多选题Identify four uses of the Oracle Scheduler.（）Aenables Oracle database to schedule which processes execute on which processors in a multiple CPU environmentBenables Oracle database to do patches according to a DBA-defined scheduleCenables you to schedule the execution of jobs based on timeDenables you to execute jobs in a clustered environmentEenables you to periodically execute operating systemscript files located on the same server as the databaseFenables you to create a job that makes use of saved programs and schedulesGenables you to automate the management of the jobs that are created using the DBMS_JOB package
多选题You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）AExecute the ALTER DATABASE ARCHIVELOG statementBSelect ARCHIVELOG option in the database control and restart the database to apply the changes.CShut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.DShut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.
单选题Your network contains an Active Directory domain named contoso.com. All domain controllers run Windows Server 2012 R2. You create and enforce the default AppLocker executable rules. Users report that they can no longer execute a legacy application installed in the root of drive C. You need to ensure that the users can execute the legacy application. What should you do？（）AModify the action of the existing rulesBCreate a new rule.CAdd an exception to the existing rulesDDelete an existing rule