Understanding Conversational Systems

Q : Which of the following features cannot be accomplished using Slack API?

A : Configuring Voice commands

Q : Managing DevOps via chat is called ChatOps. 

A : TRUE

Q : Mitsuku Bot is built for the conversational purpose on the Kik Messenger Platform. Mitsuku Bot can be classified as a ____________

A : Consumer Bot

Q : Which of the following features can be accomplished with the help of Facebook Messenger Platform

A : All

Q : Natural Language Parser is used to extract __________________ and ____________________

A : Intent , Entity

Q : What was the methodology used by the ELIZA program devised by Joseph Weizenbaum to come up with responses to questions?

A : Pattern matching

Q : Google Now, Siri, and Cortana can be grouped under ______________

A : Voice based

Q : 'Chatbot, Conversational Agent, and Dialogue Systems; all these terms are the same.' State whether this statement is true or false.

A : TRUE

Q : Bots are the new User Interface.

A : TRUE

Q : Alexa, a popular bot from Amazon provides feature to integrate with IoT devices.

A : TRUE

<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-4290849981025242"

     crossorigin="anonymous"></script>

DB2ADVIS for db2 queries tuning

Unlike other databases , DB2 has a unique feature that suggests you what indexes you need to create to tune a particular query. It also tells you if there are any unused indexes so that they can be deleted to save the memory. DB2ADVIS is the command that does this.

Inorder a DB2ADVIS command to be run , the db2profile must need to be run along with EXPLAIN.DDL

Go to the server where the db2 is installed, navigate to the 'sqllib' path and enter db2profile command, as below,

abcd\> ~servername/sqllib/db2profile

• To run the EXPLAIN.DDL, first connect to the database as below,
• db2 connect to <database>
• Change the directory to where the EXPLAIN.DDL is available. EXPLAIN.DDL file is available at the sqllib/misc path..
• cd /db2/<servername>/sqllib/misc/
• Now run the EXPLAIN.DDL as below,
• db2 -tvf  EXPLAIN.DDL
• Now you are set to run the DB2ADVIS.
• For this make sure you have the query in a text file (ex: query.in), the query.in file shouldn't have any extra spaces, otherwise the DB2ADVIS will fail.
• Run the DB2ADVIS as below,
• db2advis -d <database_name> -i query.in -o queryadvis.advis
• Here, queryadvis.advis is the output file where you will have the indexes that needs be created...
• Surprisingly these suggestions be available along with the create index queries.

<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-4290849981025242"

     crossorigin="anonymous"></script>