-
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 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 one of the following answer choices below is true regarding the OSPF topology database?（）
A . All entries in the topology database will be included on each router.
B . All routers in the same OSPF area will have one topology database.
C . The Dijkstra algorithm is used in the creation of the topology database.
D . LSA packets are used to update and maintain the topology database.
-
Which of the following statements is TRUE regarding automatic identification systems (AIS)? （）
A . AIS is a short-range VHF-FM system that automatically broadcasts a vessel's position，course，speed and other safety related information to all those with similar equipment in the area
B . AIS is a one-way centrally managed system that requires the local VTS to send commands to instruct each vessel to broadcast position，course，speed and other safety related information to all those with similar equipment in the area
C . AIS is a global tracking system that relies upon INMARSAT C service to communicate vessel position，course，speed and other safety related information to all those with similar equipment in the area
D . AIS is a short-range 3 cm X-band radar system that automatically sends a vessel's position，course，speed and other safety related information to all those with similar equipment within the area
-
Which of the following statements is TRUE regarding automatic identification systems (AIS) ? （）
A . AIS may be used to make passing arrangements via ship-to-ship text messaging thus relieving a vessel operator from sounding whistle signals or making contact via radiotelephone
B . AIS may be used to make passing arrangements via ship-to-ship text messaging but a vessel operator is still required to sound whistle signals unless the arrangement is made via radiotelephone
C . AIS cannot be used to make passing arrangements because the system does not have the ability to communicate from ship-to-ship in this manner
D . AIS cannot be used to make passing arrangements because the use of the ship-to-ship text messaging feature in this way is prohibited
-
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 of the following statements is true regarding the VERSIONS BETWEEN clause？（）
A . The VERSIONS BETWEEN clause may be used in DML statements.
B . The VERSIONS BETWEEN clause may be used in DDL statements.
C . The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.
D . The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.
-
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 regarding the contents of the V$PARAMETER view is true？（）
A . displays only the list of default values
B . displays only the list of all basic parameters
C . displays the currently in effect parameter values
D . displays only the list of all advanced parameters
E . displays the list of all the parameter files of a database
-
Which of the following statements is true regarding implementing a Flashback Table recovery？ （）
A . An SCN is never used to perform a Flashback Table recovery.
B . If a significant number of changes have been made to the table， row movement must be enabled.
C . The tablespace must be offline before performing a Flashback Table recovery.
D . Flashback Table recovery is completely dependent on the availability of undo data in the undo tablespace.
-
Which of the following is true regarding Label Distribution Protocol （LDP）？（）
A . It is a label distribution protocol for MPLS
B . It is a set of procedures and messages by which LSRs establish Label Switch Paths （LSPs） through a network
C . Tag distribution Protocol （TDP） was the basis for LDP
D . All of the above are true
-
Which of the following statements is TRUE regarding crane operations（）.
A . Radio communications allow the crane operator to disregard the use of hand signals
B . The crane operators and signalman must be familiar with the correct hand signals
C . The forward cranes can be operated from the bridge
D . The aft cranes can be operated from the aft steering statio
-
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.
-
What two statements are true regarding the recommendations received from the SQL Access Advisor?（）(Choose two.)
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 indexe
-
Which one is true as regards to the hard hat according to the passage?（）
A . It needs not to be regularly replaced
B . It is designed to protect from possible impact
C . It is required to be worn on deck at all times by all ships
D . fibreglass hardhat should not be used on board shi
-
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
-
What is true regarding InnoDB locking?（）
A . InnoDB uses row and table-level locks, but row locks are not escalates
B . InnoDB locks only those rows that are updated
C . InnoDB only uses row locks, not page or table-level locks
D . InnoDB row locks may be escalated to page or table-level locks
E . InnoDB uses row-level or table-level locks depending on the number of rows affected
-
Which of the following statements is TRUE regarding automatic identification systems (AIS) ?（）
A . AIS cannot be used to make passing arrangements because the system is not capable of this type of ship-to-ship communications
B . AIS cannot be used to make passing arrangements because the ship-to-ship text messaging feature is for emergency use only
C . AIS can be used to make passing arrangements via ship-to-ship text messaging but a vessel operator is not relieved from the requirement to sound whistle signals or make arrangements via bridge-to-bridge radiotelephone
D . AIS can be used to make passing arrangements via ship-to-ship text massaging thus relieving a vessel operator from making such arrangements via bridge-to-bridge radiotelephone or signaling intent to pass via whistle signal
-
Which of the following is true regarding the effect of EIGRP queries on the network design？（）
A . EIGRP queries will be the most significant issue with respect to stability and convergence
B . EIGRP queries are not a consideration as long as EIGRP has a feasible successor with a nexthop AD that is greater than the FD of the current successor route
C . EIGRP queries will only increase the convergence time when there are no EIGRP stubsdesigned in the network
-
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.
-
Which of the following is true regarding the Gordon growth model?
-
Which of the following is/are true regarding debits and credits？
A．In any given transaction, the total dollar amount of the debits and the total dollar amount of the credits must be equal．
B．Debits decrease certain accounts and credits decrease certain accounts．
C．Liabilities and owner’s equity accounts usually end in credit balances; assets usually end in debit balances．
D．All of the abov
E．
-
Which of the following is not true regarding a company’s distinctive competencies（）
A．They represent the unique strengths of the company
B．They refer to company strengths that competitors cannot easily match or imitate
C．They form the bedrock of a company’s strategy
D．They can be based in any of the value creation functions of the company
E．They are shared by many firms in an industry
