Database Administration Questions

Understand the ServiceNow data model, tables, fields, and the data dictionary. Learn to extend tables and manage data effectively.

24 total questionsAll questions free

Last reviewed:

About Database Administration

ServiceNow uses a relational database with a unique inheritance model. Understanding tables, fields, and the data dictionary is crucial for customizing and extending the platform. This knowledge helps you make informed decisions about data structure and system performance.

Why This Matters for Your Exam

Database Administration covers about 12% of the CSA exam. Questions test your knowledge of table relationships, field types, and data management. You'll need to understand when to extend versus create new tables and how to use import sets for data loading.

Key Concepts to Master

Know the difference between base tables and extended tables. Understand reference fields and how they create relationships between tables. Be familiar with the data dictionary and how to view table schemas. Learn about import sets, transform maps, and data policies.

Exam Tips

Focus on table inheritance - know that task is a base table extended by incident, problem, and change_request. Understand that fields inherited from parent tables appear on all child tables. Know which field types are appropriate for different data scenarios.

Practice Questions

24 questions available
All CSA questions are free(24 questions, no login needed)
1
knowledge

How is data organized in ServiceNow?

AFiles, folders, and documents
BTables, records, fields, and values
CSheets, cells, and formulas
DObjects, classes, and methods

πŸ‘† Click an option above to select your answer

2
knowledge

What is a sys_id in ServiceNow?

AA user's login name
BA unique 32-character ID that identifies each record
CThe table name
DA field label

πŸ‘† Click an option above to select your answer

3
understanding

What does a reference field store in ServiceNow?

AThe full content of the referenced record
BThe unique sys_id of a record from another table
CA copy of the referenced table
DThe URL of an external system

πŸ‘† Click an option above to select your answer

4
understanding

What happens when a table extends another table in ServiceNow?

AThe parent table is deleted
BThe child table inherits all fields from its parent table along with its unique fields
CBoth tables become identical
DThe parent table can no longer be used

πŸ‘† Click an option above to select your answer

5
knowledge

Which of the following are examples of tables that extend the Task table?

AUser and Group
BIncident, Problem, and Change Request
CLocation and Department
DKnowledge and Article

πŸ‘† Click an option above to select your answer

6
knowledge

What is a base table in ServiceNow?

AA table that has been deleted
BA table that serves as a foundation for other tables but isn't an extension itself
CA temporary table for testing
DA table that cannot have child tables

πŸ‘† Click an option above to select your answer

7
understanding

What is the purpose of a Schema Map in ServiceNow?

ATo display user permissions
BTo visualize table relationships
CTo track system performance
DTo manage email notifications

πŸ‘† Click an option above to select your answer

8
understanding

What is the difference between a field name and a field label?

AThey are always identical
BField names are unique and may differ from labels, which are display names
CField labels are used in scripts; field names are for display
DThere is no difference

πŸ‘† Click an option above to select your answer

9
knowledge

What type of field allows selecting multiple records from a table?

AReference field
BChoice field
CGlideList field
DString field

πŸ‘† Click an option above to select your answer

10
understanding

What is the difference between scoped apps and global apps?

AScoped apps are free; global apps require licensing
BScoped apps are sandboxed with restricted API; global apps have access to all parts of the system
CGlobal apps are more secure than scoped apps
DThere is no difference

πŸ‘† Click an option above to select your answer

11
applicationSelect all that apply

In the schema map, what do tables with blue bars indicate? (Choose two)

ATables that extend the focused table
BTables that are referenced by the focused table
CChild tables of the focused table
DDeleted tables

πŸ‘† Click an option above to select your answer

12
knowledge

What is a Document ID field used for?

ATo store document attachments
BTo reference one record from any table
CTo create PDF exports
DTo store version history

πŸ‘† Click an option above to select your answer

13
knowledge

What is the unique identifier for every record in ServiceNow?

AA record number (e.g., INC0010001)
BA 32-character sys_id
CA combination of table name and row number
DAn auto-generated UUID

πŸ‘† Click an option above to select your answer

14
comprehension

What is the difference between a base table and a core table in ServiceNow?

AA base table is always a core table, but a core table is not always a base table
BA base table serves as a foundation for extensions and is not itself an extension, while a core table comes with ServiceNow from the start
CBase tables cannot have child tables, while core tables can
DThere is no difference; the terms are interchangeable

πŸ‘† Click an option above to select your answer

15
knowledgeSelect all that apply

Which of the following are types of field relationships in ServiceNow? (Choose 2)

AOne-to-many (Reference field)
BMany-to-many
COne-to-one-to-many
DCircular reference

πŸ‘† Click an option above to select your answer

16
application

What is the purpose of coalescing during a data import in ServiceNow?

ATo merge multiple import set tables into one
BTo prevent duplicate records by using fields as unique keys
CTo convert data types during transformation
DTo automatically map fields between source and target tables

πŸ‘† Click an option above to select your answer

17
knowledge

What do update sets capture in ServiceNow?

ABoth configuration changes and data records like incidents
BOnly data records created during the update set period
CConfiguration and customization changes, but NOT data records
DOnly changes made by administrators with elevated privileges

πŸ‘† Click an option above to select your answer

18
comprehension

What is the difference between global scope and application scope in ServiceNow?

AGlobal scope is for production only; application scope is for development
BGlobal scope has access to all parts of the system; scoped apps are sandboxed with restricted API access
CApplication scope provides more permissions than global scope
DThere is no functional difference between the two

πŸ‘† Click an option above to select your answer

19
application

An administrator needs to import 5,000 user records from a CSV file. After the import, several records have incorrect department values. Which step in the import process most likely caused this issue?

AThe Transform Map field mapping for Department used an incorrect coalesce field
BThe CSV file was too large to process
CThe import set table was not created
DThe user running the import lacked the admin role

πŸ‘† Click an option above to select your answer

20
knowledge

Which two field types in ServiceNow store references to records in other tables? (Choose 2)

AReference field
BGlide List field
CString field
DInteger field

πŸ‘† Click an option above to select your answer

21
understanding

What is the purpose of a 'coalesce' field in a Transform Map?

AIt determines whether to update an existing record or insert a new one during import
BIt combines multiple source columns into one target field
CIt encrypts sensitive data during import
DIt validates data format before insertion

πŸ‘† Click an option above to select your answer

22
application

An administrator wants to create a field that automatically calculates the number of days between the Opened date and the Resolved date on an incident. Which field type is most appropriate?

ADuration field with a calculated default value
BInteger field with a Business Rule to calculate the value
CFormula field that references the two date fields
DString field with a UI Policy to display the calculation

πŸ‘† Click an option above to select your answer

23
knowledge

What is the maximum number of rows that can be displayed in a single list view by default in ServiceNow?

A20
B100
C500
DUnlimited

πŸ‘† Click an option above to select your answer

24
understanding

Which statement about table inheritance in ServiceNow is correct?

AChild tables inherit all fields and business logic from their parent table
BChild tables share the same physical database table but cannot have additional fields
CParent table records are automatically duplicated in child tables
DTable inheritance only works with the Task table

πŸ‘† Click an option above to select your answer

CSA is free. Next step: CAD or a CIS exam.

That's every CSA question. When you're ready for the next certification, each one is $9 for lifetime access, or get all 19 paid certifications for $49 (CSA stays free).

Try CAD free questionsBrowse CIS exams