多选题Which three statements are characteristic of the MEMORY storage engine?（）AIt can support transactionsBTable contents are not saved if the server is restartedCIt cannot contain text or BLOB columnsDIt can support foreign keysEEach table is represented on disk as an.frm fileFEach table has a corresponding.MYI and .MYD file
多选题
Which three statements are characteristic of the MEMORY storage engine?（）
A
It can support transactions
B
Table contents are not saved if the server is restarted
C
It cannot contain text or BLOB columns
D
It can support foreign keys
E
Each table is represented on disk as an.frm file
F
Each table has a corresponding.MYI and .MYD file
参考解析
解析：
暂无解析
相关考题：
Which three are properties of the MyISAM storage engine?() A.Transaction supportB.FULLTEXT indexing for text matchingC.Table and page level locking supportD.Foreign key supportE.Geospatial indexingF.HASH index supportG.Table level locking only
Which three statements are characteristic of the MEMORY storage engine?() A.It can support transactionsB.Table contents are not saved if the server is restartedC.It cannot contain text or BLOB columnsD.It can support foreign keysE.Each table is represented on disk as an.frm fileF.Each table has a corresponding.MYI and .MYD file
Which four of these statements are restrictions for Frame Relay PVC bundles with QoS support for IP and MPLS？ （）A、A PVC bundle will not come up unless all the precedence， DSCP， and EXP levels are configured in thebundle.B、A PVC bundle can perform precedence and DSCP matching at the same timeC、A PVC bundle may contain no more than sixteen PVCsD、A PVC can be in only one PVC bundleE、A PVC bundle cannot perform precedence and DSCP matching at the same time.F、A PVC bundle may contain no more than eight PVCs.
A customer wants to hold all enterprise data on their DS4000 system. Several servers were added after they purchased another company. The servers that have to be run are： （1）An Oracle database running on a HP-UX server （2）Several virtual machines running on VMWare ESX server （3）A Microsoft cluster running Exchange 2000 server Which of these new servers can be integrated with the DS4000？（）A、DS4000 storage does not support HP-UX， so the HP-UX server cannot be integrated.All other new servers can be used.B、An Exchange cluster needs local disks， so the DS4000 cannot be used for this.All other new servers can be used.C、When equipped with proper HBA’s and subsystem device drivers， all new servers can operate with the DS4000 storage device.D、VMWare ESX can use the DS4000 storage； however， the virtual machines running in it will not have access to this storage other than via a virtual disk.All other new servers can be used.
Which two statements are true about overflow pools？（）A、Overflow pools do not support PATB、Overflow pools can not use the egress interface IP address for NATC、Overflow pools must use PATD、Overflow pools can contain the egress interface IP address or separate IP addresses
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 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 three are properties of the MyISAM storage engine?（）A、Transaction supportB、FULLTEXT indexing for text matchingC、Table and page level locking supportD、Foreign key supportE、Geospatial indexingF、HASH index supportG、Table level locking only
Which three statements are characteristic of the MEMORY storage engine?（）A、It can support transactionsB、Table contents are not saved if the server is restartedC、It cannot contain text or BLOB columnsD、It can support foreign keysE、Each table is represented on disk as an.frm fileF、Each table has a corresponding.MYI and .MYD file
多选题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 statements are true regarding the creation of an incident package file by using the EM Workbench Support？（）AYou can add or remove the trace files to the package.BYou can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.CYou can add SQL test cases to the incident package.DYou cannot create an incremental incident package when the physical files are purged rom the ADR.
多选题Which two statements are true regarding the USING clause in table joins?（）AIt can be used to join a maximum of three tablesBIt can be used to restrict the number of columns used in a NATURAL joinCIt can be used to access data from tables through equijoins as well as nonequijoinsDIt can be used to join tables that have columns with the same name and compatible data types
多选题What two statements are true regarding the recommendations received from the SQL Access Advisor？（）AIt cannot generate recommendations that support multiple workload queries.BIt can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.CIt can recommend partitioning only on tables that have at least 10，000 rows.DIt can recommend only B-tree indexes and not bitmap or function-based indexes.
多选题Which three pre-conditions must be met before an OSPF router can perform graceful restart？（）ARouter must be ABRBRouter must contain one sham link.CThe network topology must be stable.DRouter must be able to forward packets.ENeighbors must support graceful restart.
多选题Which three tasks can be performed using regular expression support in Oracle Database 10g？（）Ait can be used to concatenate two strings.Bit can be used to find out the total length of the string.Cit can be used for string manipulation and searching operations.Dit can be used to format the output for a column or expression having string data.Eit can be used to find and replace operations for a column or expression having string data.
多选题Which four of these statements are restrictions for Frame Relay PVC bundles with QoS support for IP and MPLS？ （）AA PVC bundle will not come up unless all the precedence， DSCP， and EXP levels are configured in thebundle.BA PVC bundle can perform precedence and DSCP matching at the same timeCA PVC bundle may contain no more than sixteen PVCsDA PVC can be in only one PVC bundleEA PVC bundle cannot perform precedence and DSCP matching at the same time.FA PVC bundle may contain no more than eight PVCs.
多选题Which two statements are true regarding a PL/SQL package body？（）AIt cannot be created without a package specification.BIt cannot invoke subprograms defined in other packages.CIt can contain only the subprograms defined in the package specification.DIt can be changed and recompiled without making the package specification invalid.
多选题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 three 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 feature is a potential security weakness of a traditional stateful firewall？（）AIt cannot support UDP flows.BIt cannot ensure each TCP connection follows a legitimate TCP three-way handshake.CIt cannot detect application-layer attacks.DThe status of TCP sessions is retained in the state table after the sessions terminate.
多选题Which three statements are characteristic of the MEMORY storage engine?（）AIt can support transactionsBTable contents are not saved if the server is restartedCIt cannot contain text or BLOB columnsDIt can support foreign keysEEach table is represented on disk as an.frm fileFEach table has a corresponding.MYI and .MYD file
多选题Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）AIt releases the storage space used by the table.BIt does not release the storage space used by the table.CYou can roll back the deletion of rows after the statement executes.DYou can NOT roll back the deletion of rows after the statement executes.EAn attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.FYou must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table
多选题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 statements are true regarding the Query Result Cache？（）AIt can be set at the system， session， or table level.BIt is used only across statements in the same session.CIt can store the results from normal as well as flashback queries.DIt can store the results of queries based on normal，temporary，and dictionary tables.
多选题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
多选题Which three statements describe how the strict SQL mode provides added security?（）AIt rejects statements that try to insert out-of-range valuesBIt rejects invalid datesCIt limits the operations that the server can performDIt rejects queries that produce out-of-range valuesEIt rejects dates with zero day or month values
多选题Which two statements are true about overflow pools？（）AOverflow pools do not support PATBOverflow pools can not use the egress interface IP address for NATCOverflow pools must use PATDOverflow pools can contain the egress interface IP address or separate IP addresses