多选题You connected to the database using the following connection string： CONNECT hr/hr@test.us.oracle.com：1521/mydb  Which three statements are correct regarding the connection string？（）Amydb is a service name.Btest.us.oracle.com is a database name.C1521 i

题目
多选题
You connected to the database using the following connection string： CONNECT hr/hr@test.us.oracle.com：1521/mydb  Which three statements are correct regarding the connection string？（）
A

mydb is a service name.

B

test.us.oracle.com is a database name.

C

1521 is the listener port number.

D

mydb is a host name.

E

test.us.oracle.com is a net service name.

F

hr is a username.

G

test.us.oracle.com is an instance name.

相似考题

1.An employee cannot access the company database. You check the connection variables:What is a valid explanation for why one of the users is unable to connect to the database?()A.Bob has max_user_connections set to zero, which blocks all his connectionsB.Joe has exceeded the max_user_connections global limitC.All users are blocked because max_user_connections is accumulated over the host account informationD.Kay is already connected elsewhere and attempting to log in againE.Connect_timeout is too small to allow a connection to occur

2. You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.You want to add two new message types to the existing service. In each database， you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first？（）A、Create a queue on each database with the ACTIVATION argument set to DataManager dbo processReport.B、Create a conversation between the databases by using the following Statement BEGIN DIALOG FROM SERVICE ’ProcessReport’ TO SERVICE ’SendResult’C、Create a contract between the services by using the following statement.CREATE CONTRACT processData （ProcessReport SENT BY INITIATOR，SendResult SENT BY TARGET）D、Create services for each database by using the following statement.CREATE SERVICE DataManager on QUEUE ProcessReport

3.Your application demands frequent connection and disconnection from the database. You have three listener processes that are listening for the database PROD. While setting up the connect string using Oracle Enterprise Manager 10g Database Control， which two options would you select to balance the connection load across all the listener processes？（）A、Use only the first address.B、Try one address，selected at random.C、Try each address，in order，until one succeeds.D、Try each address，randomly，until one succeeds.

4. Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command：   RESTORE CONTROLFILE FROM AUTOBACKUP；   Which of the following statements is true？（） A、 The command restores only the missing control file.B、 The command restores all the control files.C、 The command fails because the database is running.D、 This is the correct way to address this problem.E、 This is not the correct way to address this problem.

更多“多选题You connected to the database using the following connection string： CONNECT hr/hr@test.us.oracle.com：1521/mydb  Which three statements are correct regarding the connection string？（）Amydb is a service name.Btest.us.oracle.com is a database name.C1521 i”相关问题

  • 第1题：

    You connected to the database using the following connection string： CONNECT hr/hr@test.us.oracle.com：1521/mydb  Which three statements are correct regarding the connection string？（）

    • A、mydb is a service name.
    • B、test.us.oracle.com is a database name.
    • C、1521 is the listener port number.
    • D、mydb is a host name.
    • E、test.us.oracle.com is a net service name.
    • F、hr is a username.
    • G、test.us.oracle.com is an instance name.

    正确答案:A,C,F

  • 第2题：

    You are connecting to an Oracle database server from a client by using the following connect string：   SQL> CONNECT hr/hr@pdserver.us.oracle.com：1521/proddb   Which naming method is being used in this case？（）

    • A、Local Naming
    • B、Easy Connect
    • C、External Naming
    • D、Directory Naming

    正确答案:B

  • 第3题：

    A Windows Azure application connects to a SQL Azure database.  Connections to the database are being dropped due to throttling.   You need to recommend an approach for identifying the root cause of the problem.   Which two actions should you recommend？（）

    • A、 Use Dynamic Management Views to analyze performance issues.
    • B、 Decrease the connection timeout in the database connection string.
    • C、 Make sure the application is closing database connections that are not needed.
    • D、 Use SQL Profiler to analyze performance issues by configuring it to connect to SQL Azure.

    正确答案:A,C

  • 第4题：

    You are developing an application that connects to a Microsoft SQL Server database using the SqlConnection object. Your connection objects are being pooled. As the pool fills up, connection requests are queued. Some connection requests are rejected. You need to ensure that the application releases connections back to the pool as soon as possible. Also, you need to decrease the likelihood that connection requests will be rejected. Which three actions should you perform?（）

    • A、Ensure that the Close method is called on each connection object after it has finished executing.
    • B、Ensure that each connection object is left open after it has finished executing.
    • C、Increase the Max Pool Size value inside the connection string.
    • D、Increase the Min Pool Size value inside the connection string.
    • E、Increase the Connection Lifetime value inside the connection string.
    • F、Increase the value of the ConnectionTimeout property of the SqlConnection object.

    正确答案:A,C,F

  • 第5题：

    You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application. The Contoso.com network contains a Microsoft SQL Server 2005 server named DB01. Your application retrieve records from a  database named Trades that resides on DB01. The application connects to Trades by using an instance of the SqlConnection class with the following connection string.   "Data Source=DB01；UID=’mhamm’；PWD=’password’；"   When the application calls the Open method of the SqlConnection object， it displays the following： "Cannot open user default database. Login failed. Login failed for user ’mhamm’".  You need to make sure that you can connect to Trades when the user account for the connection is mhamm.   What should you do？ （）

    • A、 Change the connection string as follows：Data Source=DB01；Initial Catalog=Trades；UID=mhamm； PWD=password；"
    • B、 Create a login for Mia Hamm on DB01.
    • C、 Create a database user object in Trades and map the object to the SQL Server 2005 Login of Mia Hamm.
    • D、 Change the connection string as follows："Server=DB01；Database=Trades；UID=mhamm；PWD=password；"

    正确答案:C

  • 第6题：

    You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application. The database on the Microsoft SQL Server 2005 database has two tables that are displayed by using two SqlConnection objects in two different GridView controls. You want the tables to be displayed at the same time with the use a single SqlConnection object.   What should you do？（）

    • A、 Create a bound connection by using the sp_getbindtoken and the sp_bindsession stored procedures.
    • B、 Enable Multiple Active Result Sets （MARS） in the connection string of the application. 
    • C、 Create an exception handler for the connection-busy exception that is thrown on using a single SqlConnection object.
    • D、 Run the two SqlDataReader objects by using a single SqlCommand object.

    正确答案:B

  • 第7题：

    A Windows Azure application stores data in a SQL Azure database.  The application will start an operation that includes three insert statements.  You need to recommend an approach for rolling back the entire operation if the connection to SQL Azure is lost.  What should you recommend？（）

    • A、 Ensure that all statements execute in the same database transaction.
    • B、 Create a stored procedure in the database that wraps the insert statements in a TRY CATCH block.
    • C、 Create a stored procedure in the database that wraps the insertstatements in a TRANSACTION block.
    • D、 Open a new connection to the database. Use a separate transaction scope to roll back the original operation.

    正确答案:A

  • 第8题：

    单选题
    A Windows Azure application stores data in a SQL Azure database.  The application will start an operation that includes three insert statements.  You need to recommend an approach for rolling back the entire operation if the connection to SQL Azure is lost.  What should you recommend？（）
    A

     Ensure that all statements execute in the same database transaction.

    B

     Create a stored procedure in the database that wraps the insert statements in a TRY CATCH block.

    C

     Create a stored procedure in the database that wraps the insertstatements in a TRANSACTION block.

    D

     Open a new connection to the database. Use a separate transaction scope to roll back the original operation.


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

  • 第9题：

    多选题
    You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. When you try to connect to the database you get the following error： ERROR：  ORA-12154：TNS：couldnot resolve service name  Which network configuration files would you look into to resolve this error？（）
    A

    snmp.ora

    B

    names.ora

    C

    spfile.ora

    D

    sqlnet.ora

    E

    listener.ora

    F

    tnsnames.ora


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

  • 第10题：

    单选题
    You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application. The database on the Microsoft SQL Server 2005 database has two tables that are displayed by using two SqlConnection objects in two different GridView controls. You want the tables to be displayed at the same time with the use a single SqlConnection object.   What should you do？（）
    A

     Create a bound connection by using the sp_getbindtoken and the sp_bindsession stored procedures.

    B

     Create an exception handler for the connection-busy exception that is thrown on using a single SqlConnection object.

    C

     Run the two SqlDataReader objects by using a single SqlCommand object.

    D

     Enable Multiple Active Result Sets （MARS） in the connection string of the application.


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

  • 第11题：

    单选题
    Which one of the following statements about the TNSPING utility is correct？（）
    A

    It helps you to determine whether or not the Oracle database is running.

    B

    It requires the username and password to check the connectivity of the service.

    C

    It does not require the username and password to check the connectivity of the service.

    D

    It establishes a session with the database and checks the connectivity of the service.


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

  • 第12题：

    多选题
    A Windows Azure application connects to a SQL Azure database.  Connections to the database are being dropped due to throttling.   You need to recommend an approach for identifying the root cause of the problem.   Which two actions should you recommend？（）
    A

    Use Dynamic Management Views to analyze performance issues.

    B

    Decrease the connection timeout in the database connection string.

    C

    Make sure the application is closing database connections that are not needed.

    D

    Use SQL Profiler to analyze performance issues by configuring it to connect to SQL Azure.


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

  • 第13题：

    You are working as a Database Administrator. Despite having a password in the data dictionary as change_on_install， you always log on to the database MYNEWDB using operating system authentication. Your organization is planning to recruit two junior-level DBAs. You decide to enable remote authentication in your database so that the new DBAs can log on to the database from their workstations to carry out administrative tasks.   To allow the new DBAs to perform the administrative tasks， you create a password file on the database server using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4   After creating the password file， you remove the operating system authentication and change the value of the  REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE. You also create a net service name as MYNEWDB that allows the new DBAs to connect to the database server from their workstations using this net service name. Which command must you use to connect to the database to start it？（）  

    • A、 CONNECT / AS SYSDBA
    • B、 CONNECT sys/admin AS SYSDBA
    • C、 CONNECT sys/admin@mynewdb AS SYSDBA
    • D、 CONNECT sys/change_on_install AS SYSDBA

    正确答案:D

  • 第14题：

    Which one of the following statements about the TNSPING utility is correct？（）

    • A、It helps you to determine whether or not the Oracle database is running.
    • B、It requires the username and password to check the connectivity of the service.
    • C、It does not require the username and password to check the connectivity of the service.
    • D、It establishes a session with the database and checks the connectivity of the service.

    正确答案:B

  • 第15题：

    You create a Web site with membership and personalization enabled. You must use an existing CRM database for storing the membership information. You need to implement the Membership Provider. What should you do? （）

    • A、Modify the connection string in the Web.config file to connect to the CRM database.
    • B、Add new a SqlMembershipProvider to the Web.config file.
    • C、Create a custom Membership Provider inheriting from MembershipProvider.
    • D、Create a custom MembershipUser inheriting from MembershipUser.

    正确答案:C

  • 第16题：

    You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application. You want to make sure that the application is operative to any type of database.   What should you do？（）

    • A、 Set the database driver name in the connection string of the application， and then the connection object as follows： DbConnection connection = new OdbcConnection（connectionString）；
    • B、 Create the connection object as follows： DbProviderFactory factoryDbProviderFactories.GetFactory（databaseProviderName）； DbConnection connection =factory.CreateConnection（）；
    • C、 Create the connection object as follows： DbProviderFactory factory = DbProviderFactories.GetFactory（"System.Data.Odbc"）； DbConnection connection = factory.CreateConnection（）；
    • D、 Set the database driver name in the connection string of the application， and then the connection object as follows：DbConnection connection = new OleDbConnection（connectionString）；

    正确答案:B

  • 第17题：

    You work as an application developer at Contoso.com. You use Microsoft .NET Framework 3.5 and Microsoft ADO.NET to develop an application that will connect to the Microsoft SQL Server 2005 database. You want to use Windows Authentication along with the Microsoft OLE DB provider. You now need to make sure that the OLE DB connection is as secure as possible.   What should you do？（）

    • A、 Add the following parameter to the connection string： Integrated Security=true； PersistSecurityInfo=true；
    • B、 Add the following parameter to the connection string： Integrated Security=SSPI；
    • C、 Add the following parameter to the connection string： Integrated Security=SSPI； PersistSecurityInfo=yes；
    • D、 Add the following parameter to the connection string： Integrated Security=true；

    正确答案:B

  • 第18题：

    You create a Web Form. The Web Form allows users to log on to a Web site. You implement the login logic using a Login control named Login1. The membership data for the application is stored in a SQL Express database in the App_Data directory. You need to configure your application so that the membership data is stored in a local Microsoft SQL Server database. You add the following code segment to the Web.config file. Which two additional actions should you perform?（）

    • A、Use Aspnet_regsql.exe to create the Microsoft SQL Server database.
    • B、Set Login1's MembershipProvider property to MySqlProviderConnection.
    • C、Add the following code segment to the Web.config file.<connectionStrings> <add name="MySqlProviderConnection" connectionString="valid connection string" /></connectionStrings>
    • D、Add the following code segment to the Web.config file.  <appSettings><add key="MySqlProviderConnection" value="valid connection string" /></appSettings>
    • E、In the ASP.NET configuration settings within IIS, ensure that Role Management Enabled is selected.
    • F、Use the Web Site Administration Tool to select AspNetSqlMembershipProvider as the membership provider for your application.

    正确答案:B,D

  • 第19题：

    多选题
    Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command：   RESTORE CONTROLFILE FROM AUTOBACKUP；   Which of the following statements is true？（）
    A

    The command restores only the missing control file.

    B

    The command restores all the control files.

    C

    The command fails because the database is running.

    D

    This is the correct way to address this problem.

    E

    This is not the correct way to address this problem.


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

  • 第20题：

    多选题
    You create a Web Form. The Web Form allows users to log on to a Web site. You implement the login logic using a Login control named Login1. The membership data for the application is stored in a SQL Express database in the App_Data directory. You need to configure your application so that the membership data is stored in a local Microsoft SQL Server database. You add the following code segment to the Web.config file. Which two additional actions should you perform? （）
    A

    Use Aspnet_regsql.exe to create the Microsoft SQL Server database.

    B

    Set Login1's MembershipProvider property to MySqlProviderConnection.

    C

    Add the following code segment to the Web.config file. <connectionStrings> <add name=MySqlProviderConnection connectionString=valid connection string /></connectionStrings>

    D

    Add the following code segment to the Web.config file. <appSettings><add key=MySqlProviderConnection value=valid connection string /></appSettings>

    E

    In the ASP.NET configuration settings within IIS, ensure that Role Management Enabled is selected.

    F

    Use the Web Site Administration Tool to select AspNetSqlMembershipProvider as the membership provider for your application.


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

  • 第21题：

    单选题
    The client connected to the database turns off his or her machine without exiting from a connection to the database. Which type of failure is this？（）
    A

    media

    B

    instance

    C

    statement

    D

    user process


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

  • 第22题：

    多选题
    Your application demands frequent connection and disconnection from the database. You have three listener processes that are listening for the database PROD. While setting up the connect string using Oracle Enterprise Manager 10g Database Control， which two options would you select to balance the connection load across all the listener processes？（）
    A

    Use only the first address.

    B

    Try one address，selected at random.

    C

    Try each address，in order，until one succeeds.

    D

    Try each address，randomly，until one succeeds.


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

  • 第23题：

    多选题
    You connected to the database using the following connection string： CONNECT hr/hr@test.us.oracle.com：1521/mydb  Which three statements are correct regarding the connection string？（）
    A

    mydb is a service name.

    B

    test.us.oracle.com is a database name.

    C

    1521 is the listener port number.

    D

    mydb is a host name.

    E

    test.us.oracle.com is a net service name.

    F

    hr is a username.

    G

    test.us.oracle.com is an instance name.


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

  • 第24题：

    多选题
    You are developing an application that connects to a Microsoft SQL Server database using the SqlConnection object. Your connection objects are being pooled. As the pool fills up, connection requests are queued. Some connection requests are rejected. You need to ensure that the application releases connections back to the pool as soon as possible. Also, you need to decrease the likelihood that connection requests will be rejected. Which three actions should you perform?（）
    A

    Ensure that the Close method is called on each connection object after it has finished executing.

    B

    Ensure that each connection object is left open after it has finished executing.

    C

    Increase the Max Pool Size value inside the connection string.

    D

    Increase the Min Pool Size value inside the connection string.

    E

    Increase the Connection Lifetime value inside the connection string.

    F

    Increase the value of the ConnectionTimeout property of the SqlConnection object.


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

相关内容