单项选择题

View the Exhibit and examine the output of the query.
What do you infer from this（）

A.The SGA_TARGET is a static parameter.
B.The instance is started， but the database is not yet open.
C.The server parameter file （SPFILE） was used to start the instance.
D.The SGA_TARGET parameter does not have any effect on the database instance until theSGA_MAX_SIZE parameter is specified

点击查看答案

上一题目录下一题

相关考题

多项选择题

You are managing an Oracle Database 11g database. The database is open， and you plan to perform
Recovery Manager （RMAN） backups.
Which three statements are true about these backups（）

A.The backups would be consistent.
B.The backups would be inconsistent.
C.The backups would be possible only if the database is running in ARCHIVELOG mode.
D.The backups would be possible only if the database is running in NOARCHIVELOG mode.
E.The backups need to be restored and the database has to be recovered in case of a media failure

单项选择题

In your production database， data manipulation language （DML） operations are executed on the SALES table.You have noticed some dubious values in the SALES table during the last few days. You are able to track
users， actions taken， and the time of the action for this particular period but the changes in data are not tracked.You decide to keep track of both the old data and new data in the table along with the user information.
Whataction would you take to achieve this task（）

A.Apply fine-grained auditing.
B.Implement value-based auditing.
C.Impose standard database auditing to audit object privileges.
D.Impose standard database auditing to audit SQL statements.

单项选择题

The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in yourdatabase instance. At a certain point of time， the maintenance window closes before the statistics are gatheredfor all objects.
Which statement is true in this scenario（）

A.The statistics collection continues until all objects are processed.
B.The job is terminated and the statistics collected are restored to a time before the job started.
C.This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.
D.The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened

View the Exhibit and examine the output of the query. What do you infer from this（）

相关考题

View the Exhibit and examine the output of the query.
What do you infer from this（）