{"id":2400,"date":"2013-10-08T08:47:33","date_gmt":"2013-10-08T10:47:33","guid":{"rendered":"http:\/\/fabriciolima.net\/blog\/?p=2400"},"modified":"2017-02-04T15:06:27","modified_gmt":"2017-02-04T17:06:27","slug":"sql-server-2012-simulado-para-a-prova-70-461-parte-1","status":"publish","type":"post","link":"https:\/\/fabriciolima.net\/blog\/2013\/10\/08\/sql-server-2012-simulado-para-a-prova-70-461-parte-1\/","title":{"rendered":"SQL Server 2012 – Simulado para a prova 70-461 \u2013 Parte 1"},"content":{"rendered":"
\n

Ol\u00e1 Pessoal,<\/p>\n

Depois do sucesso de visualiza\u00e7\u00f5es da s\u00e9rie de simulados para a prova 70-432, a pr\u00f3xima s\u00e9rie de simulados ser\u00e1 para a Prova 70-461 – Querying Microsoft SQL Server 2012\/2014<\/b><\/a><\/b>. Essas quest\u00f5es tomar\u00e3o como base o Training Kit dessa prova.<\/p>\n

Para mais informa\u00e7\u00f5es sobre as Certifica\u00e7\u00f5es do SQL Server 2012<\/b>, veja esse Post: MCSA e MCSE em SQL Server 2012\/2014<\/a><\/p>\n

Como n\u00e3o temos muito tempo livre para escrever e ler posts muito grandes, postarei apenas 5 quest\u00f5es por Post<\/b>.<\/p>\n

Segue abaixo as primeiras quest\u00f5es (n\u00e3o vale pesquisar!!!):<\/p>\n

 
\n1)<\/b> Na ordem de escrita de uma query, a cl\u00e1usula order by deve vir depois de qual cl\u00e1usula abaixo?<\/p>\n

A –<\/b> GROUP BY
\nB –<\/b> WHERE
\nC –<\/b> HAVING
\nD –<\/b> FROM<\/p>\n

2)<\/b> Qual \u00e9 a ordem l\u00f3gica correta que o SQL processa uma query?<\/p>\n

A –<\/b> FROM > WHERE > GROUP BY > HAVING > SELECT > ORDER BY
\nB –<\/b> FROM > WHERE > SELECT > GROUP BY > HAVING > ORDER BY
\nC –<\/b> FROM > WHERE > ORDER BY > GROUP BY > HAVING > SELECT
\nD –<\/b> FROM > WHERE > SELECT > ORDER BY > GROUP BY > HAVING<\/p>\n

3)<\/b> Quais s\u00e3o as formas de se criar um ALIAS no SQL Server? (Marque todas as alternativas corretas)<\/p>\n

A –<\/b> <expression> AS <alias>
\nB –<\/b> <expression> <alias>
\nC –<\/b> <alias> = <expression>
\nD –<\/b> <expression> APELIDO <alias><\/p>\n

4)<\/b> De acordo com o T-SQL, quais s\u00e3o as cl\u00e1usulas obrigat\u00f3rias em uma query de SELECT?<\/p>\n

A –<\/b> As cl\u00e1usulas FROM E SELECT
\nB –<\/b> As cl\u00e1usulas SELECT E WHERE
\nC –<\/b> A cl\u00e1usula SELECT
\nD –<\/b> As cl\u00e1usulas SELECT, FROM E WHERE<\/p>\n

5)<\/b> O que acontece ap\u00f3s a execu\u00e7\u00e3o do comando: SELECT TRY_CAST(‘abc’ AS INT).<\/p>\n

A –<\/b> Um erro \u00e9 gerado
\nB –<\/b> Um valor null \u00e9 retornado
\nC –<\/b> Um valor inteiro \u00e9 retornado
\nD –<\/b> Uma string \u00e9 retornada<\/p>\n

Quest\u00e3o Extra:<\/b> Qual \u00e9 a diferen\u00e7a entre as cl\u00e1usulas WHERE e HAVING?<\/p>\n

Em at\u00e9 3 dias \u00fateis postarei as respostas nos coment\u00e1rios desse post. Tamb\u00e9m avisarei via Twitter (@Fabriciodba<\/strong>).<\/p>\n

 <\/p>\n

Gostou desse Post?<\/b><\/p>\n

Curta, comente, compartilhe\u2026<\/p>\n

Assine meu canal no Youtube<\/a> e curta minha p\u00e1gina no Facebook<\/a> para receber Dicas de Leituras, V\u00eddeos e Eventos sobre SQL Server.<\/p>\n

Confira mais informa\u00e7\u00f5es sobre essa e outras Certifica\u00e7\u00f5es na p\u00e1gina Materiais para Certifica\u00e7\u00e3o<\/a>.<\/p>\n

At\u00e9 a pr\u00f3xima.<\/p>\n

Fabr\u00edcio Lima<\/p>\n

MCITP \u2013 Database Administrator<\/p>\n

Consultor e Instrutor SQL Server<\/p>\n

Trabalha com SQL Server desde 2006<\/p>\n","protected":false},"excerpt":{"rendered":"

Ol\u00e1 Pessoal, Depois do sucesso de visualiza\u00e7\u00f5es da s\u00e9rie de simulados para a prova 70-432, a pr\u00f3xima s\u00e9rie de simulados ser\u00e1 para a Prova 70-461 – Querying Microsoft SQL Server 2012\/2014. Essas quest\u00f5es tomar\u00e3o como base o Training Kit dessa prova. Para mais informa\u00e7\u00f5es sobre as Certifica\u00e7\u00f5es do SQL Server 2012, veja esse Post: MCSA […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[636,17,33,496,280],"tags":[142,915,916,987,908,508,978,197,970,517,971,17,917,521,522,519,983,982,533,927,974,535,512,979,980,972,976,973,977,516,534,985,986,518,981,975,520,33,497,988,984],"class_list":["post-2400","post","type-post","status-publish","format-standard","hentry","category-certificacao-2","category-certificacao","category-sql-server","category-sql-server-2012","category-virtual-pass-br","tag-70-453","tag-70-457","tag-70-458","tag-70-459","tag-70-461","tag-apostila-sql-server-2012","tag-apostila-sql-server-2012-portugues","tag-certificacao-microsoft","tag-certificacao-microsoft-sql-server-2012","tag-certificacao-sql","tag-certificacao-sql-2012","tag-certificacao","tag-certificacao-sql-server-2012","tag-certificacoes-sql","tag-certificacoes-sql-server","tag-curso-certificacao-microsoft","tag-designing-database-solutions-for-microsoft-sql-server-2012","tag-developing-microsoft-sql-server-2012-databases","tag-exam-70-450","tag-exam-70-461","tag-exame-70-461","tag-installation-and-maintenance","tag-kit-para-certificacao-sql","tag-livro-kit-de-treinamento-mcsa-exame-70-461","tag-material-de-certificacao-sql-2012","tag-mcsa-2012","tag-mcsa-70-461","tag-mcsa-sql-server-2012","tag-mcse-sql-server","tag-microsoft-certificacoes","tag-microsoft-sql-server-2008","tag-part-1","tag-part-2","tag-prova-certificacao-microsoft","tag-querying-microsoft-sql-server-2012","tag-simulado-70-461","tag-simulado-certificacao-microsoft","tag-sql-server","tag-sql-server-2012-2","tag-transition-your-mcitp-database-administrator-2008-or-mcitp-database-developer-2008-to-mcse-data-platform","tag-transition-your-mcts-on-sql-server-2008-to-mcsa-sql-server-2012"],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts\/2400","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/comments?post=2400"}],"version-history":[{"count":1,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts\/2400\/revisions"}],"predecessor-version":[{"id":9331,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/posts\/2400\/revisions\/9331"}],"wp:attachment":[{"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/media?parent=2400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/categories?post=2400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fabriciolima.net\/blog\/wp-json\/wp\/v2\/tags?post=2400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}