8. Which are two ways for a database service to be recognized by a listener in Oracle Database 12c?A) Static registration in the listener.ora file using the service_name parameterB) Dynamic Registration by the smon processC) Static registration in the listener.ora file using the global_dbname par...【阅读全文】
7.daily_ords_lst is created in locally managed tablespace ORDERS_TBS which uses automatic segment space management.CREATE TABLE daily_ords_list (ordno NUMBER, ord_date DATE) PCTFREE 20;Which two are true ?A) 80% of every data block in daily_ords_lst is reserved for row inserts.B) pctfree elimina...【阅读全文】
5.One of your databases supports an OLTP workload.The default undo tablespace is fixed size with:1. RETENTION NOGUARANTEE2. undo_retention is 12 minutesUser scott get this error after a query on the sales table has run for more than 15 minutes:ORA-01555: snapshot too oldWhich three factors tak...【阅读全文】
4.Which four are true about creating and running a remote database scheduler jobs?A) A credential is optional for a remote database job.B) A database destination group must exist or be created for a job to run on multiple remote databases.C) A destination is optional for a remote database job bec...【阅读全文】
1.One of your databases has archive logging enabled and RMAN backups are taken at regular intervals. The data file for the users tablespace is corrupt. Which command must you execute before starting the recovery of this tablespace ? A) SWITCH DATAFILE ALL; B) ALTE...【阅读全文】
1、启动至nomount状态SYS@orcl> startup nomount;2、查找trace文件目录SYS@orcl> select TRACEFILE from v$process where addr in(select paddr from v$session where sid in(select sid from v$mystat where rownum=1));TRACEFILE ...【阅读全文】
改动之前请先备份第一步:show parameter workarea_size_policy;nologging parallel 4 alter index xxx logging;第六步:设置自动管理PGAalter session set workarea_size_policy=AUTO;最后,建立好索引之后,还原上述修改。...【阅读全文】
查看用户对应的profileSELECT username,PROFILE FROM dba_users;查看密码超时配置Select * From Dba_Profiles s Where s.Profile = 'DEFAULT' And Resource_Name = 'PASSWORD_LIFE_TIME';修改数据库密码永不超时alter profile default limit password_life_time unlimited;...【阅读全文】
1、构造测试环境SYS@vbox66in>create table test1 ( 2 id number not null, 3 num number, 4 val varchar2(100));表已创建。SYS@vbox66in>SYS@vbox66in>create table test2 ( 2 id number not null, 3 t1_id number not null, 4 num number, 5 val varchar2(100));表已创建。SYS@vbox66in> SYS@vbox66in>exec...【阅读全文】
5、Which two affect the time taken for instance recovery?A) size of redo logsB) size of UNDO tablespaceC) FAST_START_MTTR_TARGET valueD) size of archivelogsE) size of existing RMAN backupsetsF) UNDO_RETENTION valueAnswer:AC【阅读全文】