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

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Examine the command：

SQL> CREATE TABLESPACE test1 DATAFILE ‘/u01/app/oracle/oradata/orcl/test01.dbf’ size 5M AUTOEXTEND ON UNIFORM;

Which statement is true?

Which task is performed by a background process in a database instance?

Examing the command：

SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;

Which two statements are true in this scenario?

Your database is in NOARCHIVELOG mode. You want to enable archiving for database. Examine the steps：
1)Execute the ALTER DATABASE ARCHIVELOG command 执行开归档命令
2)Execute SHUTDOWN IMMEDIATE 立即关闭数据库
3)Execute STARTUP MOUNT 数据库启动到挂起
4)Set the DA_RECOUVERY_FILE_DEST parameter to $ORACLE_HOME/dbs/ 设置恢复目录
5)Execute STARTUP NOMOUNT 数据库创建实例但不挂起
6)Open the database 打开数据库
Identify the require steps in the correct sequence.

Examine the details of the uncompressed, non-partitioned heap table CITIES.

Name Null Type

CITYID NOT NULL NUMBER(4)

CITYNAME VARCHAR2(50)

Examine the command：

SQL>ALTER TABLE cities SHRINK SPACE COMPACT; What must you do nefore executing it?

Which statement is ture about profile?

What is the outcome of the SHUTDOWN ABORT command?

Which three statement are true about Enterprise Manager Database Express?

The schema SALES exists in two databases, ORCL1 and ORCL2, and has the same password, SALES123. User SALES has CREATE DATABASE LINK and CREATE SESSION privileges on both databases.
Eaxmine these command： conn SALES/SALES123 CREATE DATABASE LINK orcl2 USING ‘orcl12’;
What is the outcome of executing these commands in the ORCL1 database?

Which statement is true about a database in ARCHIVELOG mode?

Identify the access that is initially availabel to connect to your Database as a Service (DBaaS) environment

Which statement is true about the Database as a Service (DBaaS) instances and Database instances in Oracle Public Cloud?

Your database instance is started with a PFILE. Examine the parameters：
NAME TYPE VALUE
Memory_max_target big integer 0
Memory_target big integer 0
Sga_max_size big integer 2G
Sga_target big integer 2G
You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache. you execute the command：
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
Which is the outcome?

What must you use to read data from a table in your database and write it to an external table?

You configured the Fast Recovery Area(FRA、 for your database.The database instance is in ARCHIVELOG mode.
THe default location for the archived redo log files is the FRA.
Which two files are removed automatically if space is required in the FRA as per the retention policy?

In your database, archive lgging and control file autobackup are enabled.
The data files and redo log files are intact but control files are impacted due to media failure.
In which recovery scenario must you use the RESETLOGS option?

You want to create a locally managed tablespace called NEWTBS to store segments with different extent sizes.
Which set of tablespace attributes can be specified for a tablespace the satifies the requirements?

Which user are created and can be used for database and host management of your DBaaS database servers?

Which two services may you see on the My Service Dashboard page?

An application repeatedly accesses small lookup tables, causing a lot of physical I/O operations. What do you recommend to minimize this?