网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
In which scenario would an index be most useful?（）
- A、The indexed column is declared as NOT NULL.
- B、The indexed columns are used in the FROM clause.
- C、The indexed columns are part of an expression.
- D、The indexed column contains a wide range of values.
参考答案
更多 “In which scenario would an index be most useful?（）A、The indexed column is declared as NOT NULL.B、The indexed columns are used in the FROM clause.C、The indexed columns are part of an expression.D、The indexed column contains a wide range of values.” 相关考题
考题
In which scenario would index be most useful? ()
A. The indexed column is declared as NOT NULL.B. The indexed columns are used in the FROM clause.C. The indexed columns are part of an expression.D. The indexed column contains a wide range of values.
考题
Examine the SQL statements that creates ORDERS table:For which columns would an index be automatically created when you execute the above SQL statement? ()
A. SER_NOB. ORDER_IDC. STATUSD. PROD_IDE. ORD_TOTALF. Composite index on ORDER_ID and ORDER_DATE
考题
You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）A、loss of a tempfileB、loss of a system data fileC、loss of one of the control filesD、loss of one of the tablespacesE、loss of a member from each redo log groupF、loss of the only member of an unarchived redo log group
考题
You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）A、The instance would hang.B、The instance needs to be shut down.C、The instance would be in the open state.D、The instance would abort in such cases.E、The instance would be in the open and invalid state.F、The instance would in the open state， but all the background processes will be restarted.
考题
Evaluate the CREATE TABLE statement： CREATE TABLE products （product_id NUMBER （6） CONSTRAINT prod_id_pk PRIMARY KEY， product_name VARCHAR2 （15））； Which statement is true regarding the PROD_ID_PK constraint？（）A、 It would be created only if a unique index is manually created first.B、 It would be created and would use an automatically created unique index.C、 It would be created and would use an automatically created nonunique index.D、 It would be created and remains in a disabled state because no index is specified in the command.
考题
Your database is running in the ARCHIVELOG mode. You placed a tablespace， tbs_1， offline with the immediate option. Which statement is correct in this scenario？ （）A、The operation would fail if tbs_1 were a read-only tablespace.B、The operation would fail if tbs_1 were a read/write tablespace.C、The operation would fail if tbs_1 were the default tablespace for the database.D、If the above operation were successful， media recovery would be required to bring the tablespace online.E、If the above operation were successful， instance recovery would be required to bring the tablespace online.
考题
You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）A、 ONLINEB、 REVERSEC、 PARALLELD、 COMPRESSE、 NOLOGGINGF、 COMPUTE STATISTICS
考题
Your application regularly issues the following statement: SELECT * FROM BANK_ACCT WHERE ACCT_BALANCE BETWEEN 1000 and 10000; Which of the following database objects would be inappropriate for use with this statement?（）A、Materialized views B、Indexes C、Index-organized tables D、Hash clusters
考题
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）A、The index remains invisible.B、The index is not updated by the DML statements on the indexed table.C、The index automatically becomes visible in order to have it updated by DML on the table.D、The index becomes unusable but the table is updated by the DML.E、The index is updated by the DML on the table.
考题
单选题View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table： ALTER TABLE emp ADD CONSTRAINT emp_id_pk PRIMARY KEY （emp_id） USING INDEX emp_id_idx； Which statement is true regarding the effect of the command？（）A
The PRIMARY KEY is created along with a new index.B
The PRIMARY KEY is created and it would use an existing unique index.C
The PRIMARY KEY would be created in a disabled state because it is using an existing index.D
The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.
考题
多选题You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）AONLINEBREVERSECPARALLELDCOMPRESSENOLOGGINGFCOMPUTE STATISTICS
考题
单选题You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）A
The instance would hang.B
The instance needs to be shut down.C
The instance would be in the open state.D
The instance would abort in such cases.E
The instance would be in the open and invalid state.F
The instance would in the open state， but all the background processes will be restarted.
考题
多选题In which scenarios would you rebuild an index？（）Awhen you need to disable the index usageBwhen you need to change storage optionsCwhen you need to enable index monitoringDwhen you need to move the index to another tablespace
考题
单选题An administrator has a single 14U rack. The administrator needs to install fifteen servers； rack-mounted redundant uninterruptible power supplies （UPSs）， a network switch， and a KVM. Which of the following server types would be BEST suited for this scenario？（）A
Blade serversB
Rackmount serversC
Tower serversD
Web servers
考题
单选题The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance？（）A
BtreeB
bitmapC
reverse keyD
function based
考题
单选题In which scenario would TOP N analysis be the best solution? （）A
You want to identify the most senior employee in the company.B
You want to find the manager supervising the largest number of employees.C
You want to identify the person who makes the highest salary for all employees.D
You want to rank the top three sales representatives who have sold the maximum number of products.
考题
单选题Evaluate the CREATE TABLE statement： CREATE TABLE products （product_id NUMBER （6） CONSTRAINT prod_id_pk PRIMARY KEY， product_name VARCHAR2 （15））； Which statement is true regarding the PROD_ID_PK constraint？（）A
It would be created only if a unique index is manually created first.B
It would be created and would use an automatically created unique index.C
It would be created and would use an automatically created nonunique index.D
It would be created and remains in a disabled state because no index is specified in the command.
考题
单选题In which scenario would an index be most useful?（）A
The indexed column is declared as NOT NULL.B
The indexed columns are used in the FROM clause.C
The indexed columns are part of an expression.D
The indexed column contains a wide range of values.
考题
多选题You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re/x7fcreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re/x7fcreate the indexes？（）AONLINEBREVERSECPARALLELDCOMPRESSENOLOGGINGFCOMPUTE STATISTICS
考题
单选题You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）A
loss of one of the tablespacesB
loss of a system data fileC
loss of one of the control filesD
loss of a tempfileE
loss of the only member of an unarchived redo log groupF
loss of a member from each redo log group
考题
单选题You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used. Which method would you follow to achieve this？（）A
enable index monitoring and query the DBA_OBJECTS viewB
enable index monitoring and query the DBA_INDEXES viewC
enable index monitoring and query the V$OBJECT_USAGE viewD
enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
考题
单选题You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）A
loss of a tempfileB
loss of a system data fileC
loss of one of the control filesD
loss of one of the tablespacesE
loss of a member from each redo log groupF
loss of the only member of an unarchived redo log group
考题
单选题Your database is running in the ARCHIVELOG mode. You placed a tablespace， tbs_1， offline with the immediate option. Which statement is correct in this scenario？ （）A
The operation would fail if tbs_1 were a read-only tablespace.B
The operation would fail if tbs_1 were a read/write tablespace.C
The operation would fail if tbs_1 were the default tablespace for the database.D
If the above operation were successful， media recovery would be required to bring the tablespace online.E
If the above operation were successful， instance recovery would be required to bring the tablespace online.
考题
多选题You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）AThe index remains invisible.BThe index is not updated by the DML statements on the indexed table.CThe index automatically becomes visible in order to have it updated by DML on the table.DThe index becomes unusable but the table is updated by the DML.EThe index is updated by the DML on the table.
考题
多选题You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）ARestore the lost data file from the backup， and then flash back the database.BRestore the data file pertaining to index tablespace， and then recover the tablespace.CRestore all the data files， and then perform an incomplete recovery to get the tablespace back.DRestore all the data files， and then perform an incomplete recovery using the backup control file.EDrop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.
考题
多选题Examine the SQL statements that creates ORDERS table: For which columns would an index be automatically created when you execute the above SQL statement? （）ASER_NOBORDER_IDCSTATUSDPROD_IDEORD_TOTALFComposite index on ORDER_ID and ORDER_DATE
热门标签
最新试卷