单选题Which statement regarding the contents of the V$PARAMETER view is true？（）A displays only the list of default valuesB displays only the list of all basic parametersC displays the currently in effect parameter valuesD displays only the list of all advanc

第1题：

第2题：

Which CLI command displays statistical information about a policy called goldservice ?（）

• A、show ip interface atm 5/1.1
• B、show policy-list goldservice
• C、show profile name goldservice
• D、show rate-limit-profile goldservice

正确答案:A

第3题：

Your boss at Certkiller .com wants you to clarify Oracle 10g. 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
• F、Displays the current contents of the server parameter file.

正确答案:C

第4题：

The 'lsvg -o' command is run with an output of only rootvg, but the server has another volume group named datavg, which is notdisplayed. What is the likely cause?（）

• A、datavg is in an offline state.
• B、'lsvg -o' only displays the root volume group.
• C、'lsvg -o' only displays the fist volume group.
• D、datavg has no filesystems and therefore, is inactive.

正确答案:A

第5题：

Which two are true about aggregate functions? （）

• A、You can use aggregate functions in any clause of a SELECT statement.
• B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
• C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
• D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
• E、You can use aggregate functions on a table, only by grouping the whole table as one single group.
• F、You cannot group the rows of a table by more than one column while using aggregate functions.

正确答案:A,D

第6题：

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

正确答案:C

第7题：

Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCNAR2(14), 1oc VARCNAR2 (13)); ROLLBACK; DESCRIBE DEPT What is true about the set?（）

• A、The DESCRIBE DEPT statement displays the structure of the DEPT table.
• B、The ROLLBACK statement frees the storage space occupies by the DEPT table.
• C、The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
• D、The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.

正确答案:A

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Which of the following is TRUE about the ping  -f command?（）

• A、 It is useful for diagnosing data dependent problems by filling the packet with the byte pattern following the "f" in the command line. 
• B、 It is useful for flooding from slow character based terminals since it only displays a dot "." for each packet sent in fast mode. 
• C、 It is useful for flooding from slow character based terminals since it only displays a dot "."       for each packet sent and a backspace on returned in fast mode. 
• D、 The command can only be run by root.

正确答案:D

第14题：

Which two statements about IS reachability TLV (TLV 2) and the extended IS reachability (TLV 22) are true?（）

• A、TLV 22 supports wide metrics.
• B、TLV 2 is only used in Level 1 routers.
• C、TLV 22 displays the neighbor's extended areas.
• D、Only TLV 22 can support the inclusion of sub-TLVs.

正确答案:A,D

第15题：

Which single access list statement will combine all four of these statements into a single statement that will have exactly the same effect（）。

• A、access-list 10 permit 172.29.16.0 0.0.0.255
• B、access-list 10 permit 172.29.16.0 0.0.1.255
• C、access-list 10 permit 172.29.16.0 0.0.3.255
• D、access-list 10 permit 172.29.16.0 0.0.15.255
• E、access-list 10 permit 172.29.0.0 0.0.255.255

正确答案:C

第16题：

Which statement is true regarding syslog on Junos devices?（）

• A、No logging is enabled by default
• B、By default the information is stored in all file named events
• C、Only the message severity level must be configured
• D、You can configure the router to send log messages to the console

正确答案:D

第17题：

Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?（）

• A、The DESCRIBE DEPT statement displays the structure of the DEPT table.
• B、The ROLLBACK statement frees the storage space occupied by the DEPT table.
• C、The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
• D、The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.

正确答案:A

第18题：

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

正确答案:C

第19题：

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.

正确答案:C

第20题：

第21题：

第22题：

第23题：