-
Which of these statements concerning the collection interfaces are true？（）
A . Set extends Collection.
B . All methods defined in Set are also defined in Collection.
C . List extends Collection.
D . All methods defined in List are also defined in Collection.
E . Map extends Collection.
-
Which of these statements about penultimate hop popping are true？（）
A . It is used only for directly connected subnets or aggregate routes
B . It can only be used with LDP.
C . It is only used when two or more labels are stacked.
D . It enables the Edge LSR to request a label pop operation from Its upstream neighbors
E . It is requested through TDP using a special label value that is also called the implicit-null value.
F . It is requested through LDP using a special label value that is also called the implicit-null value.
-
Which three of these statements about PPPoE are true？（）
A . PPPoE can provide a host with access to a destination over Ethernet. You can have only one PPPoE session per PVC
B . You must install PPPoE client software on all hosts that connect to the Ethernet segment. This means that the access provider must maintain a CPE
C . You cannot use PPPoE with Cisco Service Selection Gateway
D . PPPoE implementation is susceptible to broadcast storms and possible denial-of-service attacks
E . Per-session accounting is possible， which allows the service provider to charge the subscriber based on session time for various services offered. The service provider can also require a minimum access charge
-
Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?（）
A . MANAGER must be a role.
B . It allows the MANAGER to pass the specified privileges on to other users.
C . It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.
D . It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.
E . It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.
F . It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
-
Examine the statement： SQL> CREATE TABLESPACE user_data 2> EXTENT MANAGEMENT LOCAL 3> SEGMENT SPACE MANAGEMENT AUTO； Which twp assumptions must be true for this statement to execute successfully？（）
A . Oracle Managed Files are used for this instance.
B . The USER_DATA tablespace is managed using FET$/UET$ tables.
C . The COMPATIBLE initialization parameter must be 9.0.0 or higher.
D . Space within segments in the USER_DATA tablespace is managed with freelists.
-
Which of these statements best describes VPLS？（）
A . Neither broadcast nor multicast traffic is ever flooded in VPLS.
B . Multicast traffic is flooded but broadcast traffic is not flooded in VPLS.
C . VPLS emulates an Ethernet switch， with each EMS being analogous to a VLAN.
D . Because U-PE devices act as IEEE 802.1 devices， the VPLS core must use STP.
E . When the provider experiences an outage， IP re-routing restores PW connectivity and MAC re-learning is needed.
-
Examine these two statements:Which three are true about the MRKT tablespace?（）
A . The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.
B . The MRKT tablespace may be dropped if it has no contents.
C . Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.
D . No more data files can be added to the tablespace.
E . The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.
-
Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）
A . The SKD user cannot log in to the database instance.
B . The objects owned by the SKD user are not accessible to any user.
C . The other users can access the objects owned by the SKD user， on which they have access.
D . The password for the SKD user expires and the user is forced to change the password at the next log in.
-
Examine the statement：
DROP TABLESPACE IND2
INCLUDING CONTENTS
AND DATAFILES；
What is the result of the statement？（）
https://assets.asklib.com/images/image2/2018080111115360474.jpg
A . A
B . B
C . C
D . D
-
Which two of these statements regarding RSTP are correct？（）
A . RSTP cannot operate with PVST+.
B . RSTP defines new port roles.
C . RSTP defines no new port states.
D . RSTP is a proprietary implementation of IEEE 802.1D STP.
E . RSTP is compatible with the original IEEE 802.1D STP.
-
Which of these statements about FSPF is true？（）
A . It supports multipath routing
B . It can run any type of storage ports
C . When it is used， hop-by-hop routes are based only on the switch ID
D . When it is used， path status is based on the functionality of attached ports
E . It runs only on a switch fabric and cannot function in a VSAN
-
Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）
A . The SKD user cannot log in to the database instance.
B . The objects owned by the SKD user are not accessible to any user.
C . The other users can access the objects owned by the SKD user， on which they have access.
D . The password for the SKD user expires and the user is forced to change the password at the next log i
-
Examine the structure of the EMPLOYEES table:
https://assets.asklib.com/images/image2/2018080116355281637.jpg
You issue these statements:
https://assets.asklib.com/images/image2/2018080116355826082.jpg
At the end of this transaction, what is true?（）
A . You have no rows in the table.
B . You have an employee with the name of James.
C . You cannot roll back to the same savepoint more than once.
D . Your last update fails to update any rows because employee ID 180 was already eleted.
-
Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?（）
A . Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
B . All DDL commands are logged in the alert log file.
C . All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
D . Only DDL commands that resulted in the creation of new segments are logged.
E . All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
-
Which of these statements best describes VPLS?（）
A . Neither broadcast nor multicast traffic is ever flooded in VPLS.
B . Multicast traffic is flooded but broadcast traffic is not flooded in VPLS.
C . VPLS emulates an Ethernet switch, with eachEMS being analogous to a VLAN.
D . Because U-PE devices act as IEEE 802.1 devices, the VPLS core must use STP.
E . When the provider experiences an outage, IP re-routing restores PW connectivity and MAC relearning is needed.
-
Which two of these statements regarding RSTP are correct?（）
A . RSTP cannot operate with PVST+.
B . RSTP defines new port roles.
C . RSTP defines no new port states.
D . RSTP is a proprietary implementation of IEEE 802.1D STP.
E . RSTP is compatible with the original IEEE 802.1D STP.
-
Examine the following RMAN script:
https://assets.asklib.com/images/image2/2018080215330499234.jpg
Which statement describes the purpose of the script?（）
A . The data file is checked for physical corruption and backed up if found clean.
B . The backup of data file 5 is performed and the interactive messages during the backup are suppressed.
C . The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.
D . The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
-
Examine the statement: Create synonym emp for hr. employees; What happens when you issue the statement? （）
A . An error is generated.
B . You will have two identical tables in the HR schema with different names.
C . You create a table called employees in the HR schema based on you EMP table.
D . You create an alternative name for the employees table in the HR schema in your own schema.
-
Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?（）
A . None of the data definition language (DDL) statements are logged in the trace file.
B . Only DDL commands that resulted in errors are logged in the alert log file.
C . A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.
D . Only DDL commands that resulted in the creation of new database files are logged.
-
Which of these statements did Confucius NOT say?
-
Click the Exhibit button and examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP BY department_id);Which statement is true？（）
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/e0e7e26248da659a6662e982bf95acc3.jpg' />
A.The SELECT statement is syntactically accurate.
B.The SELECT statement does not work because there is no HAVING clause.
C.The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.
D.The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.
-
View the Exhibit to examine the Automatic Database Diagnostic Monitor （ADDM) tasks.Which statement describes the consequence？（）
<img src='https://img2.soutiyun.com/shangxueba/ask/64230001-64233000/64231578/d39131b84ca6a8d8b08830b9d4753c7b.jpg' />
<img src='https://img2.soutiyun.com/shangxueba/ask/64230001-64233000/64231578/4c44618d517b4d4d3a08325cfb73e2e3.jpg' />
A. The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
B. The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only.
C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state.
D. All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
-
Examine the description of the MARKS table:SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects.Examine this SELECT statement based on the MARKS table:What is the result of the SELECT statement？（）
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/1179420481e271350f195c64f9e527b9.jpg' />
<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/a88968eec9764c2a8638e3aee2b1e23d.jpg' />
A. The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.
B. The statement returns an error at the SELECT clause.
C. The statement returns an error at the WHERE clause.
D. The statement returns an error at the ORDER BY clause.
-
Examine the parameters for your database instance:Which three statements are true about the process of automatic optimization by using cardinalityfeedback？（）
A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
B. The optimizer can re optimize a query only once using cardinality feedback.
C. The optimizer enables monitoring for cardinality feedback after the first execution of a query.
D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by thecollectors are submitted to the optimizer.
