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 are properties of the MyISAM storage engine?（）
- A、Transaction support
- B、FULLTEXT indexing for text matching
- C、Table and page level locking support
- D、Foreign key support
- E、Geospatial indexing
- F、HASH index support
- G、Table level locking only
相关考题：
Which constraint can be defined only at the column level? () A. UNIQUEB. NOT NULLC. CHECKD. PRIMARY KEYE. FOREIGN KEY
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
What is true regarding InnoDB locking?() A.InnoDB uses row and table-level locks, but row locks are not escalatesB.InnoDB locks only those rows that are updatedC.InnoDB only uses row locks, not page or table-level locksD.InnoDB row locks may be escalated to page or table-level locksE.InnoDB uses row-level or table-level locks depending on the number of rows affected
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 two statements are true about InnoDB auto－increment locking?() A.The auto-increment lock can be a table-level lockB.InnoDB never uses table-level locksC.Some settings for innodb_autoinc_lock_mode can help reduce lockingD.InnoDB always protects auto-increment updates with a table-level lock
The most commonly used locking level in implementing concurrency control is at which of the following levels?A．databaseB．tableC．recordD．field
A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index. Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions. This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month. You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned. Which three methods could transparently help to achieve this result?（）A、Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.B、Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.C、Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.D、Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned columnE、Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.F、Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
While designing the database for one of your online transaction processing （OLTP） applications， you want to achieve the following： a） high availability of data b） faster primary key access to the table data c） compact storage for the table Which type of tables would you use to achieve these objectives？（）A、heap tablesB、object tablesC、partitioned tablesD、indexorganized tables （IOTs）
Which two statements are true about the primary key constraint in a table？ （）A、It is not possible to disable the primary key constraint.B、It is possible to have more than one primary key constraint in a single table.C、The primary key constraint can be referred by only one foreign key constraint.D、The primary key constraint can be imposed by combining more than one column.E、The non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.
The EMPLOYEES table is stored in the SAMPLE tablespace. The corresponding IPK_EMP index for the EMPLOYEES table’s primary key is stored in the INDX tablespace. Out of 12 partitions， only partition P1 of the SALES table is stored in the SAMPLE tablespace. Which object will be exported by this command？（） exp system/manager tablespaces=SAMPLEA、Only the EMPLOYEES table.B、Only the EMPLOYEES table and its corresponding primary key index.C、The EMPLOYEES table and partition P1.D、The EMPLOYEES table， IPK_EMP index， and the SALES table.
What is true regarding InnoDB locking?（）A、InnoDB uses row and table-level locks, but row locks are not escalatesB、InnoDB locks only those rows that are updatedC、InnoDB only uses row locks, not page or table-level locksD、InnoDB row locks may be escalated to page or table-level locksE、InnoDB uses row-level or table-level locks depending on the number of rows affected
Which constraint can be defines only at the column level?（）A、UNIQUEB、NOT NULLC、CHECKD、PRIMARY KEYE、FOREIGN KEY
Which three statements correctly describe the functions and use of constraints? （）A、Constraints provide data independence.B、Constraints make complex queries easy.C、Constraints enforce rules at the view level.D、Constraints enforce rules at the table level.E、Constraints prevent the deletion of a table if there are dependencies.F、Constraints prevent the deletion of an index if there are dependencies.
Which two statements are true about InnoDB auto-increment locking?（）A、The auto-increment lock can be a table-level lockB、InnoDB never uses table-level locksC、Some settings for innodb_autoinc_lock_mode can help reduce lockingD、InnoDB always protects auto-increment updates with a table-level lock
Which statement about the enabling of table compression in Oracle Database 11g is true?（）A、Compression can be enabled at the table, tablespace, or partition level for direct loads only.B、Compression can be enabled only at the table level for both direct loads and conventional DML.C、Compression can be enabled at the table, tablespace, or partition level for conventional DML only.D、Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.
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
The InnoDB engine has a feature known as clustered indexes. Which three statements are true about clustered indexes as used in InnoDB?（）A、A primary key must exist for creation of a clustered indexB、A clustered index allows fulltext searching within InnoDBC、The first unique index is always used as a clustered index and not a primary keyD、A clustered index provides direct access to a page containing row dataE、If no indexes exist, a hidden clustered index is generated based on row IDsF、A primary key is used as a clustered indexG、A clustered index is a grouping of indexes from different tables into a global index for faster searching
单选题What is true regarding InnoDB locking?（）AInnoDB uses row and table-level locks, but row locks are not escalatesBInnoDB locks only those rows that are updatedCInnoDB only uses row locks, not page or table-level locksDInnoDB row locks may be escalated to page or table-level locksEInnoDB uses row-level or table-level locks depending on the number of rows affected
单选题Which statement about the enabling of table compression in Oracle Database 11g is true？（）A Compression can be enabled at the table， tablespace， or partition level for direct loads only.B Compression can be enabled only at the table level for both direct loads and conventional DML.C Compression can be enabled at the table， tablespace， or partition level for conventional DML only.D Compression can be enabled at the table， tablespace， or partition level for both direct loads and conventional DML.
多选题Which three are properties of the MyISAM storage engine?（）ATransaction supportBFULLTEXT indexing for text matchingCTable and page level locking supportDForeign key supportEGeospatial indexingFHASH index supportGTable level locking only
单选题The EMPLOYEES table is stored in the SAMPLE tablespace. The corresponding IPK_EMP index for the EMPLOYEES table’s primary key is stored in the INDX tablespace. Out of 12 partitions， only partition P1 of the SALES table is stored in the SAMPLE tablespace. Which object will be exported by this command？（） exp system/manager tablespaces=SAMPLEAOnly the EMPLOYEES table.BOnly the EMPLOYEES table and its corresponding primary key index.CThe EMPLOYEES table and partition P1.DThe EMPLOYEES table， IPK_EMP index， and the SALES table.
多选题Which three statements correctly describe the functions and use of constraints? （）AConstraints provide data independence.BConstraints make complex queries easy.CConstraints enforce rules at the view level.DConstraints enforce rules at the table level.EConstraints prevent the deletion of a table if there are dependencies.FConstraints prevent the deletion of an index if there are dependencies.
多选题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 two are valid locking levels that are used by transactions in an Oracle database？（）Arow levelBblock levelCobject levelDschema levelEdatabase level
单选题While designing the database for one of your online transaction processing （OLTP） applications， you want to achieve the following： a） high availability of data b） faster primary key access to the table data c） compact storage for the table Which type of tables would you use to achieve these objectives？（）A heap tablesB object tablesC partitioned tablesD index-organized tables （IOTs）