Posts

Showing posts from December, 2015

Google AdWords Video Advertising Exam Answers

1)  Which of the following is a tip for optimizing a TrueView video ad campaign?   A)  Remove all but one targeting group from the campaign.   B)  Add exclusions to the campaign or targeting group.   C)  All of the listed answers are incorrect.   D)  Increase each target group’s bid by 100%. 2)  What is an example of a managed placement for a TrueView in-stream ad?   A)  A website on the Google Display Network (GDN).   B)  All of the listed answers are correct.   C)  A YouTube channel.   D)  YouTube watch page.    3)  A TrueView in-stream ad view is counted when a viewer:   A)  watches at least 25% of the video.   B)  watches at least 30 seconds of the video or completes it.   C)  watches the video for five seconds or longer.   D)  watches the video until the last quartile. 4)  What is the maxim...

Query to get GL code combinations description

---------- 1) Below given query can be used TO get concatenated Gl code combinations segment AND its description USING API GL_FLEXFIELDS_PKG.get_concat_description ---------- SELECT gcc.CODE_COMBINATION_ID, gcc.CONCATENATED_SEGMENTS, APPS.GL_FLEXFIELDS_PKG.get_concat_description(gcc.chart_of_accounts_id, gcc.code_combination_id) acc_description FROM gl_code_combinations_kfv gcc; ---------- 2)Below given Query can be used WHEN one dont have access TO GL_FLEXFIELDS_PKG.get_concat_description API. ---------- SELECT gcc.CODE_COMBINATION_ID, gcc.CONCATENATED_SEGMENTS, acc_desc.acc_description FROM ( SELECT gcc.code_combination_id, A1.DESCRIPTION ||'.' ||A2.DESCRIPTION ||'.' || A3.DESCRIPTION ||'.' || A4.DESCRIPTION ||'.' || A5.DESCRIPTION ||'.' || A6.DESCRIPTION ||'.' || A7.DESCRIPTION ...