-
Which statement is true regarding the COALESCE function?（）
A . It can have a maximum of five expressions in a list
B . It returns the highest NOT NULL value in the list for all rows
C . It requires that all expressions in the list must be of the same data type
D . It requires that at least one of the expressions in the list must have a NOT NULL value
-
Which 4 statements regarding MPLS Label Stack Encoding is true？（）
A . A value of 4 represents the "Implicit NULL Label."
B . A value of 0 represents the "IPv4 Explicit NULL Label."
C . A value of 1 represents the "Router Alert Label". The use of this label is analogous to the use of the"Router Alert Option" in IP packets （for example， ping with record route option）
D . A value of 2 represents the "IPv6 Explicit NULL Label"
E . A value of 1 represents the "IPv1 Explicit NULL Label"
F . A value of 3 represents the "Implicit NULL Label"
-
Which statement is true regarding subqueries?（）
A . The LIKE operator cannot be used with single-row subqueries
B . The NOT IN operator is equivalent to IS NULL with single-row subqueries
C . =ANY and =ALL operators have the same functionality in multiple-row subqueries
D . The NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries&e
-
Which statement is true regarding Oracle Shared Server architecture？（）
A . A dispatcher can support multiple client connects concurrently while a shared server process can be dedicated to only one dispatcher.
B . Under the Oracle Shared Server architecture, client-user processes connect to shared user processes.
C . Each dispatcher has its own request queue, which is monitored every three seconds by the dispatcher.
D . Oracle Shared Server required Oracle Net Service even if the client and shared server processes reside on the same machine.
-
Which statement is true regarding the Port Aggregation Protocol？ （）
A . Configuration changes made on the port-channel interface apply to all physical ports assigned to the portchannel interface.
B . Configuration changes made on a physical port that is a member of a port-channel interface apply to the port-channel interface.
C . Configuration changes are not permitted with Port Aggregation Protocol； instead， the standardized Link Aggregation Control Protocol should be used if configuration changes are required.
D . The physical port must first be disassociated from the port-channel interface before any configuration changes can be made.
-
Which statement regarding 802.1X is true?（）
A . 802.1X is simple to implement on any workstation.
B . 802.1X requires access-lists to allow IP voice traffic across.
C . Authentication is initiated when the workstation connects to an Ethernet port.
D . 802.1X requires HTTP access to initiate authentication.
-
Which statement is true regarding virtual private catalogs?（）
A . A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.
B . The virtual private catalog owner cannot create and modify the stored scripts.
C . The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
D . To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database
-
What statements are true regarding ICMP packets?（）
A . They acknowledge receipt of TCP segments.
B . They guarantee datagram delivery.
C . They can provide hosts with information about network problems.
D . They are encapsulated within IP datagrams.
E . They are encapsulated within UDP datagrams.
-
Which statement is true regarding the INTERSECT operator?（）
A . It ignores NULL values
B . Reversing the order of the intersected tables alters the result
C . The names of columns in all SELECT statements must be identical
D . The number of columns and data types must be identical for all SELECT statements in the query&e
-
Which statement is true regarding virtual private catalogs? （）
A . A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.
B . The virtual private catalog owner cannot create and modify the stored scripts.
C . The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
D . To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.&e
-
Which statement is true regarding Backup tasks in Cisco UCS？（）
A . They are created automatically and stored on the FI
B . They are created manually and exported to a remote server
C . They are automatically scheduled to run every 24 hours
D . They are manually scheduled and stored on the FI
-
What two statements are true regarding the recommendations received from the SQL Access Advisor？（）
A . It cannot generate recommendations that support multiple workload queries.
B . It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.
C . It can recommend partitioning only on tables that have at least 10，000 rows.
D . It can recommend only B-tree indexes and not bitmap or function-based indexes.
-
Which statement is true regarding RMAN components？（）
A . Each target database requires its own recover catalog.
B . RMAN scripts can be stored in the recovery catalog or the target control file.
C . A channel is a stream of data to a device type and corresponds to one server session.
D . The RMAN executable interprets sever session commands and establishes connections to the target database.
-
Which two statements regarding the IS-IS DIS election process are true？ （）
A . A priority of 0 will prevent a router from becoming a DIS.
B . If the DIS becomes unavailable the backup DIS is promoted to DIS.
C . Adding a router with a higher priority than the current DIS will result in the new router becoming DIS.
D . Separate L1 and L2 election processes are held on a brodcast network.
E . L1 routers on a broadcast network only establish adjacencies with the DIS.
F . If there is a tie based on priority，the router whose attached interface has the lowest MAC address becomes the DIS.
-
Which statement is true regarding Flashback Version Query？ （）
A . It returns versions of rows only within a transaction.
B . It can be used in subqueries contained only in a SELECT statement.
C . It will return an error if the undo retention time is less than the lower bound time or SCN specified.
D . It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.
-
Which statement is true regarding synonyms?（）
A . Synonyms can be created only for a table
B . Synonyms are used to reference only those tables that are owned by another user
C . A public synonym and a private synonym can exist with the same name for the same table
D . The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid
-
Which statement is true regarding virtual private catalogs？（）
A . A virtual private catalog owner can create a local stored script， and have read/write access to a global stored script.
B . The virtual private catalog owner cannot create and modify the stored scripts.
C . The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
D . To perform most of the RMAN operations， the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.
-
Which statement is true regarding checkpoints and recovery？（）
A . A checkpoint defines the highest system change number （SCN）.
B . All redo entries higher or at the SCN are known to be written to the data files.
C . Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery.
D . The LOG_CHECKPOINT_INTERVAL initialization parameter specifies the amount of time between incremental checkpoints.
-
What statement is true regarding processor allocation when implementing micro-partitions？ （）
A . The minimum configurable capacity allocation is 1.0 core and the minimum increment is 0.1 core.
B . The minimum configurable capacity allocation is 0.1 core and the minimum increment is 0.01 core.
C . The minimum configurable capacity allocation is 1.0 core and the minimum increment is 0.01 core.
D . The minimum configurable capacity allocation is 0.1 core and the minimum increment is 0.001
-
Which statement is true regarding this setting?（）
A . It drops the connection after the specified number of login attempts fail for any user.
B . It is enforced only if the password profile is enabled for the user.
C . It locks the user account after the specified number of attempts.
D . It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.
-
What is true regarding the role Oracle Net provides in a client server connection with no middle tier？（）https://assets.asklib.com/images/image2/201808011106157721.jpg
A . A
B . B
C . C
D . D
-
What is true regarding a transaction executed in Automatic Undo Management mode？（）https://assets.asklib.com/images/image2/2018080111005595434.jpg
A . A
B . B
C . C
D . D
-
What is true regarding Autonomous Systems （AS ）？（）
A . AS numbers are assigned by the IANA
B . AS numbers are used by BGP （Border Gateway protocol ） to exchange IP routing information with neighboring AS
C . In the internet， an Autonomous System （AS） is a collection of IP networks and routers under the control
D . All of the Above
-
What is true regarding direct-load insert？（）
A . A direct-load insert can be invoked by suing the APPEND hint.
B . Inserting using the NOLOGGING option is the default for direct-load inserts.
C . All data loaded using direct-load insert is loaded below the high-water mark.
D . An object that is modifies using parallel direct-load can be queried within the same Transaction.
