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

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

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?

In your database,the SALES table exists in the SH schema and unified auditing is enabled.

As the DBA,you successfully execute the commands:

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?

A user establishes a connection to a database instance by using an Oracle Net connection.You want to ensure the following:
1 The user account must be locked after five unsuccessful login attempts.
2 Data read per session must be limited for the user.
3 The user cannot have more than three simultaneous sessions.
4 The user must have a maximum of 10 minutes session idle time before being logged off automatically.
How would you accomplish this?

Your database is running in NOARCHIVELOG mode.Examine the following parameters:
NAME TYPE VALUE
-------------------- ------------------- ----------------------------
Log_archive_dest string
Log_archive_dest_1 string
Logrecovery_file_dest string /u01/app/oracle/fast_recovery_area
You execute the following command after performing a STARTUP MOUNT:
SQL >ALTER DATABASE ARCHIVELOG;
Which statement is true about the execution of the command?

The HR user owns the BONUSERS talbe.HR grants privileges to the user TOM by using the command:
SQL> GRANT SELECT ON bonuses to tom WITH GRANT OPTION;
TOM then executes this command to grant privileges to the user JIM:
SQL> GRANT SELECT ON hr.bonuses TO jim;
Which statement is true?

Your database is open and the listener LTSTENER is up.You issue the command: LSNRCTL> RELOAD
What is the effect of RELOAD on sessions that were originally established by LISTENER?

What should you do to ensure that a job stores minimal job metadata and runtime data on disk,and uses only existing PL/SQL programs?

What should you do for a Scheduler to start a job when a file arrives on a remote system?

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?

Which statement is true about redo log files during instance recovery?

Examine this parameter setting:
SHOW PARAMETER INMEMORY_SIZE
NAME TYPE VALUE
------------- ---------- ---------
Inmemory_size big integer 1G
Now examine this command :
ALTER TABLE hr.emp INMEMORY; Table altered .
Which is true about effects of this command and any subsequent processing on hr.emp?

Examine these parameter settings:
NAME TYPE VALUE
------------------- ------------------ -------------------
Db_create_file_dest string /u01/app/oracle/oradata/prod/
Undo_management string AUTO
Undo_retention integer 900
Undo_tablespace string UNDOTBS1
You execute this:
CREATE UNDO TABLESPACE UNDOTBS2 SEGMENT SPACE MANAGEMENT AUTO;
Which is true?

Which naming method enables clients to connect to a database instance without any client side configuration in sqlnet.ora or tnsnames.ora?

Examine these commands:
SELECT open_mode FROM V$database;
OPEN_MODE
------------------
READ WRITE
ARCHIVE LOG LIST;
Datebase log mode No archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Now examine these steps:
1) STARTUP NOMOUNT
2) STARTUP MOUNT
3) STARTUP FORCE
4) ALTER DATABASE ARCHIVELOG;
5) SHUTDOWN TRANSACTIONAL
6) ALTER DATABASE OPEN;
7) SHUTDOWN ABORT
8) ALTER DATABASE MOUNT
Identify the required steps in the correct order to change the database to run in ARCHIVELOG mode.

In one of your databases,unified auditing is enabled and an SH.SALES table exists.You successfully execute these commands:

SQL> CREATE AUDIT POLICY sales_pol ACTIONS select on sh.sales;

SQL>AUDIT POLICY sales_pol;

Which statement is true about SALES_ POL?

Examine these commands: CONNECT / AS SYSDBA
CREATE DIRECTORY dumpdir AS '/u01/app/';
Directory created.
GRANT READ,WRITE ON DIRECTORY dumpdir TO PUBLIC;
Grant succeeded.
CREATE USER TEST IDENTIFIED BY test;
User created.
GRANT CREATE SESSION,RESOURCE,UNLIMITED TABLESPACE TO test;
Grant succeeded.
CONN test/test
Connected.
CREATE TABLE test_employees (id NUMBER(3),name VARCHAR2(20),salary NUMBER(7));
Table created.
SQL> CREATE SYNONYM emp FOR test_employees; Synonym created.
Now examine this command:
$ expdp test/test DIRECTORY=dumpdir DUMPFILE=test_emp.dmp LOGFILE=test.log TABLES=emp CONTENT=data_only query='EMP:"WHERE salary=12000"'
Which is true?

All of your live databases run in ARCHIVELOG mode.
On the SALES database there is no LEVEL 0 backup.
Examine these commands issued against the SALES database target:
RMAN> BACKUP AS BACKUPSET DATABASE;
..
Backup set complete,elapsed time: 00:00:03
RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE;
What is true about the execution of these commands?
What is true about the execution of these commands?

Examine this command:
STARTUP FORCE
ORACLE instance started
Total system Global Area 511749968 bytes
Fixed SIZE 9038960 bytes
Variable Size 922746880 bytes
Database Buffers 4177526784 bytes
Redo Buffers 7737344 bytes
Database mounted.
Database opened.
Now examine these steps:
1 Oracle instance is started.
2 The control file is read.
3 Instance recovery is started.
4 Datafiles and redo log files are opened.
5 The spfile or pfile is read.
6 The database is available for use.
7 The database is mounted .
8 Instance recovery is completed.
Identify the steps that were executed in the correct order to open the database:

Which naming method enables clients to connect to a database instance without any client side configuration in sqlnet.ora or tnsnamea.ora?

In your database instance,the UNDO RETENT TON parameter is set to 1000 and undo retention is not guaranteed for the fixed size undo tablespace.Which st atement is true about undo retention?

更多题库