OCP专业题库过过过.pdf

1Z0-082新题 Number:000-000 Passing Score:800 Time Limit: 120 min File Version: 1.0 ExamA QUESTION 1 You issued this command: DROPTABLE hr employees;Whichthree statements are true? A. Sequences used to populate columns inthe HR.EMPLOYEES table are dropped. B. Synonyms for HR. EMPLOYEES are dropped. C. Views referencing HR.EMPLOYEES are dropped. D. The HR.EMPLOYEES table may be moved to the recycle bin. E. Allconstraints defined on HR. EMPLOYEES are dropped. F. All indexes defined on HR. EMPLOYEES are dropped. Correct Answer: DEFSection:(none) Explanation Explanation/Reference: 表被删除时，表上的约束、索引一起被删除，表被放入回收站 （默认）。视 图和synonym不会被删除 QUESTION2 Whichthree statements are true about the naming methods and theirfeatures supported by Oracle database used to resolve connection information? A. A client canconnect to an Orade database instance even if no client side networkadmin has been configured. B. Directory Naming requires setting the TNSADMIN environment variable onthe client side. C. Directory Naming can be usedif Connect-Time Failover is required. D. EasyConnect supports TCP/IPandSsL. E. LocalNaming requires setting the TNS_ADMIN environment variable onthe cdient side. F. Local naming can be used if Connect-Time Failover is required. Correct Answer:ACFSection:(none) Explanation Explanation/Reference: 客户端可以用这种形式链接服务器： SQL CONNECT hr/hr@:1521/orcl，不需要配置，这就是 EasyConnect EasyConnect不支持SSL。Local naming支持Connect-Time Failover。LocalNaming 文件位于默认位 置，如果位于其他位置，需要通过TNS_ADMIN环境变量指定，这个变量不是必须的。Directory Naming 也支持Connect-Time Failover。Connect-Time Failover主要用在RAC环境中，客户端可以轮流连接不 同的节点 QUESTION3 Whichthree statements are true about multiple row subqueries? A. They can contain GROUP BY clauses. B. They can return multiple columns. C. Two or more values are always returned fromthe subquery. D. They cannot contain a subquery . E. They can contain HAVING clauses. Correct