062_在线真题试卷与模拟练习_062_考试宝

更新时间：试题数量：购买人数：提供作者：

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

随机练习 自定义设置练习量

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

学习资料 考试学习相关信息

搜索

题库预览

Which statement is true about the DEFAULT profile?

Examine the command to perfor a data pump export operation on a source databse：
$$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept
On the target database, you execute the data pump import command：
$$> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept
Which three statement are true?

You ran this command on a source database：
$$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept
On the target database, you run this command：
$$> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept
Which two statements are true?

Which component reside in the System Global Area(SGA、 of a database instance only in shared server connections?

When does a database checkpoint occur?

Which two statements are true about initialization parameter files?

Which three statements are true about user account administration?

What action must you take to ensure complete database recovery till the point of failure?

You want to distribute a set of structured data to your customers who can integrate this data into their existing databases irrespective of the platform.
Which method provides the fastest way of achieving this?

Identify three situations in which messages are written to the alert log file.

The HR schema exists in two databases, BOSTON and DENVER , and has the same password, HR.You have the CREATE DATABASE LINK and CREATE SESSION privileges on both the database.
BOSTON is defined as a service name in the tnsnames.ora of both the databases.
You plan to use the command：
CREATE DATABASE LINK hr_link；
CONNECT TO hr IDENTIFIED BY hr USING ‘denver’;
What must be done to ensure only the HR user in the BOSTON database can access the HR schema in the DENVER database?

The HR schema exists in databases, BOSTON and DENVER , and has the same password, HR.
You have the CREATE DATABASE LINK and CREATE SESSION privileges on both the database.DENVER is defined as a service name in the tnsnames.ora of both the databases.
You plan to use the command：
CREATE DATABASE LINK hr_link;
CONNECT TOhr IDENTIFIED BY hr USING ‘denver’;
What must be done to ensure that all users in the BOSTON database can access the HR schema in the DENVER?

Examine the parameters for your database instance：
NAME TYPE VALUE
Undo_management string AUTO
Undo_retention integer 1200
Undo_tablespace string UNDOTBS1
You execute the following command：
SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE; Which statement is true in this scenario?

Which three statements are true about naming methods?

Which three database operations can be performed only at MOUNT state?

Your database is running in ARCHIVELOG mod. You want to take a consistent whole database backup. Which two statement are true in this senario?

The ORCL database is configured to support shared server mode.
You want to ensure that a user connecting remotely to the database instance a one-to-one ratio between client and server processes.
Which connection method guarantees that this requirement is met?

The DEFERRED_SEGMENT_CREATION parameter is TRUE in one of your databases.

You execute this command：

SQL> CREATE TABLE acct1 (ac_no NUMBER,ac_desc VARCHAR2(25),amount NUMBER(10, 2));

Which three statements are true?

The DEFERRED_SEGMENT_CREATION parameter is TRUE in your database instance.You execute the following command to create a table：

SQL> CREATE TABLE acct1 (ac_no NUMBER,ac_desc VARCHAR2(25),amount NUMBER(10, 2));

Which two statements are true?

In your database, the SALES table exists in the SH schema and unified auditing is enabled.
As the DBA, you successfully execute the comands：
SQL> CREATE AUDIT POLICY sales_pol ACTIONS select on sh.sales;
SQL> AUDIT POLICY sales_pol;
Which statement is true about the SALES_POL audit policy?