51CTO博客开发卓越始于足下抚琴煮酒
224.You need to create a partitioned table to store historical data and you issued the following command: CREATE TABLE purchase_interval PARTITION BY RANGE (time_id) INTERVAL (NUMTOYMINTERV
只对部分行建立索引 创建大表: create table t_big (id int,flag varchar2(5)); begin for j in 0..100 loop for i in 0..10000 loop execute immediate 'insert into t_big(id) values(:1) ' using i; end loo
--某网友给的建议 1.熟悉执行计划的各种操作，会看懂执行计划 2.熟悉表的数据分布，索引，分区等对执行计划的影响 3.熟悉各种SQL语句的写法，能等价改写各种SQL 4.能够利用业务特点改写和设计SQL 5.能利用ORACLE提供的各种工具，比如sql trace,dbms_xplan,sql tuning advisor,spm等优化sql 推荐书籍: 1. o
17.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 (numto
16.Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECT
15.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
14.Which two statements are true regarding hot patching? (Choose two.) A. It requires relinking of the Oracle binary. B. It does not require database instance shutdown. C. It can detect confli
12.You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the
10.Consider the following scenario for your database: -Backup optimization is enabled in RMAN. The recovery window is set to 7 days in RMAN. The most recent backup to disk for the TOOLS tablespac
8.Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs? A. It cannot be done in parallel. B. It can be done at the table level or partition
7.You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package. Which
6.You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog sch
5.Examine the section of the Health Check report given below: DBMS_HM.GET_RUN_REPORT('HM_RUN_1061') Run Name : HM_RUN_1061 Run Id : 1061 Check Name : Data Block Integrity Che
4.Which three components does the Scheduler use for managing tasks within the Oracle environment? (Choose three.) A. a job B. a program C. a schedule D. a PL/SQL procedure Answer:
Copyright © 2005-2025 51CTO.COM 版权所有 京ICP证060544号
