多选题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?()AIt records the usernames and pass

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


相似考题

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.

更多“多选题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?()AIt records the usernames and pass”相关问题
  • 第1题:

    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

  • 第2题:

    You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?() (Choose two)

    • A、The KEEP option overrides the configured retention policy
    • B、The KEEP option is an attribute of an individual backup piece
    • C、The backup contains only data files and archived redo log files
    • D、The backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled

    正确答案:A,D

  • 第3题:

    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

  • 第4题:

    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

  • 第5题:

    You executed this command to create a password file: $ orapwd file = orapworcl entries = 10 ignorecase = N Which two statements are true about the password file?()

    • A、It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.
    • B、It contains username and passwords of database users who are members of the OSOPER operating system group.
    • C、It contains usernames and passwords of database users who are members of the OSDBA operating system group.
    • D、It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.
    • E、It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.

    正确答案:A,D

  • 第6题:

    多选题
    our database is in the MOUNT state and you execute the following command to open it:  ALTER DATABASE OPEN  What two actions are performed as a result of this command?()
    A

    All control files are opened.

    B

    All redo log files are opened

    C

    The password file is opened.

    D

    The parameter file is opened.

    E

    All online data files are opened.


    正确答案: D,E
    解析: 暂无解析

  • 第7题:

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

  • 第8题:

    多选题
    You executed this command to create a password file: $ orapwd file = orapworcl entries = 10 ignorecase = N Which two statements are true about the password file?()
    A

    It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.

    B

    It contains username and passwords of database users who are members of the OSOPER operating system group.

    C

    It contains usernames and passwords of database users who are members of the OSDBA operating system group.

    D

    It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.

    E

    It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.


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

  • 第9题:

    多选题
    On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?()
    A

    It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

    B

    It fails because no SQL *Loader data file location is specified.

    C

    It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

    D

    It fails because no SQL *Loader control file location is specified.


    正确答案: C,B
    解析: 暂无解析

  • 第10题:

    单选题
    You issued the following commands to configure setting in RMAN; Then you issued the following command to take the backup: RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which statement is true about the execution of the above command?()
    A

    The backup will terminate because the FORMAT clause was not configured for the channel

    B

    It backs up two copies of data files to tape and disk, and two copies of archived log file on tape

    C

    It backs up the data files and archived log files to disk, making two copies of each data file and archived log file

    D

    It backs up the data files and archived log files to tape, making two copies of each data file and archived log file


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

  • 第11题:

    多选题
    After performing a clean shut down of the database instance for maintenance, you mount thedatabase and then execute a command to open the database: SQL> ALTER DATABASE OPEN;  Which two statements are true()
    A

    The online redo log files and online data files are opened.

    B

    All the online data file headers are checked for consistency.

    C

    Instance recovery is performed before opening the database.

    D

    The path and existence of all the log file members are checked


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

  • 第12题:

    多选题
    Which two statements are true about the rescue configuration file?()
    A

    It must include a root password.

    B

    It is rollback file number 50, and you can recover it by issuing rollback 50.

    C

    It is created by issuing request system configuration rescue save.

    D

    It is updated automatically when you commit.


    正确答案: B,C
    解析: 暂无解析

  • 第13题:

    You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN; What two actions are performed as a result of this command?()

    • A、All control files are opened
    • B、All redo files are opened
    • C、The password file is opened
    • D、The parameter file is opened
    • E、All online data files are opened

    正确答案:B,E

  • 第14题:

    our database is in the MOUNT state and you execute the following command to open it:  ALTER DATABASE OPEN  What two actions are performed as a result of this command?()

    • A、All control files are opened.
    • B、All redo log files are opened
    • C、The password file is opened.
    • D、The parameter file is opened.
    • E、All online data files are opened.

    正确答案:B,E

  • 第15题:

    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

  • 第16题:

    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

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

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

  • 第19题:

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

  • 第20题:

    多选题
    You executed this command to create a password file: $ orapwd file = orapworcl entries = 10 ignorecase = N Which two statements are true about the password file?()
    A

    It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.

    B

    It contains username and passwords of database users who are members of the OSOPER operating system group.

    C

    It contains usernames and passwords of database users who are members of the OSDBA operating system group.

    D

    It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.

    E

    It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.


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

  • 第21题:

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

  • 第22题:

    多选题
    You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?() (Choose two)
    A

    The KEEP option overrides the configured retention policy

    B

    The KEEP option is an attribute of an individual backup piece

    C

    The backup contains only data files and archived redo log files

    D

    The backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled


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

  • 第23题:

    多选题
    You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN; What two actions are performed as a result of this command?()
    A

    All control files are opened

    B

    All redo files are opened

    C

    The password file is opened

    D

    The parameter file is opened

    E

    All online data files are opened


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

  • 第24题:

    多选题
    Which of the following are TRUE about a store archive?()
    A

    It is an XML file containing store data assets

    B

    It uses the same file format as a ZIP file

    C

    It contains file assets to create a store or site

    D

    It can easily be copied from one machine to another

    E

    It can contain WebSphere Commerce instance configuration information


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