062_在线真题试卷与模拟练习_062

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Examine these statements:

CREATE ROLE dev1;

Role created

GRANT CREATE SESSION, CREATE USER, CREATE TABLE TO dev1;

Grant succeeded.

CREATE USER john IDENTIFIED BY john;

User created.

GRANT CONNECT, dev1 TO john;

Grant succeeded.

REVOKE CREATE SESSION FROM dev1;

Revoke succeeded.

Which two are true about the result and effects of executing these commands?

Which three are true about the default database buffer cache?

One of your databases is open and not managed by Oracle Restart.
Examine this command which executes successfully:
ALTER SYSTEM ENABLE RESTRICTED SESSION;
Which two are true?

Which two types of information are contained in the Oracle Database data dictionary?

Which three are true about the In-Memory column store?

A database runs in NOARCHIVELOG mode
Backup scheduling for this database must be automated before upgrading to a new version of the
Database.
Which two tools or utilities can do this?

Examine this configuration for one of your databases:
1 UNDO RETENTION parameter is 1000
2 Retention is not guaranteed
3 The undo tablespace is fixed size
Which two statements are true?

A database runs in ARCHIVELOG mode.

Dally full database backups are taken with RMAN which is configured to perform control file autobackup.

The control file and redo log files are multi-plexed.

In which two cases is media recovery required?

Examine these configuration details
1 A Fast Recovery Area (FRA) has been specified for a database
2 The database instance is in ARCHIVELOG mode
3 The default location for archived redo log files is the FRA
Which two types of files are removed automatically due to space pressure in the FRA?

Examine the command
SOL> CREATE TAILESPACE test1
DATAFILE '/u01/app/oracle/oradata/orcl/test01. dbf ’SIZE 5M
AUTOEXTEND ON AUTOALLOCATE;
Which two statements are true?

Which two statements are true about Oracle network connections?

Which two can be used to create and populate a table from the contents of a textual flat file?

Examine the data in the CUST_NAME column of the CUSTOMERS table:CUST_NAME----------------------------------------------------Renske LadwigJason MallinSamuel MccainAllan MCEwenIrene MikkilineniJulia NayerYou want to display the CUST_NAME values where the last name starts with Mc or MC.Which two WHERE clauses give the required result?

Your databases all run in ARCHIVELOG mode. A new database has no RMAN backups yet.

Examine these commands:

CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

RMAN> BACKUP TABLESPACE SYSTEM;

Backup set complete, elapsed time: 00:00:03

RMAN> BACKUP TABLESPACE SYSTEM , SYSAUX;

Backup set complete, elapsed time: 00:00:04

RMAN> BACKUP DATABASE;

Backup set complete, elapsed time: 00:00:07

Which two are true about the execution of the third backup command?

Which three naming methods or connection types enable clients to connect to database instances successfully without client or server side configuration in sqlnet.ora or tnsnames.ora?

Examine this command which executes successfully:

SQL>ALTER TABLE cities SHRINK SPACE;

Which two are true?

SMD is a bigfile tablespace. The SH user receives this error while inserting data into the non-partitioned SALES table:

ERROR at line 1: ORA-01653: unable to extend table SH.SALES by 128 in tablespace SMD.

Which three actions could correct the problem?

Which two statements are true about the Database Configuration Assistant (DBCA) in Oracle Database.

A database runs in ARCHIVELOG mode.

Daily full database backups are taken with RMAN which is configured to perform control file autobackup.

The control file and redo log files are mutiplexed in which two cases is media recovery required?

You want to create a test database as a replica of your production database with minimum intervention from a DBA.

Which method would you use?

1 3 4 5 6 7 8