niusouti.com

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

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

相似考题

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. You are a Database Administrator with WonderWeb. You use a password file to establish connections to the Sales database located on the server. You created the password file using the following command：        ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4   You erroneously deleted the password file while the database was running. You re-create the password file using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=4   However， when you try to connect as the SYS user， you receive the following error：        ORA-01031： insufficient privileges   What should you do to resolve this error？（）A、 Delete the newly created password file and re-create another password file with the password admin， without shutting down the database.B、 Enable the operating system authentication， shut down the database， disable the operating system authentication， and restart the database using the password file.C、 Enable the operating system authentication， shut down the database， re-create the password file using the same ORAPWD command， and restart the database using the password file.D、 Delete the newly created password file， enable operating system authentication and shut down the database. Then， re-create another password file using the same ORAPWD command and restart the database using this password file.

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

4.You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).Examine the query and its output:Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?（）A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.E. Re-create the password file in the Oracle Database 12c format.

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

  • 第1题：

    You decide to enable Flashback Database in your Oracle 10g database so that future recoveries will take less time than traditional recoveries. Which of the following parameters must be included in your initialization parameter file before enabling Flashback Database？（）

    • A、 DB_RECOVERY_FILE_DEST only
    • B、 DB_FLASHBACK_RETENTION_TARGET only
    • C、 DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST only
    • D、 DB_RECOVERY_FILE_DEST and DB_FLASHBACK_RETENTION_TARGET only
    • E、 DB_RECOVERY_FILE_DEST_SIZE， DB_RECOVERY_FILE_DEST and
    • F、 DB_FLASHBACK_RETENTION_TARGET

    正确答案:C

  • 第2题：

    Which two file types must be included in a closed database backup taken with operating system commands？（）

    • A、data files
    • B、control file
    • C、password file
    • D、online redo log files
    • E、initialization parameter file

    正确答案:A,B

  • 第3题：

    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

  • 第4题：

    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

    正确答案:E

  • 第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题：

    单选题
    You decide to enable Flashback Database in your Oracle 10g database so that future recoveries will take less time than traditional recoveries. Which of the following parameters must be included in your initialization parameter file before enabling Flashback Database？（）
    A

     DB_RECOVERY_FILE_DEST only

    B

     DB_FLASHBACK_RETENTION_TARGET only

    C

     DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST only

    D

     DB_RECOVERY_FILE_DEST and DB_FLASHBACK_RETENTION_TARGET only

    E

     DB_RECOVERY_FILE_DEST_SIZE， DB_RECOVERY_FILE_DEST and

    F

     DB_FLASHBACK_RETENTION_TARGET


    正确答案： 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题：

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

  • 第10题：

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

  • 第11题：

    多选题
    You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?（）
    A

    Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.

    B

    Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

    C

    Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.

    D

    Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

    E

    Re-create the password file in the Oracle Database 12c format.


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

  • 第12题：

    单选题
    You are a Database Administrator with WonderWeb. You use a password file to establish connections to the Sales database located on the server. You created the password file using the following command：        ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4   You erroneously deleted the password file while the database was running. You re-create the password file using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=4   However， when you try to connect as the SYS user， you receive the following error：        ORA-01031： insufficient privileges   What should you do to resolve this error？（）
    A

     Delete the newly created password file and re-create another password file with the password admin， without shutting down the database.

    B

     Enable the operating system authentication， shut down the database， disable the operating system authentication， and restart the database using the password file.

    C

     Enable the operating system authentication， shut down the database， re-create the password file using the same ORAPWD command， and restart the database using the password file.

    D

     Delete the newly created password file， enable operating system authentication and shut down the database. Then， re-create another password file using the same ORAPWD command and restart the database using this password file.


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

  • 第13题：

    ou are implementing control file multiplexing. Which of the following choices identifies the method you can use in order to generate the control file copies that Oracle will maintain?（）

    • A、Issue ALTER DATABASE BACKUP CONTROLFILE TO filename
    • B、Make a copy of the control file with the database shut down
    • C、Issue ALTER DATABASE BACKUP CONTROLFILE TO trace
    • D、Make a copy of the control file with the database still running 

    正确答案:B

  • 第14题：

    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

  • 第15题：

    You have created a password file using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=3   Which of the following is true about this password file？（）

    • A、 If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.
    • B、 If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.
    • C、 If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then the SYSDBA and SYSOPER privileges can be granted to other users as long as space in the password file is
    • D、 If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then the SYSDBAand SYSOPER privileges can be granted to other users as long as space in the password file is available.

    正确答案:D

  • 第16题：

    The database is being restored from a closed backup. The data files， control files， password file， and parameter file are available， but the online redo logs are not. Because the online redo logs are not available， you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation？（）

    • A、until SCN
    • B、until time
    • C、until cancel
    • D、using backup control file

    正确答案:C

  • 第17题：

    You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?（）

    • A、Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
    • B、Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
    • C、Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.
    • D、Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
    • E、Re-create the password file in the Oracle Database 12c format.

    正确答案:B,D

  • 第18题：

    单选题
    ou are implementing control file multiplexing. Which of the following choices identifies the method you can use in order to generate the control file copies that Oracle will maintain?（）
    A

    Issue ALTER DATABASE BACKUP CONTROLFILE TO filename

    B

    Make a copy of the control file with the database shut down

    C

    Issue ALTER DATABASE BACKUP CONTROLFILE TO trace

    D

    Make a copy of the control file with the database still running 


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

  • 第19题：

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

  • 第20题：

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

  • 第21题：

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

  • 第22题：

    单选题
    You have created a password file using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=3   Which of the following is true about this password file？（）
    A

     If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.

    B

     If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.

    C

     If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then the SYSDBA and SYSOPER privileges can be granted to other users as long as space in the password file is

    D

     If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then the SYSDBAand SYSOPER privileges can be granted to other users as long as space in the password file is available.


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

  • 第23题：

    单选题
    The database is being restored from a closed backup. The data files， control files， password file， and parameter file are available， but the online redo logs are not. Because the online redo logs are not available， you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation？（）
    A

    until SCN

    B

    until time

    C

    until cancel

    D

    using backup control file


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

  • 第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
    解析： 暂无解析

相关内容