网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
What is true regarding a shared， server-side parameter file for a Real Application Cluster database？ （）
- A、It can contain parameters with distinct values for each distance.
- B、It can contain only parameters with identical values for each instance.
- C、It must contain an IFILE parameter for each instance’s individual parameter file.
- D、It must be located in the default location for the primary instance’s parameter file.
参考答案
更多 “What is true regarding a shared， server-side parameter file for a Real Application Cluster database？ （）A、It can contain parameters with distinct values for each distance.B、It can contain only parameters with identical values for each instance.C、It must contain an IFILE parameter for each instance’s individual parameter file.D、It must be located in the default location for the primary instance’s parameter file.” 相关考题
考题
You set the following parameters in the parameter file and restarted the database:Which two statements are true regarding these parameters after the database instance is restarted?()
A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MBB. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manuallyC. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zeroD. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively
考题
Which two statements are true regarding interface properties? ()
A.MTU and speed must be configured under each unit.B.Physical parameters such as MTU, duplex mode, and speed are configured under the interface name.C.IP and IPv6 addresses are configured under a unit-number.D.DLCI numbers, VPI/VCI values, and VLAN tags are physical parameters.
考题
Which statement is true regarding Dynamic Service Registration？（）A、Dynamic service registration requires configuration in the listener .ora file.B、Dynamic service registration can be used only with an Oracle9/instance.C、Dynamic service registration cannot register a local listener that does not use TCP/IP or port 1521.D、The PMON background process automatically registers each database instance if the necessary parameters have been set in the database initialization parameter file.
考题
You are trying to change the polling parameters used by the location manager via the Cisco WCS， and yourrequest is being denied. What is wrong？（）A、Your login does not have the correct permissions.B、You must wait for the location server to become available.C、Polling values can be changed only on the location server.D、Polling values can be changed only in the maintenance window.
考题
Which two statements are true regarding interface properties? （）A、MTU and speed must be configured under each unit.B、Physical parameters such as MTU, duplex mode, and speed are configured under the interface name.C、IP and IPv6 addresses are configured under a unit-number.D、DLCI numbers, VPI/VCI values, and VLAN tags are physical parameters.
考题
Which three statements are true regarding subqueries?（）A、Subqueries can contain GROUP BY and ORDER BY clauses B、Main query and subquery can get data from different tables C、Main query and subquery must get data from the same tables D、Subqueries can contain ORDER BY but not the GROUP BY clause E、Only one column or expression can be compared between the main query and subqueryF、 Multiple columns or expressions can be compared between the main query and subquery
考题
Which statement about windows and blocks is true?（）A、Transaction management is block-oriented rather than window-oriented. B、Forms automatically navigates to an item located in an activated window. C、A window may contain multiple blocks, but each block can only span one window. D、A window can contain multiple canvases, and an item can be located on multiple canvases.
考题
You are trying to change the polling parameters used by the location manager via the Cisco WCS，and your request is being denied. What is wrong？（）A、Polling values can be changed only in the maintenance window.B、Polling values can be changed only on the location server.C、Your login does not have the correct permissions.D、You must wait for the location server to become available.
考题
Which three statements regarding the server parameter file （SPFILE） are true（）A、An SPFILE is a binary file.B、An SPFILE cannot reside on a client.C、An SPFILE cannot contain static parameters.D、An SPFILE can store changes persistently across instance restarts.E、An SPFILE can be read by the database server， but it is not written to by the server.F、An SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database.
考题
Which statements are true regarding a tablespace（）A、It can span multiple databases.B、It can consist of multiple data files.C、It can contain blocks of different sizes.D、It can contain segments of different sizes.E、It can contain a part of a nonpartitioned segment
考题
Which statement about Automatic Memory Management with Oracle 11g is true？（） A、 You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.B、 Oracle can reallocate memory between the SGA and PGA automatically as needed.C、 To use Automatic Memory Management， you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.D、 You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
考题
Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B?（）A、A must contain all of the characters defined in BB、A must be UnicodeC、The encoded values in A must match the encoded values in B for all characters defined in BD、A must be a multibyte character setE、The encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B
考题
How can you make a shared server-side initialization parameter file available to all instances of a Real Application Clusters database？（）A、Include an SPFILE parameter in each instance-specified initialization file.B、Create an SPFILE copy on each client from which the instance will be started.C、Store the SPFILE in a raw partition with a vendor-specifies location and name.D、Use a single client to start the instances and create the SPFILE on this client.
考题
Which two statements are true regarding a tablespace（）A、It can span multiple databases.B、It can consist of multiple data files.C、It can contain blocks of different sizes.D、It can contain segments of different sizes.E、It can contain a part of a nonpartitioned segment.
考题
The database was started up using a text parameter file. What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement？（）A、Only MEMORY is updated.B、Only SPFILE values are updated.C、Only init.ora parameters are updated.D、Both init.ora parameters and SPFILE values are updated.
考题
Which two statements are true regarding the starting of the database instance using the following command？（） SQLSTARTUP UPGRADE A、 It enables all system triggers.B、 It allows only SYSDBA connections.C、 It ensures that all job queues remain active during the upgrade process.D、 It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.
考题
You design a Business Intelligence （BI） solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services （SSRS） solution that contains five sales dashboard reports. Users must be able to manipulate the reports’ parameters to analyze data. You need to ensure that the following requirements are met： Users can manipulate the parameters for data analysis in a single trip to the data source. Reports are automatically rendered as soon as they are accessed for the first time. Which two tasks should you perform？（）A、 Filter data by using expressions.B、 Specify the default values for each parameter.C、 Create an available values list for each parameter.D、 Create report parameters by using query parameters to filter data at the data source.
考题
多选题Which statements regarding the server parameter file （SPFILE） are true（）AAn SPFILE is a binary file.BAn SPFILE cannot reside on a client.CAn SPFILE cannot contain static parameters.DAn SPFILE can store changes persistently across instance restarts.EAn SPFILE can be read by the database server， but it is not written to by the server.FAn SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database
考题
单选题Which statement about windows and blocks is true?（）A
Transaction management is block-oriented rather than window-oriented. B
Forms automatically navigates to an item located in an activated window. C
A window may contain multiple blocks, but each block can only span one window. D
A window can contain multiple canvases, and an item can be located on multiple canvases.
考题
多选题You set the value of the SGA_TARGET initialization parameter to 1G to enable Oracle to automatically resize most of the memory components according to the current workload in the database. You issue the following statement： SQL SELECT name， value， isdefault 2 FROM v$parameter 3 WHERE name LIKE ’%size%’； The output of this statement displays that the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters contain a zero value. What does this imply？（）AThe SGA_TARGET initialization parameter cannot be set to a value less than 1GBThe SGA_TARGET initialization parameter cannot be set to a value greater than 1GCThe Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGADThe values of the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters cannot be set manually.ENo minimum limits are imposed on the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters.FThe Automatic Shared Memory Management feature cannot be disabled unless you specify values for the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters in the initialization parameter file.
考题
单选题What is true regarding a shared， server-side parameter file for a Real Application Cluster database？ （）A
It can contain parameters with distinct values for each distance.B
It can contain only parameters with identical values for each instance.C
It must contain an IFILE parameter for each instance’s individual parameter file.D
It must be located in the default location for the primary instance’s parameter file.
考题
单选题The database was started up using a text parameter file. What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement？（）A
Only MEMORY is updated.B
Only SPFILE values are updated.C
Only init.ora parameters are updated.D
Both init.ora parameters and SPFILE values are updated.
考题
多选题Which statements are true regarding a tablespace（）AIt can span multiple databases.BIt can consist of multiple data files.CIt can contain blocks of different sizes.DIt can contain segments of different sizes.EIt can contain a part of a nonpartitioned segment
考题
单选题Which statement about Automatic Memory Management with Oracle 11g is true？（）A
You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.B
Oracle can reallocate memory between the SGA and PGA automatically as needed.C
To use Automatic Memory Management， you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.D
You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.
考题
单选题Which statement is true regarding Dynamic Service Registration？（）A
Dynamic service registration requires configuration in the listener .ora file.B
Dynamic service registration can be used only with an Oracle9/instance.C
Dynamic service registration cannot register a local listener that does not use TCP/IP or port 1521.D
The PMON background process automatically registers each database instance if the necessary parameters have been set in the database initialization parameter file.
考题
多选题Which two statements are true regarding a tablespace（）AIt can span multiple databases.BIt can consist of multiple data files.CIt can contain blocks of different sizes.DIt can contain segments of different sizes.EIt can contain a part of a nonpartitioned segment.
考题
多选题Which three statements are true regarding subqueries?（）ASubqueries can contain GROUP BY and ORDER BY clausesBMain query and subquery can get data from different tablesCMain query and subquery must get data from the same tablesDSubqueries can contain ORDER BY but not the GROUP BY clauseEOnly one column or expression can be compared between the main query and subqueryFMultiple columns or expressions can be compared between the main query and subquery
热门标签
最新试卷