搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【多选题】

You executed this command to create a password file:<br /> $ orapwd file = orapworcl entries = 10 ignorecase = N<br /> Which two statements are true about the password file?（）

A、It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.

B、It contains username and passwords of database users who are members of the OSOPER operating system group.

C、It contains usernames and passwords of database users who are members of the OSDBA operating system group.

D、It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.

E、It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.

查看正确答案
更多“ You executed this command to create a password file:<br /> $ orapwd file = orapworcl entries = 10 ignorecase = N<br /> Which two statements are true about the password file?（）”相关的问题
第1题
[多选题] You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?（）

A、the SQL text SQL  B、the execution plan  C、the execution context  D、the execution frequency  E、the system change number (SCN)  

点击查看答案
第2题
[] You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees; （） You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees; （）

A、A. You get an error because of a primary key violation.  B、B. The data and structure of the EMPLOYEES table are deleted.  C、C. The data in the EMPLOYEES table is deleted but not the structure.  D、D. You get an error because the statement is not syntactically correct.  

点击查看答案
第3题
[单选题] You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables: What is the outcome of the above commands?（）

A、They execute and create a virtual catalog for pre-Oracle 11g clients.  B、They produce an error because PROD1 and PROD2 databases belong to the older version.  C、They produce an error because you need to connect as CATOWNER to execute this packaged procedure.  D、They produce an error because you need to connect to the target database to execute this packaged procedure.  

点击查看答案
第4题
[多选题] When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this?（）

A、It produces less accurate results of the comparison analysis.  B、It automatically calls the SQL Tuning Advisor for recommendations.  C、It shortens the time of execution and reduces the impact on system resources.  D、Only the changes in the execution plan, and not performance regression, are detected.  

点击查看答案
第5题
[单选题] You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?（）

A、It must be executed from the Oracle Database 11g environment.  B、It must be executed only after the SYSAUX tablespace has been created.  C、It must be executed from the environment of the database that is being upgraded.  D、It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.  E、It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.  

点击查看答案
第6题
[多选题] When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? （）(Choose two.)

A、It produces less accurate results of the comparison analysis.  B、It automatically calls the SQL Tuning Advisor for recommendations.  C、It shortens the time of execution and reduces the impact on system resources.  D、Only the changes in the execution plan, and not performance regression, are detected.  

点击查看答案
第7题
[多选题] When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? （）(Choose two.)

A、It produces less accurate results of the comparison analysis.  B、It automatically calls the SQL Tuning Advisor for recommendations.  C、It shortens the time of execution and reduces the impact on system resources.  D、Only the changes in the execution plan, and not performance regression, are detected.  

点击查看答案
第8题
[] Examine the output of the query that you executed to list the objects in the recycle bin: You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin: SQL> PURGE TABLE sales_tab; What would be the outcome of this command?（） Examine the output of the query that you executed to list the objects in the recycle bin: You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin: SQL> PURGE TABLE sales_tab; What would be the outcome of this command?（）

A、A. All three tables in the recycle bin are purged  B、B. Only the table with the oldest DROPSCN is purged  C、C. The command returns an error because multiple entries with the same name exist in the recycle bin  D、D. Only the table with the latest DROPSCN is purged  

点击查看答案
第9题
[] You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously. Dim ar As IAsyncResult = cmd.BeginExecuteReader() You need to execute a method named DoWork() that takes one second to run while the SQL query is executing. DoWork() must run as many times as possible while the SQL query is executing. Which code segment should you use?（） You have an SQL query that takes one minute to execute. You use the following code segment to execute the SQL query asynchronously. Dim ar As IAsyncResult = cmd.BeginExecuteReader() You need to execute a method named DoWork() that takes one second to run while the SQL query is executing. DoWork() must run as many times as possible while the SQL query is executing. Which code segment should you use?（）

A、A.c="https://img.ppkao.com/2018-07/longzhengxuan/2018072713514051834.jpg" />
B.c="https://img.ppkao.com/2018-07/longzhengxuan/201807271351586977.jpg" />
C.c="https://img.ppkao.com/2018-07/longzhengxuan/2018072713520556852.jpg" />
D.c="https://img.ppkao.com/2018-07/longzhengxuan/2018072713521144452.jpg" />  

点击查看答案
第10题
[] The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR;（） The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR;（）

A、A. You obtain the results retrieved from the public synonym HR created by the database administrator.  B、B. You obtain the results retrieved from the HR table that belongs to your schema.  C、C. You get an error message because you cannot retrieve from a table that has the same name as a public synonym.  D、D. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.  E、E. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服