网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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 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 executed this command to create a password file:$ orapwd file = orapworcl entries = 10 ignorecase = NWhich 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 are the network administrator for Ezonexam.You are planning to upgrade Windows NT Server 4.0 computers to Windows 2000 Server. You want to perform. the upgrades by means of a distribution folder. You need to install a custom application as part of the upgrade.You need to include the commands necessary so that the custom application is installed as part of the upgrade process.What should you do? (Each correct answer presents part of the solution. Choose two)A．Create a command file named Unattend.txt to install the application.B．Create a command file named Cmdlines.txt to install the application.C．Copy the command file to the \$OEM\$C\ subfolder under the i386 folder.D．Copy the command file to the subfolder named \$OEM$ under the i386 folder.E．Copy the command file to the subfolder named \$OEM$\textmode under the i386 folder.
考题
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 executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）A、Image of the control fileB、Location of the control fileC、Contents of the control file in text formatD、SQL command to re-create the databaseE、SQL command to re-create the control fileF、Contents of the control file in binary format
考题
You were recently hired by Certkiller .com as a database administrator. You are asked to find out whether the currently functional listener process， named L1， has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task？（）A、 by using the STATUS command of the Listener control utilityB、 by using the STATUS L1 command of the Listener control utilityC、 by using the SHOW RULES command of the Listener control utilityD、 by using the SET PASSWORD command of the Listener control utilityE、 by searching for the PASSWORD_LISTENER entry in the listener.ora file
考题
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 want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository. Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）A、 rman TARGET / NOCATALOGB、 rman TARGET sys/passwordC、 rman TARGET sys/password AS SYSDBAD、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat
考题
You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）A、Start the instance and open the database, instance recovery automatically recovers control files B、Create a file based on the contents of the trace file and save it to the control file locations and start the database C、Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) D、Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. E、Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
考题
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 have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（） A、 You will need to open the database with the resetlogs command.B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C、 You will use the resetlogs version of the create controlfile command.D、 You will use the noresetlogs version of the create controlfile command.E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command
考题
Which statement about using RMAN stored scripts is true?（）A、To create and execute an RMAN stored script, you must use a recovery catalog.B、When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.C、RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.D、When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.
考题
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 were recently hired by an organization as a database administrator. You are asked to find out whether the currently functional listener process， named L1， has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task？（）A
by using the STATUS command of the Listener control utilityB
by using the STATUS L1 command of the Listener control utilityC
by using the SHOW RULES command of the Listener control utilityD
by using the SET PASSWORD command of the Listener control utilityE
by searching for the PASSWORD_LISTENER entry in the listener.ora 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 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 want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository. Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）A
rman TARGET / NOCATALOGB
rman TARGET sys/passwordC
rman TARGET sys/password AS SYSDBAD
rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat
考题
多选题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 work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）A
Start the instance and open the database， instance recovery automatically recoverscontrol filesB
Create a file based on the contents of the trace file and save it to the control file locations and start the databaseC
Re-create the database （The recovery of the control file is not possible because you have lost all the control files.）D
Start the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.E
Start the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
考题
单选题Which statement about using RMAN stored scripts is true?（）A
To create and execute an RMAN stored script, you must use a recovery catalog.B
When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.C
RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.D
When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.
考题
单选题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 have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（）A
You will need to open the database with the resetlogs command.B
All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C
You will use the resetlogs version of the create controlfile command.D
You will use the noresetlogs version of the create controlfile command.E
You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command
考题
单选题You executed the following command in Recovery Manager （RMAN）： RMAN RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（）A
back up the control file to traceB
bring database to the MOUNT stateC
open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target databaseD
set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
考题
单选题You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）A
Image of the control fileB
Location of the control fileC
Contents of the control file in text formatD
SQL command to re-create the databaseE
SQL command to re-create the control fileF
Contents of the control file in binary format
考题
多选题You work as a database administrator for Supportcenter.cn. 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？（）AAll control files are openedBAll redo files are openedCThe password file is openedDThe parameter file is openedEAll online data files are opened
热门标签
最新试卷
