082（41-60）_在线真题试卷与模拟练习_082（41-60）

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.
You want to display the date of the first Monday after the completion of six months since hiring. The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the wee.
Which query can be used?

Examine the description of the SALES1 table:
Name Null Type
----------------------------------------------------------
SALES_ID NOT NULL NUMBER
STORE_ID NOT NULL NUMBER
ITEMS_ID NUMBER
QUANTITY NUMBER
SALES_DATE DATE
SALES2 is a table with the same description as SALES1. Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table. Which set operator generates the required output?

Your database instance is started with a PFILE. Examine these 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;
What is the outcome?

Your database instance is started by using a server parameter file (SPFILE). You execute the following command to change the value of the LOG_BUFFER initialization parameter:
ALTER SYSTEM SET LOG_BUFFER=32M;
What is the outcome of this command?

Choose the best ANSWER Examine this scenario: connect / as sysdba Connected.
SHUTDOWN TRANSACTIONAL
Database closed. Database dismounted. ORACLE instance shut down. STARTUP 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 correct steps and the order they will be executed in following this command:

Choose the best ANSWER. All of your database instances use SPFILES. You executed this command in one of them:
ALTER SYSTEM SET MEMORY_ MAX_ TARGET=1024M;
Which statement is true?

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name. Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING ‘dallas_db’;
How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

Examine the description of the CUSTOMERS table:

Name Null TYPE

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

CUST_ID NOT NULL NUMBER

CUST_FIRST_NAME' NOT NULL VARCHAR2(20)

CUST_LAST_NAME NOT NULL VARCHAR2(30)

CUST_INCOME_LEVEL VARCHAR2(30)

CUST_CREDIT_LIMIT NUMBER

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed. Which query should be used?

The ORCL database has RESUMABLE TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE
User U1 has a 1 MB quota in tablespace DATA. U1 executes this command:
SQL> CREATE TABLE t1 AS
(SELECT object_name, sharing, created FROM dba_objects); U1 complains that the command is taking too long to execute.
In the alert log, the database administrator (DBA) finds this:
2017-03-06T12:15:17.183438+05:30 statement in resumable session ‘User U1(136), Session 1, Instance 1’ was suspended due to ORA01536:
Space quota exceeded for tablespace ‘DATA’
Which are three actions any one of which the DBA could take to resume the session? (Choose three.)

In which three situations does a new transaction always start? (Choose three.)

Which three statements are true about pfiles, spfiles or both?

Which four statements are true about database instance behavior?

A PFILE exists for your database. You want to increase the value of the PROCESSES parameter from 300 to 400 and make it persistent for your database instance. You plan to use the ALTER SYSTEM command.
Which two methods can be used?

Choose three Examine this command.
STARTUP PFILE= 'D: \oracle12c\oracle\admin\orcl\pfile\pfileinitorcl.ora ORACLE instance started.
Total system Global Area 5117049968 bytes Fixed Size 9038960 bytes
Variable Size 922746880 bytes
Database Buffers 4177526784 bytes Redo Buffers 7737344 bytes Database mounted.
Database opened.
Now examine these statements.
SHOW PARAMETER cursor_sharing; TYPE VALUE NAME
--------------------------------
Cursor_sharing string EXACT
ALTER SYSTEM SET cursor_sharing=FORCE;
Which three are true about the result of processing the last statement?

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

You execute this command:
[oracle@host01 ~]$ expdp system/oracle \
>FULL=Y \
>DUMPFILE=exp_db_full.dmp \
>PARALLEL=4 \
>LOGFILE=exp_db_full.log \
>JOB_NAME=exp_db_full
During the export operation, you detach from the job by using CTRL+C and then execute this command:
Export> STOP_JOB=immediate
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)

In one of your databases, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.)

Choose two.
Which two statements are true about UNDO and REDO?

Which three statements are true about the DESCRIBE command? (Choose three.)