多选题Which two statements describe the behavior of the server's SQL mode?（）AThe server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntaxBThe server's SQL mode determines wheth

题目
多选题
Which two statements describe the behavior of the server's SQL mode?（）
A

The server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax

B

The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE

C

The server's SQL mode can be changed at the session level with a SET SESSION sql_mode=new_value command

D

The server's SQL mode, when globally set on a slave server, applies to events sent from the master

相似考题

1.Which three statements describe how the strict SQL mode provides added security?()A.It rejects statements that try to insert out-of-range valuesB.It rejects invalid datesC.It limits the operations that the server can performD.It rejects queries that produce out-of-range valuesE.It rejects dates with zero day or month values

2.You need to select the appropriate edition of SQL Server 2005 for the portable computers that are used in the Mortgage Data Cleansing project. Which edition should you use?（）A、Microsoft SQL Server 2005 Mobile EditionB、Microsoft SQL Server 2005 Express EditionC、Microsoft SQL Server 2005 Standard EditionD、Microsoft SQL Server 2005 Workgroup Edition

3. A new employee needs access to a SQL Server 2005 database that is located on a server named SQL1. You create a login named ajones by using the following Transact-SQL statement. CREATE LOGIN ajones WITH PASSWORD = ’SQLServer$1’ The new employee reports that when he logs in， he receives the following error message： "Login failed. The user is not associated with a trusted SQL Server connection." You need to resolve the error and allow the new employee to gain access to SQL1. What should you do？（）A、Change the SQL Server security mode from Windows Authentication mode to SQL Server and Windows authentication mode.B、Change the SQL Server security mode from SQL Server and Windows Authentication mode to Windows authentication mode.C、Ensure that the login name is created with square brackets （[]）.D、Give the login access to a specific database by using the CREATE USER Transact-SQL statement.

4.Which two statements describe the behavior of the server's SQL mode?（）A、The server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntaxB、The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATEC、The server's SQL mode can be changed at the session level with a SET SESSION sql_mode="new_value" commandD、The server's SQL mode, when globally set on a slave server, applies to events sent from the master

参考答案和解析
正确答案： A,D
解析： 暂无解析
更多“多选题Which two statements describe the behavior of the server's SQL mode?（）AThe server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntaxBThe server's SQL mode determines wheth”相关问题

  • 第1题：

    Which statement correctly describes SQL and /SQL*Plus?（）

    • A、Both SQL and /SQL*plus allow manipulation of values in the database.
    • B、/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.
    • C、/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.
    • D、/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.

    正确答案:A

  • 第2题：

    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 text file which is named SQL01.log on the E: drive. A SQL Server Agent job executes every 2 minutes and logs information to the text file. You get a report from users saying that the sever doesn't make response. As the technical support, you check and find that the SQL Server Agent service does not run and the SQL Server Agent job no longer functions. You have to identify the reason why the SQL Server Agent service is unresponsive. In the options below, which log should you check?（）  

    • A、You should check SQL1.log
    • B、You should check SQLAGENT.OUT
    • C、You should check log_xx.trc
    • D、You should check ERRORLOG

    正确答案:B

  • 第3题：

    You need to design the consolidation plan for SQL1， SQL2， and SQL3. You need to identify the appropriate combination of SQL Server instances and SQL Server 2005 computers that are needed to fulfill the company’s consolidation plans and security requirements.Which combination should you use？（）

    • A、one SQL Server 2005 computer with one instance
    • B、two SQL Server 2005 computers， each with two instances
    • C、two SQL Server computers， one with one instance and one with three instances
    • D、one SQL Server 2005 computer with two instances

    正确答案:D

  • 第4题：

    TestKing.com has multiple servers in a distributed environment. You work with two SQL Server 2005 computers named SQL1 and SQL2. Each server uses SQL Server Authentication and they use different logins.You need to write a distributed query that joins the data on SQL1 with the data on SQL2. What should you do？（）

    • A、Ensure that both SQL1 and SQL2 use the same login name as the security context for each server.
    • B、Configure SQL2 as a remote server. Write the query on SQL1.
    • C、Configure SQL2 as a linked server to impersonate the remote login.
    • D、Configure SQL2 as a distributed server. Use pass-through authentication.

    正确答案:C

  • 第5题：

    You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. The application uses Session objects. You are modifying the application to run on a Web farm. You need to ensure that the application can access the Session objects from all the servers in the Web farm. You also need to ensure that when any server in the Web farm restarts or stops responding， the Session objects are not lost.  What should you do？（）

    • A、Use the InProc Session Management mode to store session data in the ASP.NET worker process. 
    • B、Use the SQLServer Session Management mode to store session data in a common Microsoft SQL Server 2005 database. 
    • C、Use the SQLServer Session Management mode to store session data in an individual database for each Web server in the Web farm. 
    • D、Use the StateServer Session Management mode to store session data in a common State Server process on a Web server in the Web farm. 

    正确答案:B

  • 第6题：

    ou work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. According to the company requirement, you intend to perform an installation of an instance of SQL Server Reporting Services (SSRS) to the same machine. Now your company CIO wants version histories of all deployed reports can be kept. As a technical support, what should you do to ensure this?（）

    • A、You should use the http.sys listener to install the SSRS instance. 
    • B、You should configure the SSRS database, make it use Native mode 
    • C、You should configure the SSRS database, make it use SharePoint integrated mode 
    • D、You should use the Internet Information Services default Web site to install the SSRS instance 

    正确答案:C

  • 第7题：

    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

    正确答案:C

  • 第8题：

    单选题
    You are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2.   You need to recommend an approach for performing bulk data transfers from the SQL Server databases to SQL Azure.  What should you recommend？（）
    A

     Use the bcp utility.

    B

     Use the dta utility.

    C

     Use the SQL Server Import and Export Wizard.

    D

     Attach each SQL Server database to SQL Azure.


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

  • 第9题：

    单选题
    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. According to the company requirement, you migrate an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance, and record the use of features which will be discontinued. What should you do? （）
    A

    The SQL Server 2008 Upgrade Advisor should be used 

    B

    You should use a SQL server-side trace. The trace captures the Deprecation Announcement and Deprecation Final Support event classes 

    C

    You should use the SQL Server Profiler. The profiler captures the SQL:BatchCompleted and Exception event classes 

    D

    You should use a SQL server-side trace. The trace captures the SQL:BatchCompleted and Exception event classes. 


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

  • 第10题：

    多选题
    You need to ensure that the company’s standard password policy is enforced for all logins that areused to access SQL Server 2005.Which two actions should you perform？（）
    A

    Set the appropriate local password policies for all computers on which SQL Server is installed.

    B

    Set the server authentication mode of all SQL Server instances to Windows Authentication mode.

    C

    Install all instances of SQL Server 2005 on computers that run Windows Server 2003 or later.

    D

    Create SQL Server logins that have CHECK_POLICY enabled.


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

  • 第11题：

    多选题
    Which three statements describe how the strict SQL mode provides added security?（）
    A

    It rejects statements that try to insert out-of-range values

    B

    It rejects invalid dates

    C

    It limits the operations that the server can perform

    D

    It rejects queries that produce out-of-range values

    E

    It rejects dates with zero day or month values


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

  • 第12题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which contains a database. According to the company requirement， you have to move the application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the use of features.  These features will be discontinued. What should you do？ （）
    A

    The SQL Server 2008 Upgrade Advisor should be used. 

    B

    The SQL Server Profiler which captures the SQL:BatchCompleted and Exception event classes should be used. 

    C

    A SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes should be used 

    D

    A SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes should be used.


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

  • 第13题：

    Which three statements describe how the strict SQL mode provides added security?（）

    • A、It rejects statements that try to insert out-of-range values
    • B、It rejects invalid dates
    • C、It limits the operations that the server can perform
    • D、It rejects queries that produce out-of-range values
    • E、It rejects dates with zero day or month values

    正确答案:A,B,E

  • 第14题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which uses mixed authentication mode. The instance runs on a computer which has Windows Server 2003 installed. You must make sure that the SQL Server 2008 authenticated logins follow the same password complexity rules that are enforced by Windows Server 2003. Besides this, you must make sure that the password complexity rules continue to be enforced.  So what action should you perform to achieve this goal?（） 

    • A、You should create an SQL Server Agent job. If a rule violation is detected, the job runs periodically to raise an alert 
    • B、You should modify all logins by using the ALTER LOGIN ... HASHED statement. 
    • C、You should modify all logins by using the ALTER LOGIN ... CHECK_POLICY = ON statement to. 
    • D、You should modify all logins by using the ALTER LOGIN ... CHECK_EXPIRATION = ON statement. 
    • E、You should create a policy by using Policy-Based Management. The policy prevents any violation of these rules

    正确答案:C,E

  • 第15题：

    You are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2.   You need to recommend an approach for performing bulk data transfers from the SQL Server databases to SQL Azure.  What should you recommend？（）

    • A、 Use the bcp utility.
    • B、 Use the dta utility.
    • C、 Use the SQL Server Import and Export Wizard.
    • D、 Attach each SQL Server database to SQL Azure.

    正确答案:A

  • 第16题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. You create a SQL Server Agent job that execute every 2 minutes. There istext file named SQL.log On the E://drive. The job logs information to the text file. You get a report from users saying that the server doesn'；t make response. You check and find that the SQL Server Agent service does not run and the Agent job doesn'；t function any loner. As the IT support， you have to identify the reason for the failure of the SQL Server Agent service.  Which log should you check？ （）

    • A、You should check ERRORLOG
    • B、You should check QL1.log
    • C、You should check SQLAGENT.OUT
    • D、You should check log_xx.trc

    正确答案:C

  • 第17题：

    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 a database administrator for your company. There is a Data Transformation Services （DTS） package， and the DTS package is stored in SQL Server 2000. And you plans to have the SQL Server 2000 migrated into SQL Server 2005. The DTS package dynamically configures precedence constraints by utilizing complex Microsoft Visual Basic Scripting Edition （VBScript）. The SQL Server 2005 Package Migration Wizard is run by you， but the wizard cannot convert the package from SQL Server 2000 to SQL Server 2005. You are required to make sure that the DTS package runs in SQL Server 2005. And the package should be run in the shortest time.  Which action should be utilized？（）

    • A、The SQL Server 2000 Data Transformation Services （DTS） package should be wrapped in an Execute DTS 2000 Package task.
    • B、The SQL Server 2000 Data Transformation Services （DTS） package should be manually recreated as a SQL Server Integration Services （SSIS） package.
    • C、The SQL Server 2000 Data Transformation Services （DTS） task should be configured to not utilize precedence constraints. Then， the SQL Server 2005 Package Migration Wizard should be run again.
    • D、The SQL Server 2005 Package Migration Wizard should be run. And when the upgrade fails， a Transfer SQL Server Objects task should be run.

    正确答案:A

  • 第18题：

    You need to ensure that the company’s standard password policy is enforced for all logins that areused to access SQL Server 2005.Which two actions should you perform？（）

    • A、Set the appropriate local password policies for all computers on which SQL Server is installed.
    • B、Set the server authentication mode of all SQL Server instances to Windows Authentication mode.
    • C、Install all instances of SQL Server 2005 on computers that run Windows Server 2003 or later.
    • D、Create SQL Server logins that have CHECK_POLICY enabled.

    正确答案:C,D

  • 第19题：

    单选题
    What does the term application partitioning refer to?（）
    A

    The feature of a forms application enabling it to run both in client-server mode and on the Web. 

    B

    Storing PL/SQL program units between the Oracle server and the application to make optimal use of available resources. 

    C

    The nature of a three-tier architecture, where the form module and processing software reside on an application server. 

    D

    The feature of a forms application that is able to use Ethernet, twisted pair, and wireless data connections.


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

  • 第20题：

    多选题
    Which two statements describe the behavior of the server's SQL mode?（）
    A

    The server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax

    B

    The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE

    C

    The server's SQL mode can be changed at the session level with a SET SESSION sql_mode=new_value command

    D

    The server's SQL mode, when globally set on a slave server, applies to events sent from the master


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

  • 第21题：

    单选题
    Which statement correctly describes SQL and /SQL*Plus?（）
    A

    Both SQL and /SQL*plus allow manipulation of values in the database.

    B

    /SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.

    C

    /SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.

    D

    /SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.


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

  • 第22题：

    单选题
    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 a database administrator for your company. There is a Data Transformation Services （DTS） package， and the DTS package is stored in SQL Server 2000. And you plans to have the SQL Server 2000 migrated into SQL Server 2005. The DTS package dynamically configures precedence constraints by utilizing complex Microsoft Visual Basic Scripting Edition （VBScript）. The SQL Server 2005 Package Migration Wizard is run by you， but the wizard cannot convert the package from SQL Server 2000 to SQL Server 2005. You are required to make sure that the DTS package runs in SQL Server 2005. And the package should be run in the shortest time.  Which action should be utilized？（）
    A

    The SQL Server 2000 Data Transformation Services （DTS） package should be wrapped in an Execute DTS 2000 Package task.

    B

    The SQL Server 2000 Data Transformation Services （DTS） package should be manually recreated as a SQL Server Integration Services （SSIS） package.

    C

    The SQL Server 2000 Data Transformation Services （DTS） task should be configured to not utilize precedence constraints. Then， the SQL Server 2005 Package Migration Wizard should be run again.

    D

    The SQL Server 2005 Package Migration Wizard should be run. And when the upgrade fails， a Transfer SQL Server Objects task should be run.


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

  • 第23题：

    多选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which uses mixed authentication mode. The instance runs on a computer which has Windows Server 2003 installed. You must make sure that the SQL Server 2008 authenticated logins follow the same password complexity rules that are enforced by Windows Server 2003. Besides this, you must make sure that the password complexity rules continue to be enforced.  So what action should you perform to achieve this goal?（）
    A

    You should create an SQL Server Agent job. If a rule violation is detected, the job runs periodically to raise an alert

    B

    You should modify all logins by using the ALTER LOGIN ... HASHED statement.

    C

    You should modify all logins by using the ALTER LOGIN ... CHECK_POLICY = ON statement to.

    D

    You should modify all logins by using the ALTER LOGIN ... CHECK_EXPIRATION = ON statement.

    E

    You should create a policy by using Policy-Based Management. The policy prevents any violation of these rules


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

  • 第24题：

    单选题
    You need to design the consolidation plan for SQL1， SQL2， and SQL3. You need to identify the appropriate combination of SQL Server instances and SQL Server 2005 computers that are needed to fulfill the company’s consolidation plans and security requirements.Which combination should you use？（）
    A

    one SQL Server 2005 computer with one instance

    B

    two SQL Server 2005 computers， each with two instances

    C

    two SQL Server computers， one with one instance and one with three instances

    D

    one SQL Server 2005 computer with two instances


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

相关内容