有谁会做企业级数据库oracle的题目 帮忙看一下下面几个题
单选
14、Which statement should you use to obtain information about the number, names, status, and location of the control files?
A. SELECT name, status FROM v$parameter;
B. SELECT name, status FROM v$controlfile;
C. SELECT name, status, location FROM v$control_files;
D. SELECT status, location FROM v$parameter
WHERE parameter=control_files;
多选题
9、The control file defines the current state of the physical database.Which three dynamic performance views obtain information from the control file? (选三项)
A. V$LOG
B. V$SGA
C. V$VERSION
D. V$DATAFILE
E. V$PARAMETER
When a check point occurs the ______. ________. and ________ are synchronized.
(选三项)
A. data files
B. control files
C. redo log files
D. parameter files
E. archive log files
填空题 5、The memory area that stores the parsed representation of most recently executed Statements is( )
9、The size of a granule depends on the estimated total SGA size whose calculation is based on the value of the( )parameter.
编程题
8、Issue a SELECT statement to obtain a count of the rows in the EMPHIST table. Note
the number of rows.
9、What is the initial sizing of the data file section in your control file?
Hint: Query the dynamic performance view V$CONTROLFILE_RECORD_SECTION.
答案:B ADE BCE shared pool SGA_MAX_SIZE
select count(*) from EMPHIST
SELECT * FROM V$CONTROLFILE_RECORD_SECTION a
where a.TYPE = 'DATAFILE'
上一个:Navicat Premium连接oracle数据库之后多了很多不认识的表名
下一个:oracle 的实例删除之后,还可以登录吗?dbca工具里的删除数据库为什么变成了灰色,没法删除数据库?