Use the CHANGE_PASSWORD command of the Listener control utility.
Use the SET PASSWORD and SAVE_CONFIG commands of the Listener control utility.
Use the CHANGE_PASSWORD and SAVE_CONFIG commands of the Listener control utility.
Manually modify the listener.ora file to include the password for the listener and restart the listener.
第1题:
You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces?()
第2题:
You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?()
第3题:
In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective?()
第4题:
You want to migrate your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?()
第5题:
You want to migrate your existing non/x7fASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?()
第6题:
functions
packages
procedures
database triggers
anonymous PL/SQL block
第7题:
REBUILD
CASCADE
TRUNCATE
ROW MOVEMENT
SHRINK SPACE COMPACT
SHRINK SPACE CASCADE
第8题:
executing the SET PASSWORD command and then the SAVE_CONFIG command
executing the CHANGE_PASSWORD command and then the SAVE_CONFIG command
executing the CHANGE_PASSWORD command and then the SET PASSWORD command
executing the SET PASSWORD command, then the CHANGE_PASSWORD command and finally, the SAVE_CONFIG command
第9题:
SQL*Plus
iSQL*Plus
Management Server
Management Repository
Oracle Enterprise Manager 10g Database Control
第10题:
Data Pump Export and Import
conventional export and import
the CONVERT command of RMAN
the BACKUP AS COPY. command of RMAN
第11题:
the CONVERT command of RMAN
Data Pump Export and Import into the same database
conventional export and import into the same database
the BACKUP DATABASE and RESTORE DATABASE commands of RMAN
the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN
第12题:
Create the role with global authentication.
Create the role with external authentication.
Create the role as a secure application role.
Create the role as a password-protected role.
Create a role and use Fine-Grained Access Control (FGAC) to secure the role.
第13题:
You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database, you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective?()
第14题:
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?()
第15题:
You want your listener to be password protected to prevent it from being shut down. You want to accomplish this task while the listener is functional. Which method could you use to achieve this objective?()
第16题:
You observe that in your PROD database, customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use to accomplish this task?()
第17题:
You previously secured your listener with an encrypted password. However, you need to set a new password for security reasons. What is the correct method for setting a new encrypted password for the listener using the Listener Control utility?()
第18题:
owner
touser
include
schemas
fromuser
transform
remap_schema
remap_datafile
reuse_datafiles
remap_tablespace
第19题:
It would attempt to start the default listener
It would start the most recently created listener.
It would display an error with a message asking for the listener name to be specified.
It would show you a list of listeners and prompts for the listener name that you want to start.
第20题:
show access-list
show ip access-list
show ip interface
show interface
show interface list
第21题:
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
第22题:
resetconfig
restoreconfig
loadconfig
reload
第23题:
REBUILD
CASCADE
TRUNCATE
ROW MOVEMENT
SHRINK SPACE COMPACT
SHRINK SPACE CASCADE
第24题:
Use the CHANGE_PASSWORD command of the Listener control utility.
Use the SET PASSWORD and SAVE_CONFIG commands of the Listener control utility.
Use the CHANGE_PASSWORD and SAVE_CONFIG commands of the Listener control utility.
Manually modify the listener.ora file to include the password for the listener and restart the listener.