单选题You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）A con

题目
单选题
You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）
A

control file

B

password file

C

listener controller file

D

control file and password file

相似考题

1.In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:Which authentication method would be used first?（）A. authentication by password fileB. authentication by using certificates over SSLC. authentication by using the Oracle Internet DirectoryD. authentication by using the local OS of the database server

2. ou executed the command to create a password file in the database server： $ orapwd file=orapworcl entries=5 ignorecase=N  Which statement describes the purpose of the above password file（）A、It records usernames and passwords of users when granted the DBA role.B、It contains usernames and passwords of users for whom auditing is enabled.C、It is used by Oracle to authenticate users for remote database administration.D、It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating system groups.

3.SQ L*Loader is a utility that can perform which two tasks？（）A、Load data from a disk， tape， or named pipes.B、Load data into an Oracle database using DML statements.C、Extract， reorganize， and insert data within an Oracle database.D、Load data from external files into tables in an Oracle database.E、Load data into an Oracle database using operating system commands.F、Load data directly from a non-Oracle database to an Oracle database.

4.Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus？（）A、The user must be granted the database administrator （DBA） privilege.B、The user must be listed in the password file for the authentication.C、No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.D、Set up a user in the Oracle Application Server Containers for J2EE （OC4J） user manager，and grant the webDba role to the user.

更多“单选题You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）A con”相关问题

  • 第1题：

    You work as a database administrator for Supportcenter.cn. You want to administer your database servers， which are running on different host machines， using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）

    • A、Application Server Control
    • B、Oracle Management Service
    • C、Oracle Enterprise Manager Repository
    • D、Oracle Enterprise Manager Database Control

    正确答案:C,D

  • 第2题：

    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

  • 第3题：

    A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance？（）

    • A、Data Pump
    • B、Oracle Net Manager
    • C、Oracle Enterprise Manager
    • D、Oracle Universal Installer （OUI）
    • E、Database Configuration Assistant （DBCA）

    正确答案:B,C

  • 第4题：

    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

  • 第5题：

    You executed the command to create a password file in the database server： $ orapwd file=orapworcl entries=5ignorecase=N  Which statement describes the purpose of the above password file（）

    • A、It records usernames and passwords of users when granted the DBA role.
    • B、It contains usernames and passwords of users for whom auditing is enabled.
    • C、It is used by Oracle to authenticate users for remote database administration.
    • D、It records usernames and passwords of all users when they are added to OSDBA or OSOPER operatingsystem groups

    正确答案:C

  • 第6题：

    You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）

    • A、control file
    • B、password file
    • C、listener controller file
    • D、control file and password file

    正确答案:B

  • 第7题：

    单选题
    In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?（）
    A

    Password file 

    B

    Initialization file 

    C

    Datafile 

    D

    Control file 

    E

    Nothing - SYSDBA privileges are not required for these actions


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

  • 第8题：

    单选题
    You are part of the DBA team working for a multinational bank. The team is responsible for performing administrative tasks on the database server located at the home office. The database server at the home office has a production database and a test database named TESTDB. The test database is primarily used for testing database commands and configuration settings befor implementing these settings on the production database. The test database is also used for the development of database applications. You have been asked by the senior DBA to grant the SYSDBA privilege to a new team member， John， so that he can perform some administrative tasks， such as shutdown and startup operations， on TESTDB. You use the password file to configure remote authentication on the TESTDB database. You execute the following statement to grant the SYSDBA privilege to John：   SQL>GRANT SYSDBA TO john；   However， you receive the following error：   ORA-01996： GRANT failed： password file   ’c：/oracle/ora9i/dbs/testdb.pwd’ is full   Which action should you take to add the user john to the password file without removing any of the existing users？（）
    A

     Create another password file and then re-execute the GRANT statement.

    B

     Re-create the password file， specifying a larger number of allowed entries， and then re-execute the GRANT statement.

    C

     Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in theinitialization parameter file to NONE and then re-execute the GRANT statement.

    D

     Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in the initialization parameter file to SHARED and then re-execute the GRANT statement.


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

  • 第9题：

    单选题
    You are a Database Administrator with TXGlobal. You use a password file to establish remote connections to the HR database on the server located at the home office. Currently， two active remote sessions exist to this database. These sessions were established using the SYSDBA privilege from the remote machines. You accidentally deleted the password file. What will be the consequence of this action？（）
    A

     Both the sessions will be killed， and no new sessions will be created using the SYSDBA or SYSOPER privilege.

    B

     Both the sessions will remain active， but no new sessions will be created using the SYSDBA or SYSOPER privilege.

    C

    Both the sessions will be killed， but new sessions will be created using the SYSDBA or SYSOPER privilege when the database restarts.

    D

     The database will crash， and no new sessions will be created using the SYSDBA or SYSOPER privilege when the database restarts.


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

  • 第10题：

    单选题
    You executed the command to create a password file in the database server： $ orapwd file=orapworcl entries=5ignorecase=N  Which statement describes the purpose of the above password file（）
    A

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

    B

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

    C

    It is used by Oracle to authenticate users for remote database administration.

    D

    It records usernames and passwords of all users when they are added to OSDBA or OSOPER operatingsystem groups


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

  • 第11题：

    单选题
    You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces？（）
    A

    SQL*Plus

    B

    iSQL*Plus

    C

    Management Server

    D

    Management Repository

    E

    Oracle Enterprise Manager 10g Database Control


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

  • 第12题：

    多选题
    You work as a database administrator for Certkiller .com. You want to administer your database servers，which are running on different host machines，using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）
    A

    Application Server Control

    B

    Oracle Management Service

    C

    Oracle Enterprise Manager Repository

    D

    Oracle Enterprise Manager Database Control


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

  • 第13题：

    You work as a database administrator for Supportcenter.cn. In your organization， you have four databases， SupportCenter DB01， SupportCenter DB02， SupportCenter DB03， and SupportCenter DB04， which are located in Berlin， Frankfurt，Rammstein， and Munich respectively， and which were created using Database Configuration Assistant （DBCA）. You want to perform administrative tasks on these databases that include startup and shutdown， taking regular backups， and so on， fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task？（）

    • A、Control file
    • B、Password file
    • C、Parameter file
    • D、Online redo log file
    • E、Listener controller file
    • F、Server parameter file

    正确答案:B

  • 第14题：

    You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces？（）

    • A、SQL*Plus
    • B、iSQL*Plus
    • C、Management Server
    • D、Management Repository
    • E、Oracle Enterprise Manager 10g Database Control

    正确答案:E

  • 第15题：

    In your database，the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory （OID）. SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command：$ SQLPLUS scott/tiger@DB01 AS SYSDBA   where DB01 is the net service name.   Which authentication method would be used first？（）  

    • A、 authentication by password file
    • B、 authentication by using certificates over SSL
    • C、 authentication by using the Oracle Internet Directory
    • D、 authentication by using the local OS of the database server

    正确答案:A

  • 第16题：

    You are part of the DBA team working for a multinational bank. The team is responsible for performing administrative tasks on the database server located at the home office. The database server at the home office has a production database and a test database named TESTDB. The test database is primarily used for testing database commands and configuration settings befor implementing these settings on the production database. The test database is also used for the development of database applications. You have been asked by the senior DBA to grant the SYSDBA privilege to a new team member， John， so that he can perform some administrative tasks， such as shutdown and startup operations， on TESTDB. You use the password file to configure remote authentication on the TESTDB database. You execute the following statement to grant the SYSDBA privilege to John：   SQL>GRANT SYSDBA TO john；   However， you receive the following error：   ORA-01996： GRANT failed： password file   ’c：/oracle/ora9i/dbs/testdb.pwd’ is full   Which action should you take to add the user john to the password file without removing any of the existing users？（）

    • A、 Create another password file and then re-execute the GRANT statement.
    • B、 Re-create the password file， specifying a larger number of allowed entries， and then re-execute the GRANT statement.
    • C、 Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in theinitialization parameter file to NONE and then re-execute the GRANT statement.
    • D、 Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in the initialization parameter file to SHARED and then re-execute the GRANT statement.

    正确答案:B

  • 第17题：

    You work as a database administrator for Certkiller .com. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）

    • A、Database Control
    • B、Management Server
    • C、Management Repository
    • D、Application Server Control
    • E、Oracle Management Agent

    正确答案:E

  • 第18题：

    单选题
    Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus？（）
    A

    The user must be granted the database administrator （DBA） privilege.

    B

    The user must be listed in the password file for the authentication.

    C

    No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.

    D

    Set up a user in the Oracle Application Server Containers for J2EE （OC4J） user manager，and grant the webDba role to the user.


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

  • 第19题：

    单选题
    You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）
    A

    When the instance is started 

    B

    When the database is mounted 

    C

    When the database is opened 

    D

    When the database is closed


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

  • 第20题：

    单选题
    In your database，the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory （OID）. SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command：$ SQLPLUS scott/tiger@DB01 AS SYSDBA   where DB01 is the net service name.   Which authentication method would be used first？（）
    A

     authentication by password file

    B

     authentication by using certificates over SSL

    C

     authentication by using the Oracle Internet Directory

    D

     authentication by using the local OS of the database server


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

  • 第21题：

    单选题
    ou executed the command to create a password file in the database server： $ orapwd file=orapworcl entries=5 ignorecase=N  Which statement describes the purpose of the above password file（）
    A

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

    B

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

    C

    It is used by Oracle to authenticate users for remote database administration.

    D

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


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

  • 第22题：

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


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

  • 第23题：

    单选题
    You work as a database administrator for Supportcenter.cn. In your organization， you have four databases， SupportCenter DB01， SupportCenter DB02， SupportCenter DB03， and SupportCenter DB04， which are located in Berlin， Frankfurt，Rammstein， and Munich respectively， and which were created using Database Configuration Assistant （DBCA）. You want to perform administrative tasks on these databases that include startup and shutdown， taking regular backups， and so on， fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task？（）
    A

    Control file

    B

    Password file

    C

    Parameter file

    D

    Online redo log file

    E

    Listener controller file

    F

    Server parameter file


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

  • 第24题：

    单选题
    You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）
    A

    control file

    B

    password file

    C

    listener controller file

    D

    control file and password file


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

相关内容