Search Adaface test library by skills or roles
⌘ K

PHP, Drupal & SQL Online Test

The PHP, Drupal & SQL Test is preferred by recruiters to assess on-the-job skills of candidates before an interview. It reduces technical screening time by 80% by enabling employers to identify qualified candidates.

Covered Skills:

  • Syntax
  • Operators
  • Loops
  • Variables
  • Bug Fixing
  • Functions
  • Object-Oriented Programming (OOPs)
  • Classes and Objects
  • Inheritance and Polymorhism
  • Globals and scope
  • Security
  • See full list

Adaface PHP, Drupal & SQL Test is trusted by enterprises worldwide

Amazon Morgan Stanley Vodafone United Nations HCL PayPal Bosch WeWork Optimum Solutions Deloitte Microsoft NCS Doubtnut Sokrati J&T Express Capegemini

Sample PHP, Drupal and SQL Online Test Questions

These are just a small sample from our library of 10,000+ questions. The actual questions on this PHP, Drupal & SQL Test will be non-googleable.

🧐 Question🔧 Skill💪 Difficulty⌛ Time
Multi Select
Consider the following SQL table:
 image
How many rows does the following SQL query return?
 image

Options:

  • 0
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
SQLMedium2 min
Netflix Fav Movie
We are building a Netflix clone where users can stream movies. Our service tracks and logs usage for each user. Each log contains the name of the movie, length of the movie (in minutes) and number of minutes of the movie watched by the user. Can you help with some data analysis?
Our code needs to return the Favorite movie: the name of the movie with the highest percentage of movie watched by the user. If a user watched 30mins out of 60mins for movie1 (50%) and 75min out of 100min of movie2 (75%), the movie with the highest percentage of movie watched by the user is movie2 (Assume that the values are such that there can never be a tie for this spot).
    CodingMedium40 min
    Array Replace
    What will the following PHP code output?
    
     image
    // OPTION ONE
    Array
    (
    [0] => basappa
    [1] => sarvepalli
    [2] => zakir
    [3] => venkata
    [4] => fakhruddin
    )

    // OPTION TWO
    Array
    (
    [0] => hidayatullah
    [1] => sarvepalli
    [2] => zakir
    [3] => venkata
    [4] => fakhruddin
    )

    // OPTION THREE
    Array
    (
    [0] => fakhruddin
    [1] => sarvepalli
    [2] => zakir
    [3] => venkata
    [4] => hidayatullah
    )

    // OPTION FOUR
    Array
    (
    [0] => basappa
    [1] => sarvepalli
    [2] => zakir
    [3] => venkata
    )

    Options:

    • OPTION ONE
    • OPTION TWO
    • OPTION THREE
    • OPTION FOUR
    Arrays
    PHPEasy2 min
    Alter and Change
    What does the following code output?
    
     image

    Options:

    • 6 6
    • 6 4
    • 6 2
    • 4 4
    • 2 2
    • 4 2
    • 4 6
    • 2 4
    • 2 6
    OOPs
    PHPMedium2 min
    Exceptions
    What does the following code output?
    
     image

    Options:

    • ONE1A
    • TWO2B
    • THREE3C
    • ONE2C
    • ONE2B
    • 1A
    • 2B
    • 2A
    • 3B
    • ONEB
    • 1B
    • 3A
    • TWOC
    Exception
    PHPMedium2 min
    PDO MySQL
    Consider the following table data and PHP code. What is the result?
     image

    Options:

    • The database will return no rows
    • $row will be an array
    • $result will be empty
    • $result will be '[email protected]'
    Database Connection
    PHPMedium2 min
    Select & IN
    Consider the following SQL table:
    
     image
    Which of the following SQL queries would return the year when neither a football or cricket winner was chosen?
    
     image

    Options:

    • A
    • B
    • C
    • D
    • E
    SQLEasy3 min
    With, AVG & SUM
    Consider the following SQL table:
    
     image
    How many tuples does the following query return?
    
     image

    Options:

    • 1
    • 2
    • 3
    • 4
    • 5
    • 6
    • 7
    SQLMedium2 min

    How to use the Adaface PHP, Drupal and SQL Online Test

    Start screening candidates within minutes with the ready-to-go PHP, Drupal & SQL Test

    1. Choose the most appropriate test for your role

    2. Start inviting candidates to complete the assessment

    3. Receive real time notifications and shortlist the best candidates

    OR Customize the Adaface PHP, Drupal & SQL Test according to your job description

    1. Get a custom assessment from our library of 500+ skills within 48 hours

    2. Start inviting candidates to complete the assesment

    3. Receive real time notifications and shortlist the best candidates

    About the Adaface PHP, Drupal and SQL Assessment Test

    Topics:

    Syntax
    Operators
    Loops
    Variables
    Bug Fixing
    Functions
    Object-Oriented Programming (OOPs)
    Classes and Objects
    Inheritance and Polymorhism
    Globals and scope
    Security
    Session
    Stings
    Arrays
    Sessions
    Streams
    Sorting
    Iteration
    Exceptions
    XML/JSON
    Functional Programming
    Node images
    Drupal Content type
    User information
    Drupal composer
    Library hook
    Namespace
    ALTER
    UPDATE
    Diff And Patch

    Drupal Cron is used to execute the commands or scripts automatically at a particular date and time intervals.

    Drupal Cron
    Scalability
    Drupal cache
    Drupal Panels
    Views module
    Ctools
    preprocessor
    subtheme
    contextual filter
    entity api
    Comment Moderation
    Modules
    Database abstraction layer
    SEO-friendly URL

    Breadcrumb trail is a navigation aid used in drupal interfaces.

    Breadcrumbs
    Singleton Design pattern
    PHP Data Objects

    Hooks allow modules to alter and extend the behavior of Drupal core, or another module.

    Hooks

    In Drupal, render arrays provide a structured way to programmatically change the content before it is displayed.

    Render array
    Block Caching
    Page Caching
    The Relational Model
    SQL Basics
    SQL Functions
    Data Modification Language
    Data Query Language
    CRUD
    SQL Filtering / WHERE Statement
    Subqueries
    Indexes
    3 Valued Logic
    SQL JOINS
    Window Functions
    Date Filtering and Timestamps
    Aggregate Functions
    Operator Precedence
    ORDER BY
    GROUP BY
    Top-Down Design
    Bottom-Up Design
    Entity Relationship Diagram
    Normalization
    Database Types
    Multi-Table SELECT
    Permission Management
    Backup Strategies
    Transactions
    Data Types
    Views
    Sharding
    Replication
    Backups
    Vertical + Horizontal Scaling
    Distributed vs Centralized Databases
    Database Security
    SQL Injections
    Access Control

    Recommended Roles:

    Drupal Developer
    Full Stack Developer

    How is this PHP, Drupal & SQL Online Test customized?

    1
    2
    3

    FAQs

    What is a custom assessment?

    Every role is different and requires a custom assessment to identify top candidates efficiently. Adaface subject matter experts understand your job description/ role requirements and pick the most relevant questions from our library of 10000+ questions to create a technical assessment that helps you find the qualified candidates in your candidate pipeline quickly. All custom assessments are set up based on the job description, role requirements, must-have skills, experience level and salary range within a maximum of 48 hours and you will get an email notification once it goes live.

    Check out a sample assessment here (no credit card required).

    Can I combine multiple skills into one custom assessment?

    Yes, absolutely. Custom assessments are set up based on your job description, and will include questions on all must-have skills you specify.

    How is Adaface different from other assessment tools?

    We believe that status quo tech assessment platforms are not a fair way for companies to evaluate engineers because they focus on trick questions/ puzzles/ niche algorithms. We started Adaface to help companies find great engineers by assessing on-the-job skills required for a role. Read more about why we started Adaface.

    Here's what's different with Adaface:

    • High quality non-googleable questions that test for on-the-job skills as opposed to theoretical knowledge.
    • A friendly conversational assessment with a chatbot, instead of sending a "test" to a candidate. This translates to a higher completion rate. Adaface assessments (86% candidate completion rate), as opposed to traditional tests (40-50% candidate completion rate)
    • Customized assessments for 700+ skills at different experience levels.

    Do you have any anti-cheating or proctoring features in place?

    We have the following anti-cheating features in place:

    • Web proctoring
    • Webcam proctoring
    • Plagairism detection
    • Non-googleable questions
    • Secure browser

    Read more about the proctoring features.

    How do I interpret test scores?

    The primary thing to keep in mind is that an assessment is an elimination tool, not a selection tool. A skills assessment is optimized to help you eliminate candidates who are not technically qualified for the role, it is not optimized to help you find the best candidate for the role. So the ideal way to use an assessment is to decide a threshold score (typically 55%, we help you benchmark) and invite all candidates who score above the threshold for the next rounds of interview.

    What experience level can I use this test for?

    Each Adaface assessment is customized to your job description/ ideal candidate persona (our subject matter experts will pick the right questions for your assessment from our library of 10000+ questions). This assessment can be customized for any experience level.

    Does every candidate get the same questions?

    Yes, it makes it much easier for you to compare candidates. Options for MCQ questions and the order of questions are randomized. We have anti-cheating/ proctoring features in place. In our enterprise plan, we also have the option to create multiple versions of the same assessment with questions of similar difficulty levels.

    I'm a candidate. Can I try a practice test?

    No. Unfortunately, we do not support practice tests at the moment. However, you can use our sample questions for practice.

    What is the cost of using this test?

    You can check out our pricing plans.

    Can I get a free trial?

    The platform is completely self-serve, so here's one way to proceed:

    • You can sign up for free to get a feel for how it works.
    • The free trial includes one sample assessment (Java/ JavaScript) that you will find in your dashboard when you sign up. You can use it to review the quality of questions, and the candidate experience of a conversational test on Adaface.
    • To review the quality of questions, you can also review our public questions for 50+ skills here.
    • Once you're convinced that you want to try it out with real assessments and candidates, you can pick a plan according to your requirements.

    I just moved to a paid plan. How can I request a custom assessment?

    Here is a quick guide on how to request a custom assessment on Adaface.

    Singapore government logo

    The hiring managers felt that through the technical questions that they asked during the panel interviews, they were able to tell which candidates had better scores, and differentiated with those who did not score as well. They are highly satisfied with the quality of candidates shortlisted with the Adaface screening.


    Human Resources Manager

    Singapore Government

    85%
    reduction in screening time

    How Adaface Is Different

    Adaface conversational assessments are reflective of on-the-job skills and see an 86% completion rate as compared to ~50% for traditional assessment platforms.

    OLD WAY

    TRADITIONAL TESTS

    Theoretical questions/ puzzles

    Feels like a test

    One-size-fits-all assessments

    😞
    HIRE IN
    Weeks/Months

    NEW WAY

    ADAFACE ASSESSMENTS

    Questions for on-the-job skills

    Conversational

    Customized
    assessments

    😀️
    HIRE IN
    Days

    With Adaface, we were able to optimise our initial screening process by upwards of 75%, freeing up precious time for both hiring managers and our talent acquisition team alike!


    Brandon Lee, Head of People, Love, Bonito

    hashtag image heart icon Brandon
    Join 1200+ companies in 75+ countries.
    Try the most candidate friendly skills assessment tool today.
    Have any questions about the Adaface PHP, Drupal & SQL Test?
    Have any questions about the Adaface PHP, Drupal & SQL Test?
    Chat with us ✨
    Terms Privacy Trust Guide