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?()
第1题:
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?()
第2题:
You are maintaining your database in Oracle10g. While performing an incremental backup of the database, you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database?()
第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?()
第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?()
第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()
第6题:
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?()
第7题:
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?()
第8题:
Both the sessions will be killed, and no new sessions will be created using the SYSDBA or SYSOPER privilege.
Both the sessions will remain active, but no new sessions will be created using the SYSDBA or SYSOPER privilege.
Both the sessions will be killed, but new sessions will be created using the SYSDBA or SYSOPER privilege when the database restarts.
The database will crash, and no new sessions will be created using the SYSDBA or SYSOPER privilege when the database restarts.
第9题:
It records usernames and passwords of users when granted the DBA role.
It contains usernames and passwords of users for whom auditing is enabled.
It is used by Oracle to authenticate users for remote database administration.
It records usernames and passwords of all users when they are added to OSDBA or OSOPER operatingsystem groups
第10题:
Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.
Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
Re-create the password file in the Oracle Database 12c format.
第11题:
by using the STATUS command of the Listener control utility
by using the STATUS L1 command of the Listener control utility
by using the SHOW RULES command of the Listener control utility
by using the SET PASSWORD command of the Listener control utility
by searching for the PASSWORD_LISTENER entry in the listener.ora file
第12题:
control file
password file
listener controller file
control file and password file
第13题:
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?()
第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?()
第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?()
第16题:
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?()
第17题:
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?()
第18题:
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?()
第19题:
It records the usernames and passwords of users when granted the DBA role.
It contains the usernames and passwords of users for whom auditing is enabled.
Is used by Oracle to authenticate users for remote database administration.
It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.
It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.
第20题:
rman TARGET / NOCATALOG
rman TARGET sys/password
rman TARGET sys/password AS SYSDBA
rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat
第21题:
It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.
It contains username and passwords of database users who are members of the OSOPER operating system group.
It contains usernames and passwords of database users who are members of the OSDBA operating system group.
It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.
It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.
第22题:
Datafiles
Current control file
Server parameter file (spfile)
Password file
第23题:
redo log files
password file
control file
change tracking file