-
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
-
The rule regarding look-outs applies（）.
A . in restricted visibility
B . between dusk and dawn
C . in heavy traffic
D . All of the above
-
Which of the following statements are true regarding the Recycle Bin？（）
A . The Recycle Bin is a physical storage area for dropped objects.
B . The Recycle Bin is a logical container for dropped objects.
C . The Recycle Bin stores the results of a Flashback Drop operation.
D . The objects in the Recycle Bin are stored in the tablespace in which they were created.
-
Which two statements are true regarding the functionality of the remap command in ASMCMD？（）
A . It repairs blocks that have read disk I/O errors.
B . It checks whether the alias metadata directory and the file directory are linked correctly.
C . It repairs blocks by always reading them from the mirror copy and writing them to the original location.
D . It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.
-
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 is correct regarding the operation of DHCP?（）
A . A DHCP client uses a ping to detect address conflicts.(ARP)
B . A DHCP server uses a gratuitous ARP to detect DHCP clients.
C . A DHCP client uses a gratuitous ARP to detect a DHCP server.
D . If an address conflict is detected, the address is removed from the pool and an administrator must resolve the conflict.
E . If an address conflict is detected, the address removed from the pool for an amount of time configurable by the administrator.
F . If an address conflict is detected, the address is removed from the pool and will not be reused until server is rebooted.
-
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 statement is incorrect regarding RMAN？（）
A . It detects corrupt blocks.
B . It performs only offline database backups.
C . It omits empty blocks during backups.
D . It performs tablespace point-in-time recovery （TSPITR）.
-
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 three statements are true regarding the logical structure of the Oracle database？（）
A . Each segment contains one or more extents.
B . Multiple tablespaces can share single data file.
C . A data block is the smallest unit of I/O for data files.
D . It is possible to have tablespaces of different block sizes in a database.
E . Each data block in the database always corresponds to one OS block.
-
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 three statements are true regarding the functioning of the Autotask Background Process （ABP）？（）
A . It creates jobs without considering the priorities associated with them.
B . It translates tasks into jobs for execution by the scheduler.
C . It determines the list of jobs that must be created for each maintenance window.
D . It is spawned by the MMON background process at the start of the maintenance window.
E . It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.
-
Choose the true statement regarding QoS pre-classify.（）
A . QoS pre-classify permits making QoS decisions based on elements from the unencrypted IP packet.
B . QoS pre-classify is required when encrypting voice.
C . QoS pre-classify is an advantage to Service Providers transporting encrypted packets.
D . QoS pre-classify is not designed for IPSec/GRE configurations.
-
Which statements are true regarding the Query Result Cache? （）
A . It can be set at the system, session, or table level.
B . It is used only across statements in the same session.
C . It can store the results from normal as well as flashback queries.
D . It can store the results of queries based on normal, temporary, and dictionary tables.
-
Which statements are true regarding the Query Result Cache？（）
A . It can be set at the system， session， or table level.
B . It is used only across statements in the same session.
C . It can store the results from normal as well as flashback queries.
D . It can store the results of queries based on normal，temporary，and dictionary tables.
-
Which of the following are correct regarding ISDN?（）
A . Legacy DDR can use port information to define interesting traffic.
B . Legacy DDR can configure multiple dialer configurations on the same interface.
C . Legacy DDR can use ACLs to define interesting traffic.
D . HDLC or PPP can be used to encapsulate ISDN D channel information.
E . The BRI interfaces on ISDN routers with dialer profiles configured cannot belong to multiple dialer pools.
F . Dialer profiles cannot use extended ACLs to define interesting traffic.
-
Which two statements are true regarding the usage of the SQL*Loader utility（）
A . You can load data into multiple tables during the same load session.
B . You can load data from multiple files to a table during the same load session.
C . You cannot perform selective data loading based on the values available in the records.
D . You can use an export file generated by the EXPDP utility as an input data file to load the data.
E . You can load data only if the input file is available on the disk and tape but not in a named pipes.
-
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
-
Which two statements are true regarding the execution of the correlated subqueries？（）
A . The nested query executes after the outer query returns the row.
B . The nested query executes first and then the outer query executes.
C . The outer query executes only once for the result returned by the inner query.
D . Each row returned by the outer query is evaluated for the results returned by the inner query.
-
Which of the following statements regarding ISDN are correct?（）
A . Each ISDN B channel has transmission speeds of up to 64 kbps.
B . The ISDN B channel can carry video, voice or data.
C . The ISDN B channel transmission rate varies depending on the service used.
D . The ISDN D channel transmits control information.
E . The ISDN B channels can be configured with different subnets and encapsulation types when dialer profiles are configured.
-
Which of the following is true regarding the Gordon growth model?
-
2. Regarding the famous jazz musician Louis Armstrong, which of the following is false?
-
Regarding the future of the EU, the author seems to feel______.
A．pessimistic
B．desperate
C．conceited
D．hopeful
