[单选题]【不定项选择题】核税时,该套房屋需要缴纳的增值税及附加是( )元。
A.0
B.40381
C.141333
D.148400

[单选题]【不定项选择题】本次交易需要缴纳的土地出让金是( )元。
A.0
B.22000
C.20000
D.19000

[单选题]【不定项选择题】本次交易王洪应缴纳契税( )万元。
A.1.08
B.1.15
C.1.2
D.1.36

[单选题]位于市区的某公司2020年8月应缴纳增值税170万元，实际缴纳增值税210万元（包括缴纳以前年度欠缴的增值税40万元）。当月因享受增值税先征后退政策，获得增值税退税60万元。则该公司当月应缴纳的城市维护建设税和教育费附加合计为（ ）。
A.15万元
B.17万元
C.21万元
D.53万元

[多选题]【不定项选择题】陈铭和秦燕在房屋过户后,欲办理落户手续,需准备( )。
A.房屋产权证
B.原户口所在地居民户口簿和居民身份证
C.《准予迁入证明》《户口迁移证》
D.劳动合同

[多选题]【不定项选择题】在签署房屋买卖合同时,刘赞需要携带的资料为( )。
A.刘赞的身份证
B.出售房屋的权属证明
C.共有权人同意出售证明
D.身份证与军官证为同一人证明

[不定项选择题]区间施工防护需要（）必备品。
A.黄马甲
B.红色和黄色闪光灯
C.手持台
D.护趾鞋
E.具有夜光效果的防护服

[不定项选择题]以下（）驾驶模式转换不需要停车。
A.ATP（SM）转换至IATP
B.ATP转换至ATO
C.RM转换至ATP（SM）
D.NRM转换至RM
E.ATO转换至ATP（SM）

[不定项选择题]ATS系统硬盘对拷需要的工具和软件有（）。
A.U盘
B.syslinux4usb.exe
C.g4l
D.硬盘
E.网线

[不定项选择题]ATS系统用户登录后可根据需要改变（）。
A.控制方式
B.控制区域
C.用户角色
D.用户权限
E.用户密码

[不定项选择题]The persistent configuration settings for RMAN have default for all

Parameters. 

Identify four RMAN commands that produce a multi-section Backup.

A.

BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

B.

BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

C.

BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

D.

BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;

E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION
SIZE 100M;
F. BACKUP SPFILE SECTION SIZE 1M;
G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

[不定项选择题]Which statement describes the significance of the CHANGE FAILURE

Command in RMAN? (Choose all that apply.) choose two

A.

It is used to change failure priority only for HIGH or LOW priorities.

B.

It is used to execute the advised repair script.

C.

It is used to change failure priority only for the CRITICAL priority.

D.

It is used to explicitly close the open failures.

E. It is used to inform the database about the repair after the repair script
Executes.

[单选题]【不定项选择题】沈山河购买保利花园沁泉居的住宅,应缴纳的契税金额为( )万元。
A.2.1
B.2.25
C.2.8
D.3

[单选题]‘年12月甲机构向税务机关应缴纳增值税30万元,实际缴纳26万元:向税务机关应缴纳消费税28万元,实际缴纳24万元。已知教育费附加征收比率为3%。计算甲企业当月应当缴纳教育费附加的下列算式中,正确的是( )。
A.28×3%=0.84万元
B.(30+28)×3%=1.74万元
C.(26+24)×3%=1.5万元
D.30×3%=0.9万元

[不定项选择题]In a recent Automatic Workload Repository (AWR) report for your

Database, you notice a high number of buffer busy waits. The database

Consists of locally managed tablespaces with free list managed segments.

On further investigation, you f ind that buffer busy waits is caused by

Contention on data blocks.

Which option would you consider first to decrease the wait event

Immediately?

A.

Decreasing PCTUSED

B.

Decreasing PCTFREE

C.

Increasing the number of DBWN process

D.

Using Automatic Segment Space Management (ASSM)

E. Increasing db_buffer_cache based on t he V$DB_CACHE_ADVICE
Recommendation

[不定项选择题]choose one
You enable Flashback Data Archive for a table for which you
Want to track and save all transactions for four years. After some time, the
Requirement changes for keeping transactions from four to two years.
You execute the following command to change the requirement:
SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR;
What is the outcome?
A. All historical data older than two years, if any, is purged from the flashback
Archive FDA1.
B. An error is returned because the retention period cannot be reduced.
C. All the flashback data archives are purged and the subsequently created
Flashback archives are maintained for two years.
D. All historical data older than two years, if any, is archived to flashback logs and
The flashback archive is set to new retention time.

[不定项选择题]After implementing full Oracle Data Redaction, you change the default

Value for the NUMBER data type as follows:

SQL> select number_value from REDACTION_VALUES_FOR_TYPE_FULL;

NUMBER_VALUE

------------

0

SQL> exec DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES(-1);

SQL> select number_value from REDACTION_VALUES_FOR_TYPE_FULL;

NUMBER_VALUE

------------

-1

After changing the value, you notice that FULL redaction continues to redact

Numeric data with zero.（您注意到 FULL 编校继续以零编校数值数据）也就是

上面的修改还没有生效，该命令是把 number 的数据类型编辑以后默认值为－1）。

What must you do to activate the new default value for numeric full

Redaction?

A.

Re-enable redaction policies that use FULL data redaction.

B.

Re-create redaction policies that use FULL data redaction.

C.

Re-connect the sessions that access objects with redaction policies defined on

Them.

D.

Flush t he shared pool.

E. Restart the database instance.

[不定项选择题]You are administering a multitenant container database (COB) that

Contains two pluggable databases (PDBs), pdb1 and pdb2. You are

Connected to pdb2 as a common user with DBA privileges. The

Statistics_level parameter is PDB modifiable.

As the user sys, execute the following command on pdb2:

SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;

Which statement is true about the result of this command?

A.

The statistics_level parameter is set to all when any of the PDBs is reopened.

B.

The statistics_level parameter is set to all only for PDB2 when it is reopened.

C.

The statistics_level parameter is set to all when the root database is restarted.

D.

The statement is ignored because there is no SPFILE for a PDB.

[不定项选择题]You must transport the UNIVERSITY tablespace from one database to

Another.

The UNIVERSITY tablespace is currently open read/write.

The source and destination platforms have different endian formats.

Examine this list of actions:

1-Make the UNIVERSITY tablespace read-only on the source system.

2-Export the UNIVERSITY tablespace metadata using EXPDP.

3-Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the source system.

4-Copy the UNIVERSITY tablespace data files to the destination system.

5-Copy the Data Pump dump set to the destination system.

6-Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.

7-Import the UNIVERSITY tablespace metadata using IMPDP.

8-Make the UNIVERSITY tablespace read/write on the destination system.

Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

A.

1, 2, 4, 5, 7, 8

B.

1, 2, 4, 6, 7, 8

C.

1, 2, 3, 4, 5, 7, 8

D.

1, 2, 3, 4, 5, 6, 7, 8

E. 2, 4, 5, 6, 7

[不定项选择题]Automatic Shared Memory Management is disabled for one of your

Database instances. Some SQL statements perform poorly due to excessive

Hard parse activity, thereby degrading performance. 

What would be your Next step?  one

A.

Run the SQL Access Advisor.

B.

Run the Memory Advisor for the shared pool.

C.

Run the SQL Tuning Advisor.

D.

Run the Memory Advisor for the Program Global Area.

E.

Run the Memory Advisor for the System Global Area.