网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
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
参考答案
参考解析
解析:
暂无解析
更多 “单选题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” 相关考题
考题
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.
考题
You are designing a strategy for migrating the UNIX user accounts to Active Directory. Which three actions should you perform?()A、Import the user accounts as inetOrgPerson objects. B、Import the user accounts into Active Directory by using the Ldifde command-line tool. C、Export all user accounts from the UNIX servers to a text file. D、Export all user accounts and their passwords from the UNIX servers to a text file. Encrypt this file to achieve extra security. E、Assign random passwords to each user object, and securely distribute the password to the users. F、Create the same strong password for each user object, and require users to change their passwords at first logon.
考题
You issue this statement:ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What does the statement generate?()A、A text copy of the control file.B、A binary copy of the control file.C、A file containing a SQL statement which will re-create the database.D、A file containing a SQL statement which will re-create the control file.
考题
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.
考题
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.
考题
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.
考题
You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command?()A、DatafilesB、 Current control fileC、 Server parameter file (spfile)D、 Password file
考题
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 SYSDBAB、 CONNECT sys/admin AS SYSDBAC、 CONNECT sys/admin@mynewdb AS SYSDBAD、 CONNECT sys/change_on_install AS SYSDBA
考题
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: SQLGRANT 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.
考题
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.
考题
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
考题
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.
考题
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.
考题
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 fileB、password fileC、listener controller fileD、control file and password file
考题
You are designing a strategy for migrating the UNIX user accounts to Active Directory. Which three actions should you perform?()A、 Import the user accounts as inetOrgPerson objects.B、 Import the user accounts into Active Directory by using the Ldifde command-line tool.C、 Export all user accounts from the UNIX servers to a text file.D、 Export all user accounts and their passwords from the UNIX servers to a text file. Encrypt this file to achieve extra security.E、 Assign random passwords to each user object, and securely distribute the password to the users.F、 Create the same strong password for each user object, and require users to change their passwords at first logon.G、 Instruct users to use the same name and password as they used on the UNIX servers.
考题
单选题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: SQLGRANT 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.
考题
多选题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 passwords of users when granted the DBA role.BIt contains the usernames and passwords of users for whom auditing is enabled.CIs used by Oracle to authenticate users for remote database administration.DIt records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.EIt supports the SYSBACKUP, SYSDG, and SYSKM system privileges.
考题
单选题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.
考题
多选题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?()AIt will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.BIt contains username and passwords of database users who are members of the OSOPER operating system group.CIt contains usernames and passwords of database users who are members of the OSDBA operating system group.DIt will permit the use of lowercase passwords for database users who have granted the SYSDBA role.EIt will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.
考题
单选题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.
考题
多选题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?()AIt will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.BIt contains username and passwords of database users who are members of the OSOPER operating system group.CIt contains usernames and passwords of database users who are members of the OSDBA operating system group.DIt will permit the use of lowercase passwords for database users who have granted the SYSDBA role.EIt will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.
考题
多选题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?()AAssign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.BGrant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.CRe-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.DRe-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.ERe-create the password file in the Oracle Database 12c format.
考题
单选题You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command?()A
DatafilesB
Current control fileC
Server parameter file (spfile)D
Password file
考题
单选题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 SYSDBAB
CONNECT sys/admin AS SYSDBAC
CONNECT sys/admin@mynewdb AS SYSDBAD
CONNECT sys/change_on_install AS SYSDBA
考题
单选题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 are designing a strategy for migrating the UNIX user accounts to Active Directory. Which three actions should you perform?()AImport the user accounts as inetOrgPerson objects.BImport the user accounts into Active Directory by using the Ldifde command-line tool.CExport all user accounts from the UNIX servers to a text file.DExport all user accounts and their passwords from the UNIX servers to a text file. Encrypt this file to achieve extra security.EAssign random passwords to each user object, and securely distribute the password to the users.FCreate the same strong password for each user object, and require users to change their passwords at first logon.GInstruct users to use the same name and password as they used on the UNIX servers.
考题
单选题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 fileB
password fileC
listener controller fileD
control file and password file
热门标签
最新试卷