alleryStart learning →Salesforce Developer SQL — practice questions
Explore 22 free SQL questions in Salesforce Developer Computer Science. Each question opens with answer choices, the correct answer and a worked solution.
Practise SQL with Quill →SQL MCQs with answers
Showing questions 1–22 of 22.
A system storing related data elements in row-based tables is called an:Read the answer and worked solution →The relational model of data was first proposed at IBM Research in 1970 by:Read the answer and worked solution →In that model, a relation is a mathematical concept based on the idea of:Read the answer and worked solution →A minimal group of attributes that uniquely identifies each row is a:Read the answer and worked solution →For a car table, the licence plate plus the state can serve as a:Read the answer and worked solution →The candidate key chosen as the unique identifier for each record becomes the:Read the answer and worked solution →A primary key exists to guarantee that every record in a table is:Read the answer and worked solution →The same piece of data held in two separate places in a database creates:Read the answer and worked solution →Changing the storage device without changing the conceptual design is possible due to physical data:Read the answer and worked solution →A DBMS organising data into a treelike model is described as:Read the answer and worked solution →A DBMS storing documents, graphs and key-value data is described as:Read the answer and worked solution →A rigid schema makes a relational system a poor fit for data that is:Read the answer and worked solution →A single logical unit of work that reads and may modify a database is a:Read the answer and worked solution →Properties ensuring stored data stay reliable and accurate are known by the acronym:Read the answer and worked solution →The declarative language used to manage and query a relational database is:Read the answer and worked solution →SQL implements sublanguages numbering:Read the answer and worked solution →The theory of operators on relations used to retrieve tuples is called relational:Read the answer and worked solution →Union, Intersection, Difference and Product are all classed as:Read the answer and worked solution →An operator returning tuples belonging to both relations is:Read the answer and worked solution →Because operand order matters, the Difference operator is described as:Read the answer and worked solution →An operator returning a subset of rows meeting a condition is:Read the answer and worked solution →Applying the Project operator to a relation returns a subset that is:Read the answer and worked solution →
How to practise
- Choose a SQL question and try to work out your answer.
- Open the question to check the correct answer and read its worked solution.
- Continue in the app for bite-sized lessons, explanations and review with Quill. You can start without creating an account.