WorksheetsBest Practices to Improve The Performance Of The System
Total questions: 7
Worksheet time: 4mins
From the choices below, which are practical applications of Indexing? Choose all that apply.
Phonebook
Essay
Table of Contents
Philippine History Timeline
Fill in the blank. Choose the most appropriate word.
Definition of Indexing
The way to get an unordered table into an order that will ________ the query’s efficiency while searching
Reduce
Escalate
Maximize
Lessen
In the Lua function GetDLDObjectInfo(), which property should be added/used and should be set to "true" if you want to get the information of the objects inside a specific object?
bool addProperty
bool includeParent
string objectChildren
bool includeChildren
Which of the following statements are true about indexing?
It makes the reading and writing faster.
It makes the writing faster but makes the reading slower.
It makes the reading faster but makes the writing slower.
It makes both the reading and writing slower.
In this MongoDB Create Index command, which is the table name?
db.getCollection("TN_Meritize").ensureIndex({"ActiveAppsFlag":1, "system.hidden":1}, {name: "InactiveTables", background: false });
"TN_Meritize"
"InactiveTables"
"ensureIndex"
Which MySQL DROP Index command is correct?
ALTER sampledb.sampletable DROP INDEX findRecord;
DROP INDEX findRecord IN sampledb.sampletable;
ALTER TABLE sampledb.sampletable DROP INDEX findRecord;
IN TABLE sampledb.sampletable DROP INDEX findRecord;
You have a source connector that still process all the code in the output parsing script even if there is no data stream returned which results to slow performance. What can you do to improve the performance of it?
Create a conditional statement and an error flag that will be used to prevent running the succeeding codes if the error flag is empty
Rearrange the code so that the data stream will be supplied with a value even if the data source don't send anything
Create a conditional statement and an error flag that will be used to prevent running the succeeding codes if the data stream is empty
