In a relational table, a single row represents what?
Select an option, then click Submit answer.
- ○ One record, such as one customer or one order
- ○ One column definition
- ○ The whole database
- ○ A stored procedure
Loading demo links...
Showing 1–10 of 10 questions
In a relational table, a single row represents what?
Select an option, then click Submit answer.
Which property must a primary key have?
Select an option, then click Submit answer.
A primary key made up of two or more columns together is called what?
Select an option, then click Submit answer.
Which TWO are considerations when choosing data types for a table? (Choose two.)
Select all that apply, then click Submit answer.
A foreign key is used to do what?
Select an option, then click Submit answer.
Referential integrity ensures that what?
Select an option, then click Submit answer.
Normalizing a database to third normal form (3NF) aims to do what?
Select an option, then click Submit answer.
Which TWO elements does an entity-relationship diagram (ERD) show during design? (Choose two.)
Select all that apply, then click Submit answer.
Which data protection measure restores data after loss or corruption?
Select an option, then click Submit answer.
The principle of least privilege in database access means what?
Select an option, then click Submit answer.
This page holds a free practice test for the Information Technology Specialist Databases certification from Certiport. You will find 10 free questions, drawn from the full Study4Pass practice set of 80 questions for this exam. The questions follow the official Certiport objective domains: Database Design; Database Object Management using DDL; Data Retrieval; Data Manipulation using DML; Troubleshooting.
Pick an answer for each question and check it straight away — the correct answer and a full explanation appear under the question. There is no time limit and nothing to sign up for. When an explanation is not enough, use Ask AI: this is an AI-Enabled practice test, and Ask AI explains the concept behind the question in plain language. Ready for more? The full 80-question set adds a timed Exam Simulation mode, topic training for your weak areas, and a flagged-question review.
Covers designing tables for storing data (entities, rows, columns), identifying appropriate primary keys including composite keys, choosing data types, designing relationships between tables with ERDs and referential integrity, normalizing a database to 3NF, and identifying data protection measures.
Entities, rows/records, columns/fields; Primary and composite keys; Data types for text, numbers, dates and Booleans; Primary/foreign keys and ERDs; Referential integrity; Normalization to 3NF; Backups, least privilege, GRANT/REVOKE, roles, encryption, hashing, masking, auditing
Covers constructing and analysing queries that create, alter, and drop tables and views in ANSI SQL, constructing and analysing stored procedures and functions, and choosing between clustered and non-clustered indexes.
CREATE, ALTER and DROP TABLE; NULL and NOT NULL; CREATE, ALTER and DROP VIEW; Purpose of views; Stored procedure parameters and return values; Functions; Clustered vs non-clustered indexes; CREATE INDEX syntax
Covers constructing and analysing queries that select data (joins, UNION/INTERSECT, DISTINCT, aliases, computed columns), queries that sort and filter data (WHERE, LIKE, BETWEEN, IN, ORDER BY), and queries that aggregate data (GROUP BY, HAVING, aggregate functions).
INNER, LEFT, RIGHT, CROSS and FULL OUTER joins; Self joins; UNION and INTERSECT; DISTINCT; Column alias; CONCAT and NULLIF; ORDER BY, WHERE, LIKE, BETWEEN, AND/OR/NOT, TOP/LIMIT, IN; GROUP BY and HAVING; MIN, MAX, COUNT, AVG, SUM
Covers constructing and analysing INSERT statements (INSERT INTO VALUES and INSERT INTO SELECT), UPDATE statements, and DELETE statements against a single table.
INSERT INTO VALUES; INSERT INTO SELECT; UPDATE with and without WHERE; DELETE with and without WHERE; Predicting the effect of DML statements
Covers troubleshooting data object management query failures, data retrieval query failures, and data manipulation query failures, distinguishing syntax errors from runtime errors in each family of statements.
Syntax vs runtime errors; DDL failure diagnosis; SELECT failure diagnosis; DML failure diagnosis; Constraint and conversion failures
Yes — the 10 questions on this page are completely free, with no signup and no payment details needed.
80 questions. The 10 free questions above are a sample of that full set, in the same style and topic balance.
Yes — every question shows the correct answer with an explanation, and Ask AI can explain the concept behind a question in plain words if you want to go deeper.