OCP 11G认证考试
单选题The INV_HISTORY table is created using the command: You would like to store the data belonging to the year 2006 in a single partition and issue the command: What would be the outcome of this command? （）AIt executes successfully, and the transition po
题目
It executes successfully, and the transition point is set to '1-apr-2006'.
It executes successfully, and the transition point is set to '15-apr-2006'.
It produces an error because the partitions specified for merging are not adjacent.
It produces an error because the date values specified in the merge do not match the date values stored in the table.
相似问题和答案
第1题：
Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command:ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS;What would be the outcome of this command?（）
A. It produces an error because data already exists in the table.
B. It produces an error because compression can be enabled at table creation only.
C. It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.
D. It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.
第2题：
After executing the "show host" command, which of the information below would you see?（）
- A、The IP addresses of workstations allowed gain access to the router via an access list
- B、Permanent name-to-address mappings created using the ip host command.
- C、Temporary and permanent DNS entries.
- D、The names of the routers created using the hostname command.
- E、The length of time of users logged into the router, as well as the duration
正确答案:B,D
第3题：
A. It executes successfully but partition pruning cannot happen for this partition key.
B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.
D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.
第4题：
The INV_HISTORY table is created using the command： SQL>CREATE TABLE INV_HISTORY （inv_no NUMBER（3）， inv_date DATE， inv_amt NUMBER（10，2）） partition by range （inv_date） interval （numtoyminterval（1，’month’）） （partition p0 values less than （to_date（’01-01-2005’，’dd-mm-yyyy’））， partition p1 values less than （to_date（’01-01-2006’，’dd-mm-yyyy’）））； The following data has been inserted into the INV_HISTORY table ： INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000 2 30-dec-2005 2000 3 1-feb-2006 3000 4 1-mar-2006 4000 5 1-apr-2006 5000 You would like to store the data belonging to the year 2006 in a single partition and issue the command： SQL> ALTER TABLE inv_history MERGE PARTITIONS FOR（TO_DATE（’15-feb-2006’，’dd-mon-yyyy’））， FOR（TO_DATE（’15-apr-2006’）） INTO PARTITION sys_py； What would be the outcome of this command？（）
- A、 It executes successfully，and the transition point is set to ’1-apr-2006’.
- B、 It executes successfully，and the transition point is set to ’15-apr-2006’.
- C、 It produces an error because the partitions specified for merging are not adjacent.
- D、 It produces an error because the date values specified in the merge do not match the date values stored in the table.
正确答案:C
第5题：
You execute the following commands to audit database activities: SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?（）
- A、One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
- B、One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.
- C、One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.
- D、One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.
- E、One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.
正确答案:A
第6题：
You opened the encryption wallet and then issued the following command:Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.What is the outcome?（）
A. It creates the table and encrypts the data in it.
B. It generates an error because the wallet is closed.
C. It creates the table but does not encrypt the data in it.
D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.
第7题：
You execute the following command to audit database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）
- A、One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.
- B、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.
- C、One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.
- D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
- E、One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT
正确答案:C
第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?（）
A. All three tables in the recycle bin are purged
B. Only the table with the oldest DROPSCN is purged
C. The command returns an error because multiple entries with the same name exist in the recycle bin
D. Only the table with the latest DROPSCN is purged
第9题：
Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space，you issued the following command： ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS； What would be the outcome of this command？（）
- A、 It produces an error because data already exists in the table.
- B、 It produces an error because compression can be enabled at table creation only.
- C、 It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.
- D、 It immediately compresses all existing data as well as new data， resulting from either fresh additions or modifications to existing data.
正确答案:C
第10题：
User A executes the following command to update the TRANS table） SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’； Before user A issues a COMMIT or ROLLBACK command， user B executes the following command on the TRANS table： SQl> ALTER TABLE trans MODIFY （tr_type VARCHAR2 （3））； What would happen in this scenario？（）
- A、The transaction for user A is rolled back.
- B、The ALTER TABLE command modifies the column successfully.
- C、The ALTER TABLE command fails due to the resource being busy.
- D、The ALTER TABLE command waits until user A ends the transaction.
正确答案:C