网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Which view shows all valid values for the NLS_LANGUAGE， NLS_SORT， NLS_TERRITORY， and NLS_CHARACTERSET parameters？（）
A
V$VALID_NLS_VALUES
B
NLS_VALID_VALUES
C
NLS_VALUE_OPTIONS
D
V$NLS_VALUE_OPTIONS
E
V$NLS_VALID_VALUES
参考答案
参考解析
解析：
暂无解析
更多 “单选题Which view shows all valid values for the NLS_LANGUAGE， NLS_SORT， NLS_TERRITORY， and NLS_CHARACTERSET parameters？（）A V$VALID_NLS_VALUESB NLS_VALID_VALUESC NLS_VALUE_OPTIONSD V$NLS_VALUE_OPTIONSE V$NLS_VALID_VALUES” 相关考题
考题
Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY,and NLS_CHARACTERSET parameters?()
A. V$VALID_NLS_VALUESB. NLS_VALID_VALUESC. NLS_VALUE_OPTIONSD. V$NLS_VALUE_OPTIONSE. V$NLS_VALID_VALUES
考题
Given the following DDL and INSERT statements:CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100);How many of these INSERT statements will be successful?（）A.0B.1C.2D.3
考题
Given the following DDL and INSERT statements: CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100); How many of these INSERT statements will be successful?（）A、0B、1C、2D、3
考题
You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（） A、 V$SYSSTATB、 V$SESSSTATC、 V$RSRC_PLAND、 V$RSRC_CONSUMER_GROUP
考题
Which three values are valid parameters for the DO_KEY built-in?（）A、ENTER B、GO_ITEM C、VALIDATE D、EXIT_FORM E、EXECUTE_QUERY
考题
Which statement regarding the contents of the V$PARAMETER view is true？（）A、displays only the list of default valuesB、displays only the list of all basic parametersC、displays the currently in effect parameter valuesD、displays only the list of all advanced parametersE、displays the list of all the parameter files of a database
考题
Which view provides information on the backup status of the datafiles in the database？（） A、 V$BACKUPB、 V$BACKUP_STATUSC、 V$BACKUP_DATAFILED、 V$DATAFILE_BACKUPE、 V$TABLESPCE_BACKUP
考题
Which view provides information on the backup status of the datafiles in the database?（）A、V$BACKUPB、V$BACKUP_STATUS C、V$BACKUP_DATAFILE D、V$DATAFILE_BACKUP E、V$TABLESPCE_BACKUP
考题
When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（） A、 The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGETB、 The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGETC、 The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory ManagementD、 The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management
考题
You execute the following RMAN commands in the order shown below： BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do？（）A、create a backup of the database and recover all corrupted blocks found in the backupB、run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the databaseC、run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the viewD、run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the viewE、run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired
考题
A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL connect smith/smith Connected. SQL SELECT * FROM v$session； SELECT * FROM v$session * ERROR at line 1： ORA-00942： table or view does not exist Which are the two possible solutions to enable SMITH to query the data in V$SESSION（）A、granting SELECT privilege to SMITH on V$SESSIONB、granting SELECT privilege to SMITH on V_$SESSIONC、asking the user SMITH to run the catalog.sql scriptD、granting SELECT privilege to SMITH on V$FIXED_TABLESE、setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUEF、creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
考题
Which dynamic view displays the status of block-change tracking?（）A、V$BLOCK_CHANGE B、V$BLOCK_CHANGE_TRACKING C、V$BLOCKCHANGE D、V$BLOCK_TRACKING
考题
You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）A、 Create a backup of the database and recover all corrupted blocks found in the backup.B、 Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.C、 Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.D、 Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.E、 Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.
考题
Which of the following dynamic view would you query to identify the online CURRENT redo log group？（）A、V$LOGB、V$LOFHISTC、V$LOGFILED、V$LOG_HISTORY
考题
单选题You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required？（）A
V$DATABASEB
V$FLASHBACK_DATABASE_STATC
V$FLASHBACK_DATABASE_LOGD
V$RECOVERY_FILE_DEST
考题
多选题Which three values are valid parameters for the DO_KEY built-in?（）AENTERBGO_ITEMCVALIDATEDEXIT_FORMEEXECUTE_QUERY
考题
单选题You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）A
Create a backup of the database and recover all corrupted blocks found in the backup.B
Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.C
Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.D
Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.E
Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.
考题
单选题The performance of your database is affected by the presence of two log members in each online redo log group and the placement of redo log members of a group on the same disk. You decide to place the redo log members of a group on separate disks. Which view will you query to find the name and location of all the online redo log members？（）A
V$LOGB
V$LOGFILEC
DBA_LOG_GROUPSD
V$LOG_HISTORY
考题
单选题Given the following DDL and INSERT statements: CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100); How many of these INSERT statements will be successful?（）A
0B
1C
2D
3
考题
单选题Which statement regarding the contents of the V$PARAMETER view is true？（）A
displays only the list of default valuesB
displays only the list of all basic parametersC
displays the currently in effect parameter valuesD
displays only the list of all advanced parametersE
displays the list of all the parameter files of a database
考题
单选题Which view provides information on the backup status of the datafiles in the database？（）A
V$BACKUPB
V$BACKUP_STATUSC
V$BACKUP_DATAFILED
V$DATAFILE_BACKUPE
V$TABLESPCE_BACKUP
考题
单选题What view might you use to try to determine how long a particular backup will take？（）A
V$SESSION_EVENTB
V$SESSIONC
V$WAITSD
V$WAITSTATE
V$SESSION_LONGOPS
考题
单选题When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）A
The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGETB
The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGETC
The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory ManagementD
The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management
考题
单选题You execute the following RMAN commands in the order shown below： BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do？（）A
create a backup of the database and recover all corrupted blocks found in the backupB
run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the databaseC
run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the viewD
run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the viewE
run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired
考题
单选题A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 1000 ; When will DB2 access the data from table T1 for view V1?（）A
When view V1 is createdB
Each time the REFRESH VIEW v1 statement is executedC
Each time an SQL statement is executed against view V1D
Only the first time an SQL statement is executed against view V1
考题
单选题You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（）A
V$SYSSTATB
V$SESSSTATC
V$RSRC_PLAND
V$RSRC_CONSUMER_GROUP
考题
单选题Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY,and NLS_CHARACTERSET parameters?（）A
V$VALID_NLS_VALUESB
NLS_VALID_VALUESC
NLS_VALUE_OPTIONSD
V$NLS_VALUE_OPTIONSE
V$NLS_VALID_VALUES
热门标签
最新试卷
