单选题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 requir

题目
单选题
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.

相似考题

1.Which of the following statements about ORACLE is (are) correct?Ⅰ.ORACLE follows SQL standardⅡ.ORACLE database defines two logical types: table and viewA．ⅠonlyB．Ⅱ onlyC．Ⅰ and ⅡD．none of the above

2.You are an experienced network administrator in an international corporation. One of your clients asks you to configure a network for a financial trading center which requires multiple high-value transactions.And the transactions are very important to the client. In such a situation, which two of the following are basic and most important requirements concerning the configuration? （）(Choose two.)A. no single point of failureB. determine which protocol to useC. trading database server locationD. deterministic response to all failures

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

4.Among the following post－listening activities, which one helps the teacher determine whether or not students have got the gist of what they have listened to?()A.summaryB.discussionC.role playD.simulation

更多“单选题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 requir”相关问题

  • 第1题：

    You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database（）

    • A、Use the external table population.
    • B、Use the Oracle Data Pump export and import utility.
    • C、Use the conventional path data load of the SQL*Loader utility.
    • D、Use the INSERT INTO...SELECT command to load the data

    正确答案:C

  • 第2题：

    our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）

    • A、Oracle Net Manager
    • B、Listener Control utility
    • C、Database Configuration Assistant
    • D、Oracle Net Configuration Assistant

    正确答案:B

  • 第3题：

    You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）

    • A、Corrupted blocks, if any, are repaired.
    • B、Checks are performed for physical corruptions.
    • C、Checks are performed for logical corruptions.
    • D、Checks are performed to confirm whether all database files exist in correct locations
    • E、Backup sets containing both data files and archive logs are created.

    正确答案:B,D

  • 第4题：

    You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）

    • A、Use the external table population.
    • B、Use the Oracle Data Pump export and import utility.
    • C、Use the conventional path data load of the SQL*Loader utility.
    • D、Use the INSERT INTO...SELECT command to load the data.

    正确答案:C

  • 第5题：

    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

  • 第6题：

    You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）

    • A、SYSTEM 
    • B、OUTLN 
    • C、INTERNAL 
    • D、SYS

    正确答案:D

  • 第7题：

    多选题
    You Execute the Following command to create a password file in the database server: $ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file?（）
    A

    It records the usernames and passwords of users when granted the DBA role.

    B

    It contains the usernames and passwords of users for whom auditing is enabled.

    C

    Is used by Oracle to authenticate users for remote database administration.

    D

    It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.

    E

    It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.


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

  • 第8题：

    单选题
    Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.  Which tool or utility would you use to start the listener？（）
    A

     Oracle Net Manager

    B

     Listener Control utility

    C

     Database Configuration Assistant

    D

     Oracle Net Configuration Assistant


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

  • 第9题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database（）
    A

    Use the external table population.

    B

    Use the Oracle Data Pump export and import utility.

    C

    Use the conventional path data load of the SQL*Loader utility.

    D

    Use the INSERT INTO...SELECT command to load the data


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

  • 第10题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）
    A

    use the external table population

    B

    use the Oracle Data Pump export and import utility

    C

    use the conventional path data load of SQL*Loader utility

    D

    use the direct path data load of Oracle export and import utility


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

  • 第11题：

    单选题
    Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）
    A

     V$DATABASE

    B

     V$UNDOSTAT

    C

     V$FLASHBACK_DATABASE_LOG

    D

     V$FLASHBACK_DATABASE_STAT


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

  • 第12题：

    单选题
    You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）
    A

    SYSTEM 

    B

    OUTLN 

    C

    INTERNAL 

    D

    SYS


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

  • 第13题：

    You are an experienced network administrator in an international corporation. One of your clients asks you to configure a network for a financial trading center which requires multiple high-value transactions. And the transactions are very important to the client. In such a situation, which two of the following are basic and most important requirements concerning the configuration? （）(Choose two.)

    • A、no single point of failure
    • B、determine which protocol to use
    • C、trading database server location
    • D、deterministic response to all failures

    正确答案:A,D

  • 第14题：

    You Execute the Following command to create a password file in the database server: $ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file?（）

    • A、It records the usernames and passwords of users when granted the DBA role.
    • B、It contains the usernames and passwords of users for whom auditing is enabled.
    • C、Is used by Oracle to authenticate users for remote database administration.
    • D、It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.
    • E、It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.

    正确答案:C,E

  • 第15题：

    While planning to manage more than one database in your system， you perform the following activities：  1. Organize different categories of files into independent subdirectories.  2. Use consistent naming convention for database files.  3. Separate administrative information pertaining to each database.  Which option corresponds to the type of activities performed by you？（）

    • A、Oracle Managed Files
    • B、Oracle Grid Architecture
    • C、Optimal Flexible Architecture
    • D、Oracle database architecture

    正确答案:C

  • 第16题：

    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

  • 第17题：

    Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）

    • A、 V$DATABASE
    • B、 V$UNDOSTAT
    • C、 V$FLASHBACK_DATABASE_LOG
    • D、 V$FLASHBACK_DATABASE_STAT

    正确答案:C

  • 第18题：

    You create 200 new user accounts. The users are located in six different sites. New users report that they receive the following error message when they try to log on： "The username or password is incorrect." You confirm that the user accounts exist and are enabled. You also confirm that the user name and password information supplied are correct. You need to identify the cause of the failure. You also need to ensure that the new users are able to log on Which utility should you run（）

    • A、Rsdiag
    • B、Rstools
    • C、Repadmin
    • D、Active Directory Domains and Trusts

    正确答案:C

  • 第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 are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）
    A

    Use the external table population.

    B

    Use the Oracle Data Pump export and import utility.

    C

    Use the conventional path data load of the SQL*Loader utility.

    D

    Use the INSERT INTO...SELECT command to load the data.


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

  • 第21题：

    单选题
    You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）
    A

    Library cache 

    B

    Row cache

    C

    Dictionary cache 

    D

    Large area 

    E

    Buffer cache


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

  • 第22题：

    多选题
    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
    解析： 暂无解析

  • 第23题：

    单选题
    You create 200 new user accounts. The users are located in six different sites. New users report  that they receive the following error message when they try to log on： "The username or  password is incorrect."     You confirm that the user accounts exist and are enabled. You also confirm that the user name  and password information supplied are correct.     You need to identify the cause of the failure. You also need to ensure that the new users are able  to log on.     Which utility should you run（）
    A

    Rsdiag

    B

    Rstools

    C

    Repadmin

    D

    Active Directory Domains and Trusts


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

相关内容