Observe&ensp;the&ensp;information&ensp...

单项选择题 Observe the information in the columns：
1： The SGA a. Text and parsed forms of all SQL statements
2： The cursor state b. Run-time memory values for the SQL statement， such as rows retrieved
3： User-session data c. Security and resource usage information
4：The stack space d. Local variables for the process
Which option has the correct match between the memory areas and their contents（）

A.1-c，2-b，3-d，4-a
B.1-c，2-b，3-c，4-a
C.1-a，2-b，3-c，4-d
D.1-a，2-b，3-d，4-c

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题 You have issued a SHUTDOWN ABORT command to bring down your database instance. Considerthe steps that will be performed later when you open the database：
1：SGA is allocated.
2：Control file is read.
3：Redo log files are read.
4：Instance recovery is started.
5：Background processes are started.
6：Data files are checked for consistency.
7：Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur（）

A.7，1，5，2，3，6，4
B.1，2，3，7，5，6，4
C.7，1，4，5，2，3，6
D.1，7，5，4，2，3，6

点击查看答案

2.单项选择题 Note the following points describing various utilities in Oracle Database 11g：
1：It enables the high-speed transfer of data from one database to another.
2：It provides a complete solution for the backup， restoration， and recovery needs of the entire database.
3：It enables the loading of data from an external file into an Oracle database.
4：It provides a tape backup management for the Oracle ecosystem. Which point describes Oracle Secure Backup（）

A.1
B.2
C.3
D.4
E.1，2，and 4
F.1，2，3，and 4

点击查看答案

3.单项选择题 The database instance is currently using SPFILE. View the Exhibit and examine the error that youreceived while running the DB Structure Integrity check.

Given below are the steps to recover from the error in random order:
1: Shut down the instance, if not already done.
2: Copy one of the remaining control files to a new location.
3: Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.
4: Start up the database instance to the NOMOUNT stage.
5: Recover the database to the point of failure of the control file.
6: Open the database.
Identify the correct sequence of steps()

A.1，2，4，3，5，6
B.2，4，3，5，6；1 not required
C.4，5，6，2，3；1 not required
D.5，2，3，4；1 and 6 not required

点击查看答案

4.单项选择题Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）

A.You can perform online whole database backups.
B.You can performofflinewhole database backups.
C.You cannot perform schema-level export/import operations.
D.You can perform the backup of only the SYSTEM tablespace when the database is open.

点击查看答案

5.多项选择题Which two statements are true about the Automatic Workload Repository （AWR）（）

A.All AWR tables belong to the SYSTEM schema.
B.The AWR contains systemwide tracing and logging information.
C.The snapshots collected by the AWR are accessible through data dictionary views.
D.The snapshots collected by the AWR are used by self-tuning components in the database.

点击查看答案&解析

6.单项选择题 View the Exhibit and examine the attributes of an undo tablespace.

In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hourthat performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives thefollowing error:
ORA-01555: snapshot too old
What could be the reason for this error（）

A.The query is unable to get a read-consistent image.
B.There is not enough space in Flash Recovery Area.
C.There is not enough free space in the flashback archive.
D.The query is unable to place data blocks in undo tablespace

点击查看答案&解析