1Z0-042单项选择题每日一练(2018.11.28)

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

A.All the extents will be of the same size.
B.Bitmap will be used to record free and allocated extents.
C.Free extents will be managed by the data dictionary tables.
D.The tablespace will be system managed and the users cannot specify the extent size.

A.The user must be granted the database administrator （DBA） privilege.
B.The user must be listed in the password file for the authentication.
C.No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.
D.Set up a user in the Oracle Application Server Containers for J2EE （OC4J） user manager，and grant the webDba role to the user.

A.ORA_PATH
B.ORACLE_SID
C.ORACLE_BASE
D.ORACLE_HOME
E.LD_LIBRARY_PATH

A.PMON coordinates media recovery.
B.SMON coordinates instance recovery.
C.PMON coordinates instance recovery.
D.Undo Advisor would roll back all uncommitted transactions.
E.SQL*PLUS reports an error with the message asking you to perform instance recovery.