All sessions of the HR user only
All sessions of the HR user and the SYS user
The session of the HR user that executed the commands
All the sessions for which the database users have access privilege to the PERSONS table
第1题:
In your database instance, the user sessions are connected to the database server from the remote machines.You want to achieve the following for these users: 1. The user account must be locked after four unsuccessful login attempts. 2. The user must be prompted to change the password at regular intervals. 3. The user may not have more than three simultaneous sessions. 4. The user session must automatically be logged off if more than 10 minutes elapsed time used. How would you accomplish the above()
第2题:
Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command: LSNRCTL> STOP What would happen to the sessions that are presently connected to the database instance?()
第3题:
Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions:What could have helped you to correlate server sessions with channels?()
A. Implement RMAN multiplexing
B. Set the DEBUG ON in the RMAN script
C. Specify the command ID in the RMAN script
D. Use a tag with the RMAN BACKUP command
第4题:
View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities:SQL> SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US FROM v$memory_dynamic_componentsWHERE current_size!=0;What do you infer from this()
第5题:
All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions:SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’; 123 rows updated.SQL> DELETE FROM persons WHERE exp=’Y’;3 rows deleted. The SYS user opens a new session after HR executed the above commands. Which sessions can see theeffect of the UPDATE and DELETE commands()
第6题:
You executed the following command in the lsnrctl utility to stop the listener: lsnrctl> STOP L1 What is the effect of this command if L1 is the only listener configured for your database?()
第7题:
All the database users are presently connected to the database instance and working. The HR userhas opened three database sessions and executed the following command in one of his sessions: SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’; 123 rows updated. SQL> DELETE FROM persons WHERE exp=’Y’; 3 rows deleted. The SYS user opens a new session after HR executed the above commands. Which sessions can seethe effect of the UPDATE and DELETE commands ()
第8题:
Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER byissuing the following command:lsnrctl >STOPWhat happens to the sessions that are presently connected to the database Instance?()
A. They are able to perform only queries.
B. They are not affected and continue to function normally.
C. They are terminated and the active transactions are rolled back.
D. They are not allowed to perform any operations until the listener LISTENER is started
第9题:
Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener byusing the command:LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance()
第10题:
You created a profile APP_USER and assigned it to the users. After a month, you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile: SQL> DROP PROFILE app_user; Which statement describes the result()