niusouti.com

You execute the following command to audit database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）A、One audit record is created for every successful DROP TABLE command executed in the s

题目

You execute the following command to audit database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）

  • A、One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.
  • B、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.
  • C、One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.
  • D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
  • E、One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT
相似考题

1.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.

2.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’）；

3. 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

4.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 execute the ”相关问题

  • 第1题：

    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 files
    • B、 The database must be in the MOUNT state to execute the command
    • C、 The database must be in the NOMOUNT state to execute the command
    • D、 The database must be opened in RESTRICTED mode before this operation
    • E、 The database must be opened with the RESETLOGS option after the flashback operation

    正确答案:B,E

  • 第2题：

    You issued the following statement：   SQL>ALTER 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.

    正确答案:B

  • 第3题：

    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. 

    正确答案:B,D

  • 第4题：

    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：    SQL>ALTER 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 days
    • C、 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.

    正确答案:A

  • 第5题：

    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.

    正确答案:A,B,C

  • 第6题：

    You need to record package and task outcome in the ETLAudit table. Which components of SSIS should you use?（）

    • A、Custom event handlers
    • B、Data flow error output
    • C、SSIS log provider for SQL Server
    • D、Execute SQL tasks with failure precedence constraints

    正确答案:A

  • 第7题：

    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.

    正确答案:A,C,D

  • 第8题：

    单选题
    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：    SQL>ALTER 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 days

    C

     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.


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    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’）；


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    You execute this command in MOUNT mode： ALTER DATABASE ARCHIVELOG；  Where is the information that the database is now in ARCHIVELOG mode stored？（）
    A

    SPFILE

    B

    archive log

    C

    control file

    D

    system tablespace


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    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 = 'dbo' option immediately before the call to the sp_executesql stored procedure.


    正确答案： C
    解析： 暂无解析

  • 第12题：

    多选题
    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.


    正确答案： C,D
    解析： 暂无解析

  • 第13题：

    Identify four uses of the Oracle Scheduler.（）

    • A、 enables Oracle database to schedule which processes execute on which processors in a multiple CPU environment
    • B、 enables Oracle database to do patches according to a DBA-defined schedule
    • C、 enables you to schedule the execution of jobs based on time
    • D、 enables you to execute jobs in a clustered environment
    • E、 enables you to periodically execute operating systemscript files located on the same server as the database
    • F、 enables you to create a job that makes use of saved programs and schedules
    • G、 enables you to automate the management of the jobs that are created using the DBMS_JOB package

    正确答案:C,D,E,F

  • 第14题：

    You execute the following command to start an Automatic Storage Management （ASM） instance：   SQL>STARTUP；   In which of the following modes will the ASM instance start？（）

    • A、 OPEN
    • B、 MOUNT
    • C、 NORMAL
    • D、 NOMOUNT

    正确答案:B

  • 第15题：

    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 session
    • B、execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking session
    • C、execute the command， ALTER SYSTEM KILL SESSION ..， to kill the blocking session
    • D、execute the command， ALTER SESSION UNLOCK ..， to release the lock for the blocking session
    • E、execute the command， ALTER SYSTEM UNLOCK SESSION ..， to release the lock for the blocking session

    正确答案:C

  • 第16题：

    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 DS
    • B、Execute an unattended installation of AD DS
    • C、Execute RODC through AD DS
    • D、Execute AD DS by using deploying the image of AD DS
    • E、none of the above

    正确答案:B

  • 第17题：

    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.

    正确答案:A

  • 第18题：

    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 = 'dbo' option immediately before the call to the sp_executesql stored procedure.

    正确答案:C

  • 第19题：

    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 computers
    • B、Execute Add a network command and leave the SSID （service set identifier） blank
    • C、Execute gpupdate/boot command at the command prompt on laptops computers
    • D、Connect each laptop computer to a wired network and log off the laptop computer and then login again.
    • E、None of the above

    正确答案:D

  • 第20题：

    单选题
    You issued the following statement：   SQL>ALTER 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.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    多选题
    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.


    正确答案： B,F
    解析： 暂无解析

  • 第22题：

    单选题
    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? （）
    A

    while（ar.AsyncWaitHandle==null）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；

    B

    while（!ar.IsCompleted）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；

    C

    while（Thread.CurrentThread.ThreadState==ThreadState.Running）{DoWork（）；}dr=cmd.EndExecuteReader（ar）；

    D

    while（!ar.AsyncWaitHandle.WaitOne（））{DoWork（）；}dr=cmd.EndExecuteReader（ar）；


    正确答案： A
    解析： 暂无解析

  • 第23题：

    多选题
    Identify four uses of the Oracle Scheduler.（）
    A

    enables Oracle database to schedule which processes execute on which processors in a multiple CPU environment

    B

    enables Oracle database to do patches according to a DBA-defined schedule

    C

    enables you to schedule the execution of jobs based on time

    D

    enables you to execute jobs in a clustered environment

    E

    enables you to periodically execute operating systemscript files located on the same server as the database

    F

    enables you to create a job that makes use of saved programs and schedules

    G

    enables you to automate the management of the jobs that are created using the DBMS_JOB package


    正确答案： A,C
    解析： 暂无解析

  • 第24题：

    单选题
    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？（）
    A

    Modify the action of the existing rules

    B

    Create a new rule.

    C

    Add an exception to the existing rules

    D

    Delete an existing rule


    正确答案： A
    解析： 暂无解析

相关内容