Database Administration Flashcards
Which modules can you use to create a new table?
Tables
Tables and Colums
What is created by default when you create a new table?
Application Menu with the same name as the table Label (e.g. Infinity)
Module with the plural of the table label (e.g. Infinities)
How can you edit the title of an application menu?
Click the Edit Application (pencil) icon
Update the Title field on the form
A parent class that is not an extension of another table is called what?
Base table
What is specified in an access control list rule?
Object and Operation being secured
Permissions required to access the object
What types of permissions can be configured in an access control rule?
Roles, Conditions, Script that sets the answer variable to true or false
In what order are access controls evaluated?
Table-level: most specific to most general THEN
Field-level: most specific to most general
Which object grants access to all table records?
.–none–
Which elevated role is required to modify access control rules?
security_admin
Which module is used as the first step for importing data?
Load Data
What are the steps for importing data using an import set?
Load the data
Create a transform map
Transform the data
Clean up the import table
Which option allows you to update existing target table records when importing data from an import set?
Coalesce
Which tool is used to determine relationships between fields in an import set and an existing table?
Transform map
What is defined as a series of tables containing assets and services controlled by a company?
Configuration Management Database (CMDB)
What is a CI?
Configuration Item
Can be tangible (hardware, software, servers, etc) or intangible (services, email, etc.)