单选题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 r

题目
单选题
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 （）
A

all sessions of the HR user only

B

all sessions of the HR user and the SYS user

C

the session of the HR user that executed the commands

D

all the sessions for which the database users have access privilege to the PERSONS table

相似考题

1.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 multiplexingB. Set the DEBUG ON in the RMAN scriptC. Specify the command ID in the RMAN scriptD. Use a tag with the RMAN BACKUP command

2. 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？（）A、It terminates all user sessions.B、It prevents users from logging in to the database remotely.C、It halts the server until all user transactions are completed.D、The server hangs， so users will receive an error asking them to login again.E、Connected users would get an error with the message "End of communication channel".

3. 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？（）A、The sessions are able to perform only queries.B、The sessions are not affected and continue to function normally.C、The active transactions are rolled back and the sessions get terminated.D、The sessions are not allowed to perform any operations till the listener is started.

4.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

更多“单选题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 ro”相关问题

  • 第1题：

    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 （）

    • A、all sessions of the HR user only
    • B、all sessions of the HR user and the SYS user
    • C、the session of the HR user that executed the commands
    • D、all the sessions for which the database users have access privilege to the PERSONS table

    正确答案:C

  • 第2题：

    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（）

    • A、The sessions are able to perform only queries.
    • B、The sessions are not affected and continue to function normally.
    • C、The sessions are terminated and the active transactions are rolled back.
    • D、The sessions are not allowed to perform any operations till the listener is started

    正确答案:B

  • 第3题：

    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（）

    • A、The database instance is running with manual PGA management.
    • B、The database instance is running with manual shared memory management.
    • C、The database instance has the MEMORY_TARGET value set to a nonzero value.
    • D、All sessions are connected to the database instance in dedicated mode， and no RMAN or parallel queryoperations have been performed

    正确答案:C

  • 第4题：

    The user SCOTT executes the following command successfully to increase the salary values in one of his sessions：  SQL> UPDATE emp SET sal=sal*1.15 WHERE deptno=20；  Before SCOTT ends the transaction， user HR who has the privileges on EMP table executes a query to fetch the salary details but finds the old salary values instead of the increased values. Why does HR still see the old data？（）

    • A、because of redo data from redo log file
    • B、because of data from database buffer cache
    • C、because of data from a temporary tablespace
    • D、because of undo data from the undo tablespace

    正确答案:D

  • 第5题：

    Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command：  LSNRCTL> STOP  What happens to the sessions that are presently connected to the database instance（）

    • A、The sessions are able to perform only queries.
    • B、The sessions are not affected and continue to function normally.
    • C、The sessions are terminated and the active transactions are rolled back.
    • D、The sessions are not allowed to perform any operations till the listener is started.

    正确答案:B

  • 第6题：

    You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this？（）

    • A、Use the Database Resource Manager.
    • B、Set the limits in the profiles used by users.
    • C、Modify the SESSIONS initialization parameter.
    • D、Set the warning threshold for the Current Logons Count metric.

    正确答案:D

  • 第7题：

    单选题
    In your database instance， the user sessions are connected to the database server from the remotemachines. You want to achieve the following for these users：  1：The user account must be locked after four unsuccessful login attempts.PASSWORD_LOCK_TIME  2：The user must be prompted to change the password at regular intervals.PASSWORD_LIFE_TIME  3：The user may not have more than three simultaneous sessions.SESSIONS_PER_USER  4：The user session must automatically be logged off if more than 10 minutes elapsed time used.CONNECT_TIME  How would you accomplish the above（）
    A

    by assigning profiles for the users

    B

    by implementing Fine-Grained Auditing （FGA）

    C

    by granting a secure application role to the users

    D

    by implementing the Database Resource Manager plan


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    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（）
    A

    The database instance is running with manual PGA management.

    B

    The database instance is running with manual shared memory management.

    C

    The database instance has the MEMORY_TARGET value set to a nonzero value.

    D

    All sessions are connected to the database instance in dedicated mode， and no RMAN or parallel queryoperations have been performed


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    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 （）
    A

    all sessions of the HR user only

    B

    all sessions of the HR user and the SYS user

    C

    the session of the HR user that executed the commands

    D

    all the sessions for which the database users have access privilege to the PERSONS table


    正确答案： A
    解析： 暂无解析

  • 第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（）
    A

    The command produces an error.

    B

    The profile is dropped and current user sessions use the DEFAULT profile immediately.

    C

    The profile is dropped and only the subsequent user sessions use the DEFAULT profile.

    D

    The profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    The user SCOTT executes the following command successfully to increase the salary values in one of his sessions：  SQL> UPDATE emp SET sal=sal*1.15 WHERE deptno=20；  Before SCOTT ends the transaction， user HR who has the privileges on EMP table executes a query to fetch the salary details but finds the old salary values instead of the increased values. Why does HR still see the old data？（）
    A

    because of redo data from redo log file

    B

    because of data from database buffer cache

    C

    because of data from a temporary tablespace

    D

    because of undo data from the undo tablespace


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    The database users are connecting to the PROD database from different applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective？ （）
    A

    set the SESSIONS to 1 in the parameter file

    B

    grant SINGLE SESSION privilege to all of the users

    C

    set the SESSIONS_PER_USER to 1 in the users’ profile

    D

    grant RESTRICTED SESSION privilege to all of the database users

    E

    create a role with SINGLE SESSION privilege and assign the role to the users


    正确答案： A
    解析： 暂无解析

  • 第13题：

    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（）

    • A、All sessions of the HR user only
    • B、All sessions of the HR user and the SYS user
    • C、The session of the HR user that executed the commands
    • D、All the sessions for which the database users have access privilege to the PERSONS table

    正确答案:C

  • 第14题：

    Examine the commands executed to monitor database operations: $> conn sys oracle/oracle@prod as sysdba SQL > VAR eid NUMBER SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’); Which two statements are true?（）

    • A、Database operations will be monitored only when they consume a significant amount of resource.
    • B、Database operations for all sessions will be monitored.
    • C、Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.
    • D、Only DML and DDL statements will be monitored for the session.
    • E、All subsequent statements in the session will be treated as one database operation and will be monitored.

    正确答案:C,E

  • 第15题：

    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（）

    • A、The command produces an error.
    • B、The profile is dropped and current user sessions use the DEFAULT profile immediately.
    • C、The profile is dropped and only the subsequent user sessions use the DEFAULT profile.
    • D、The profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.

    正确答案:A

  • 第16题：

    User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance.  Which three operations would waitwhen issued in SCOTT’s second session（）

    • A、LOCK TABLE emp IN SHARE MODE；
    • B、LOCK TABLE emp IN EXCLUSIVE MODE；
    • C、UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？
    • D、INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；
    • E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno

    正确答案:A,B,E

  • 第17题：

    The current time zone for one of the user sessions is set to the database local time zone. For one application， the user session requires the time zone to be set to the local operating system time zone without affecting other user sessions. Which two solutions could the user implement to achieve this objective？ （）

    • A、 use the ALTER SYSTEM command to change the time zone
    • B、 use the ALTER SESSION command to change the time zone
    • C、 use the ALTER DATABASE command to change the time zone
    • D、 set the value for the operating system variable ORA_SDTZ on the client machine
    • E、 set the value for the operating system variable ORA_SDTZ on the database server machine

    正确答案:B,D

  • 第18题：

    The database users are connecting to the PROD database from different applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one. Which action would you take to achieve this objective？ （）

    • A、set the SESSIONS to 1 in the parameter file
    • B、grant SINGLE SESSION privilege to all of the users
    • C、set the SESSIONS_PER_USER to 1 in the users’ profile
    • D、grant RESTRICTED SESSION privilege to all of the database users
    • E、create a role with SINGLE SESSION privilege and assign the role to the users

    正确答案:C

  • 第19题：

    单选题
    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？（）
    A

    The sessions are able to perform only queries.

    B

    The sessions are not affected and continue to function normally.

    C

    The active transactions are rolled back and the sessions get terminated.

    D

    The sessions are not allowed to perform any operations till the listener is started.


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    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（）
    A

    All sessions of the HR user only

    B

    All sessions of the HR user and the SYS user

    C

    The session of the HR user that executed the commands

    D

    All the sessions for which the database users have access privilege to the PERSONS table


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    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（）
    A

    The sessions are able to perform only queries.

    B

    The sessions are not affected and continue to function normally.

    C

    The sessions are terminated and the active transactions are rolled back.

    D

    The sessions are not allowed to perform any operations till the listener is started


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    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？（）
    A

    It terminates all user sessions.

    B

    It prevents users from logging in to the database remotely.

    C

    It halts the server until all user transactions are completed.

    D

    The server hangs， so users will receive an error asking them to login again.

    E

    Connected users would get an error with the message End of communication channel.


    正确答案： D
    解析： 暂无解析

  • 第23题：

    多选题
    User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance.  Which three operations would waitwhen issued in SCOTT’s second session（）
    A

    LOCK TABLE emp IN SHARE MODE；

    B

    LOCK TABLE emp IN EXCLUSIVE MODE；

    C

    UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？

    D

    INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；

    E

    SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno


    正确答案： A,D
    解析： 暂无解析

  • 第24题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

相关内容