ITPub博客

473.How many different calendars does Oracle 11g support?A. 22B. 7C. 6D. 15E. 2Answer: Bhttp://docs.oracle.com/cd/E11882_01/server.112/e10729/ch3globenv.htm#NLSPG215http://blog.csdn.net/rlhua/article/details/19572505

279.Identify the activities performed as part of the Automatic SQL Tuning process in the maintenancewindow? (Choose all that apply.)A. generating the SQL profileB. testing and accepting the SQL profileC. generating a list of candidate SQLs for tuningD. adding tuned SQL plans into the SQL plan b...

499.Which statement is true regarding the retention policy for the incidents accumulated in the AutomaticDiagnostic Repository (ADR)?A. The incident metadata is purged when the problem is resolved and the DBA closes the SR.B. The incident files and dumps are not retained in the ADR for the manual...

349.What is the result of this command? RMAN> Report need backup days 3;A. Lists all datafiles created in the last three days that are not backed up.B. Lists all datafiles not recoverable based on the current retention criteria.C. Lists all datafiles not backed up in the last three days. The data...

672.You are in the process of creating a Virtual Private Catalog (VPC) in your Oracle Database 11gdatabase. The Prod1, Prod2 and Prod3 Oracle Database 10g databases are registered in the recoverycatalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executesthe follow...

 542.You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails.You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and youdon't want to have to rebuild the disks from scratch. What do you do?A. Take ...

574.A user sends you an email with the following error message: create table idtable(id number) *ERROR at line 1: ORA- 01110: data file 4: ,,/oracle01/oradata/orcl/users01.dbf ORA-27041:01116: error in opening database file 4 ORA-unable to open file Linux Error: 2: No such file or directoryAdditi...

561.If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode,what will be the result when you issue the command alter database archivelog?A. The alter database archivelog command will fail.B. The alter database archivelog inconsistent command must be used to ...

455.When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?(Choose all that apply.)A. The job will be dropped automatically if the value of the     attribute is TRUE. B. The job will only be disabled if the value of the AUTO_DR...

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1794009000346753857In a nutshell - the tuning advisor o suggests sql profiles o gathering more or stale statistics o indexes that might be VERY useful o query rewrites the access advisor o ...

 Examine the following statement that is used to modify the primary key constraint on the SALEStable:SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;Which three statements are true regarding the above command? (Choose three.)A.The constraint remains valid.B.The index on the c...

185.A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger, which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression? A. backup database all B. backup comp...

参考官方文档，学习了一下Oracle SQL Model语法。官方文档地址：http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/10g/r2/prod/bidw/sqlmodel/sqlmodel_otn.htm现将过程记录在这里：1. 准备过程, 连接到Oracle自带schema SH(sales history)，创建数据源：   CREATE VIEW sales_view AS  ...

闪回版本查询是一个Oracle提供的一个比较有用的功能。我们可以用它来查看某一段时期内表数据所发生的变化。以下是示例：SQL> create table t2 as select rownum pkid, lpad('1', rownum, 'A') str from dual connect by rownum <= 5;SQL> col str format a10SQL> col pkid format 999SQL> select * from t2;...

同事想删除某个表的数据，但是一直报错，跟我说是锁。通过如下SQL查询，没有发现表锁相关会话：SELECT ddl.owner AS 用户,       ddl.name AS 对象,       ddl.type AS 类型,       vs.osuser AS os_user,       vs.machine, ...