Find Jobs
Hire Freelancers

SQL Query Assessment Creation

$25-50 USD / hour

Fechado
Publicado há mais de 4 anos

$25-50 USD / hour

Looking for a subject matter expert to create assessment questions for SQL(Generic) Experience Level- Intermediate (3-6 years) Total Question: 50 ( 25 MCQs + 25 MSQs). About 50 questions with answer keys to be created. 1. 25 MSQs select questions (MSQs) where the question will have one or more than one correct option. Each question should have at least 5 choices. 2. 25 MCQs where the question will have one option .Each question should have at least 5 choices. Please follow these guidelines: 1. All the questions should be query based. 2. Questions should be PLAGIARISM FREE (Not copied from google or any other sites). Upon receipt of the questions we will carry out plagiarism checks for all the questions. If any of the questions is found to be plagiarized / available anywhere online then the complete assignment/contract will be cancelled. 3. Each question should have at least 5(Five) Answer choices. 3.1 Please don't use "None of the Above" 3.2 Please don’t use "All of the Above" 4. Question and Answer choices should be free from errors (Grammar, Punctuation, Spellings etc), clear to understand and should contain no ambiguity. We recommend using tools like “Grammarly” to check the correctness of the sentences. 5. Avoid excessive window dressing (should not contain irrelevant and unwanted information in Question or Answer Choices). 6. There should be 1 correct answer and 4 plausible distractors (incorrect answer) for Multiple Choice Questions(MCQs) and there should 1 or more than one correct answer for Multiple Selection Questions (MSQs). 7. Once the questions created by you are shared with us, Glider will become the absolute owner of the questions and these questions should not be reproduced or recreated in any form to any other client. 8. All the Key topics pertaining to the skill should be covered while creating the questions. 9. Please update the below details for all the questions. 9.1 In Tags- Topic and Subtopic. The first letter of the Tag should be Capital. If the tag is available in the Pre-populated list please select from that list. 9.2 In Author Tags- Add your name. 9.3 In Solution- Please add the explanation for the correctness of the question . 9.4 Shuffle answer choice should be enabled for all the questions. 9.5 For MSQs question please add this instruction "Select all that apply below". 10. Difficulty Level and Time has been mentioned below. Please add it accordingly for each questions. Choose suitable difficulty level according to the question you create and add suitable time taken to answer the question. 11. Post receipt of the questions following would be the process: 1. Plagiarism Check. 2. Questions sent to 2 external SMEs(Subject Matter Experts) who would attempt the questions as candidates and will share the feedback on the questions. 3. The feedback received will be shared with you for addressing those concerns. You will have to review the feedback and make changes to the questions accordingly. If you feel that the content shared by you is correct and the changes suggested by the Reviewers are not correct, you can let us know. We will arrange for communication between you and the reviewer. 4. Once the questions are deemed fit in all aspects, the payment will be immediately released. 12. To start with, please share 1 sample questions following way: MCQ/MSQ - 1question This is to check content and quality. These questions can be included further in the actual assignment once approved. Please create a question as per the guideline mentioned in the job post and provide your timeline to share sample question. The bidders without sample questions will not get attention.
ID do Projeto: 23036834

Sobre o projeto

22 propostas
Projeto remoto
Ativo há 4 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
22 freelancers estão ofertando em média $38 USD/hora for esse trabalho
Avatar do Usuário
Hello, We are IT-Engineers and Business Analysts, creating complete web and mobile solutions, for already more than 15 years, supporting our products with custom digital marketing strategies and instruments. Before the collaboration starts - the initial briefing round takes place, which is free of charge. We are interested in all the details of your specific case. They will allow us to obtain a better vision of your concept and help us create unique solutions for you. Let's schedule a convenient time for the first kick-off conversation. Best Regards, Andrei Costenco Team Lead, Business Analyst, Senior Engineer Dev Experts Team
$50 USD em 30 dias
5,0 (73 avaliações)
8,0
8,0
Avatar do Usuário
I am certified Sql developer. I have more than 10 years of experience. I can provide you better solution by utilizing my knowledge and skills.
$30 USD em 10 dias
4,9 (28 avaliações)
4,8
4,8
Avatar do Usuário
Hi, I specialize in website design and development and am excited for this opportunity to work with you in accomplishing your goals.. I am Good at Database Administration, Database Development, MySQL, Oracle, SQL.. Please Send me a message so that we can discuss more about this project Regards, Barry
$40 USD em 17 dias
5,0 (48 avaliações)
4,6
4,6
Avatar do Usuário
Greetings, I'm professional database and BI expert with 12+ years experience. Currently I'm working as Senior DW, BI & DB developer in one of the leader financial corporation. As you can see in my profile page, I have a deep experience of database related projects. I'm top expert. -- Best regards, Davit Dartsimelia Senior BI & SQL Developer
$55 USD em 5 dias
5,0 (3 avaliações)
4,2
4,2
Avatar do Usuário
HI There ! We read your job post and most interested in your job cause we have expert web developer team in our company and able to provide you exact you want. Let's discuss more ahead and can start soon. Thanks!
$25 USD em 40 dias
4,4 (3 avaliações)
3,9
3,9
Avatar do Usuário
Hi, I am a professional SQL developer based in the UK. I can assist you with your project. Please let me know if you require my assistance. Kind regards, Tom.
$25 USD em 40 dias
5,0 (1 avaliação)
0,8
0,8
Avatar do Usuário
I'm an ETL expert with strong SQL skills, I have close to 13 years of experience in data warehousing concepts, I have experience in oracle, sql server, teradata, netezza
$33 USD em 10 dias
5,0 (1 avaliação)
0,7
0,7
Avatar do Usuário
★ Dear, Employer ★ Thanks for the wonderful opportunity!! ✔ I have checked your requirement very carefully. ✔ This is very suitable for me because I have already relevant skills and experiences of fixing issues. ✔ Specially, I have good developing experiences for 7 years with Oracle and MySQL ========================================= Although I have poor reviews, I can satisfy you more perfectly than others. Please, give me a chance for working with you. Best Regards.
$25 USD em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Dear Client!! Greetings for the day!! Proficient with :- SQL, Oracle, MySQL , Database Administration,Python , .NET , C# programming , Java ,JavaScript , Available for an immediate start!!! I have gone through your requirement very precisely & I'm confident that my involvement in your project will bring it to a successful launch, on time and within budget. I am a full stack developer with 25+ years of distinguished career in designing, programming, deployment , support & mentoring of cutting-edge technology solutions .My Years of real world experiance makes me maestro of it!! A glance at my skill sets:- FRONT -END - HTML, HTML5, JSON. - JAVASCRIPT (Ajax, AngularJS / 2 / 4 / 5 / 6 / 7 / 8, ReactJS - Redux, Jquery),ASP.Net. - CSS, CSS3, Twitter Bootstrap, Less, Sass, Scss, Responsive, Material. - Mobile apps: React Native,Ionic, Swift, ObjectiveC. BACKEND - SKILLS:- - Python (Django), ROR, Node.js, C#. - MVC, OOP, CURL, MongoDB, Postgres, MySQL, Rest APIs. Other skills:- - Git, Heroku, SVN, Bitbucket, HG, Linux, Mac - Vagrant, VirtualBox, Gulp, Grunt - AMZ S3, AWS EC2 To discuss this further , kindly suggest if we could schedule a call/chat. For any clarifications / trials I'm am available. Lets Connect!!! Best Regards Chiranjeeb
$50 USD em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello. At work I am interviewing DataBase specialists at hiring. I ask all sorts of questions on their knowledge, therefore, I am familiar with this problem, I will gladly do your interesting task. "1 sample questions, PLAGIARISM FREE", invented myself. MCQ 1) What important changes have appeared with temporary tables in Oracle12, which made them much faster. one correct answer + 4 incorrect MSQ 1) Select all oracle collection types. three correct answers + two incorrect About myself: SQL / Oracle 15 years of experience. Architect of information systems and databases, performance analyst. Development and refactoring of SQL code. Optimization of sql queries or locks. Oracle Performance Diagnosis with AWR On this site recently, but the Ora-practice is huge. З.Ы. Еще конечно говорю по-русски, если поможет в общении.
$25 USD em 30 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I have good experience in working on SQL server. can understand and build complex queries. Will be able to help you in updating and understanding the queries.
$33 USD em 30 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I have exprience in sql. • Good working knowledge on Tables, Constraints, Views, Materialized Views, Synonyms and Sequences. • Extensive knowledge in using Joins, Set Operators, Sub Queries, Inline Views, Analytical Functions. • Developed database objects like Procedures, Functions, Packages. • Good knowledge in using Cursors, Collections, UTL File Package. • Worked on Exception Handling Techniques to handle the runtime errors. • Knowledge about Ref Cursor, Bulk Collect and Bulk Binding.
$25 USD em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello, I hope you are fine and doing good. I am very much interested in doing this questionnaire part as it is very much related to my skills and expertise in this domain. I am Oracle SQL certified and I can do this task within 1 week for you or if required, I can do it earlier. Sample Question # 1 We all know union function helps us to combine two or more datasets in a query. What is the most relevant answer for difference between UNION and UNION ALL w.r.t to performance? 1- There is no difference wrt to performance impact 2- UNION ALL will impact I/O operations 3- UNION is faster because doest not sort the values 4 -UNION need more I/O resources 5- UNION ALL impact performance as it results in all data (including duplicate rows). Correct Answer (5) Sample Question #2 Please select the best advantage of cursor use in SQL. 1- It used less amount of memory resources in data retrieval. 2- Cursor will lock all the tables used in the query. 3- You can use them as a subquery alternative for row-by-row processing operations. 4- In comparison with a while loop, cursors are much faster. Correct Answer (4)
$35 USD em 24 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I'm an experienced freelancer database and report design, development and optimization with 10 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing DB design. I am currently in Texas, US Here is few technologies I have mastered since last 10 years and can deliver the best solutions if you get me hired. 1) Sql Server 2005/2008/2012 2) MYSQL, MS Access 3) Oracle (PL/SQL) 4) SSIS, SSRS , SSAS and Power BI 5) Data analytics using R-Programming and SAS
$38 USD em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Добрый день. Меня зовут Виталий, я программист из Украины, Киев. Работаю на оутсорсинге, эксперт в области реляционных баз данных, миграции данных между серверами. Хорошо знаю английский язык. Меня заинтересовало Ваше задание, и я хотел бы узнать подробности. Для реализации проекта Вам нужен лишь программный код, или необходимо также написать документацию? Наличие документации (хотя бы в минимальном объёме) позволяет быстрее и точнее решить поставленные задачи. Предлагаю обсудить в чате детали заданий. Он доступен на вебсайте freelancer.Также доступен по телеграм, вайбер, скайп. В связи с праздниками буду офлайн два дня, до второго января. С уважением, Виталий Best regards, Vitaly
$27 USD em 40 dias
0,0 (1 avaliação)
1,3
1,3

Sobre o cliente

Bandeira do(a) UKRAINE
Ukraine
0,0
0
Membro desde dez. 24, 2019

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.