Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.) A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds B. SYSDATE can be queried only from the DUAL table C. CURRENT_DATE returns the current date and time as per the session… Read More »
In one of your databases, you create a user, HR, and then execute this command:GRANT CREATE SESSION TO hr WITH ADMIN OPTION;Which three actions can HR perform? (Choose three.) A. Revoke the CREATE SESSION privilege from other users B. Revoke the CREATE SESSION privilege from user HR C. Log in to the database instance D. Grant the CREATE… Read More »
In one of your databases, you create a user, HR, and then execute this command:GRANT CREATE SESSION TO hr WITH ADMIN OPTION;Which three actions can HR perform? (Choose three.) A. Revoke the CREATE SESSION privilege from other users B. Revoke the CREATE SESSION privilege from user HR C. Log in to the database instance D. Grant the CREATE… Read More »
A user complains about poor database performance. You suspect that the user’s session is waiting for an event to complete.You want to verify this.Which two views may reveal for what the user’s session is currently waiting? (Choose two.) A. V$SYSTEM_EVENT B. V$SESSION C. V$SESSION_WAIT D. V$SESSION_EVENT E. V$SESSION_WAIT_CLASS Correct Answer: C,D
Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.) A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds B. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server C. CURRENT_DATE returns… Read More »
Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.) A. SYSDATE can be used in expressions only if the default date format is DD-MON-RR B. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE C. SYSDATE and CURRENT_DATE return the current date and time set for the operating system… Read More »
Consider this method declaration:A) “SET SESSION AUTHORIZATION ” + userB) “SET SESSION AUTHORIZATION ” + stmt.enquoteIdentifier(user)Is A or B the correct replacement for <EXPRESSION> and why? A. B, because all values provided by the calling code should be enquoted. B. A, because it is unnecessary to enclose identifiers in quotes. C. A, because it sends exactly the value… Read More »
A. Configure a targeted neighbor session. B. Configure an access list on the interface to permit TCP and UDP traffic. C. Configure a Cisco MPLS TE tunnel on both ends of the session. D. Configure the interface bandwidth to handle TCP and UDP traffic between the LDP peers. Answer: Option A. Explanation: https://www.cisco.com/c/en/us/td/docs/ios-xml/ios/mp_ldp/configuration/12-4m/mp-ldp-12-4m-book.pdf Show AnswerDiscussion The post An… Read More »
Refer to the exhibit. Router 1 and router 2 are running OSPF Area 0. The router logs on both routers show that the LDP link has flapped. Which configuration must the engineer apply to the two routers to implement session protection on the link? A. Router 1(config)# ip cef distributed Router 1(config)# mpls ldp session protection global Router… Read More »
Refer to the exhibit. The network team must implement MPLS LDP session protection with two requirements: * Session protection is provided for core loopback IP addresses only. * The LDP session must remain operational for one hour when the WAN link on PE-XR1 fails. Which configuration must the team implement on PE-XR1? A. configure terminal ipv4 access-list LDP-SESSION-PROTECTION… Read More »