单选题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?（）

Password file

Initialization file

Datafile

Control file

Nothing - SYSDBA privileges are not required for these actions

参考答案和解析

正确答案： A

解析：暂无解析

更多“单选题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题

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

点击查看答案
第3题

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 isD、 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.

点击查看答案
第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

点击查看答案
第5题

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 SCNB、until timeC、until cancelD、using backup control file

点击查看答案
第6题

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

点击查看答案
第7题

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

题目

参考答案和解析

更多“单选题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题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容