Discuss ServiceNow CSA Exam Topic 3 Question 94

What is the master table that contains a record for each table in the database?

C[sys_master_object]

D[sys_object_db]

A[sys_master_db]

B[sys_db_object]

Suggested Answer: B

In ServiceNow, all tables in the database are recorded in a master table called [sys_db_object]. This table stores metadata about each table in the system, including its name, label, and other attributes.

Key Functions of [sys_db_object]:

Stores a record for every table in the ServiceNow instance.

Tracks essential table properties, such as the table name, label, and whether it is an extension of another table.

Helps administrators view, modify, or create new tables in ServiceNow.

Used in Table Administration and Custom Table Development.

Why the Other Options Are Incorrect?

A . [sys_master_db] --

This table does not exist in ServiceNow.

C . [sys_master_object] --

There is no such table named 'sys_master_object' in ServiceNow.

D . [sys_object_db] --

This table does not exist in ServiceNow.

The correct name is sys_db_object.

How to View the [sys_db_object] Table in ServiceNow?

Navigate to System Definition Tables.

Search for the table sys_db_object.

Open the table to see records representing all tables in the instance.

Reference from Certified System Administrator (CSA) Documentation:

ServiceNow Docs: Understanding Tables and Fields https://docs.servicenow.com/en-US/bundle/utah-platform-administration/page/administer/metadata/concept/c_TablesAndFields.html

ServiceNow CSA Official Training Guide (System Data and Tables Overview)

This confirms that [sys_db_object] is the master table that contains a record for every table in the ServiceNow database.

Get Premium CSA Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

26 comments · newest first

Kristeen 4 months ago

Exactly! It helps manage all tables in the database.

Keshia 4 months ago

I remember it being called the system catalog.

Kenia 4 months ago

Yeah, that makes sense! It holds metadata.

Halina 4 months ago

I think it's the information_schema.

Stephaine 6 months ago

I never knew it had a specific name! That's interesting!

Pamella 6 months ago

Yeah, but they serve similar purposes, right?

Oren 6 months ago

Wait, are you sure? I thought it was called the system catalog.

Elke 6 months ago

Totally agree, it's super useful for querying metadata!

Alida 6 months ago

It's called the information schema.

Brittni 6 months ago

The master table? Sounds like something from Harry Potter. I'll just guess and hope for the best.

Earnestine 7 months ago

Wait, is it the database_name.sys.tables? I'm never sure about the schema name.

Mollie 7 months ago

Hmm, I thought it was the sys.tables system view. Gotta double-check that.

Angelyn 7 months ago

Isn't it the information_schema.tables view? That's what I learned in class.

Helga 7 months ago

The system table, of course!

Augustine 7 months ago

I’m a bit confused; I thought it was called the catalog table, but I might be mixing it up with something else.

Annmarie 7 months ago

Isn't it something like the data dictionary? I feel like I saw that term in a practice exam.

Joseph 8 months ago

I remember practicing a question about database schemas, and I think it might be related to the information schema.

Apolonia 8 months ago

I think the master table is called the system catalog, but I'm not entirely sure if that's the right term.

Sharita 9 months ago

Ah yes, I remember learning about this in class. The master table is typically called the "system_tables" or something similar. I'll write that down and explain my reasoning in case I'm not 100% sure.

Leandro 9 months ago

Wait, what? I don't think I've ever heard of that "information_schema.tables" thing before. This question is throwing me off a bit. Maybe I'll just take a guess and hope for the best.

Shawn 9 months ago

Okay, I've got this. The master table that contains a record for each table in the database is usually called the "information_schema.tables" view. I'm pretty confident about that.

Ena 9 months ago

Ugh, I'm not totally sure about this one. I know there's some kind of system table that keeps track of all the tables, but I can't remember the exact name. Guess I'll have to think it through step-by-step.

Abel 9 months ago

Hmm, this seems like a pretty straightforward database question. I think I know the answer, but I'll double-check my notes just to be sure.

Bette 3 months ago

↳ replying to Abel

Don't forget about the catalog tables too!

Kristofer 3 months ago

↳ replying to Abel

Yeah, that's right! It holds metadata for all tables.

Micaela 3 months ago

↳ replying to Abel

I believe it's the information schema.

ServiceNow CSA Exam - Topic 3 Question 94 Discussion