Curious about Actual GAQM Certified Information Technology Manager (CITM-001) Exam Questions?

Here are sample GAQM Certified Information Technology Manager (CITM-001) Exam questions from real exam. You can get more GAQM Certified Information Technology Manager (CITM-001) Exam premium practice questions at TestInsights.

Page: 1 /
Total 80 questions
Question 1

__________ level describes what data is stored in the database and the relationships among the data


Correct : C

The conceptual level is a high-level description of the data and its relationships in the database, without specifying how the data is physically stored or implemented. It defines the main entities, attributes, and constraints for the entire database, and is independent of any specific database management system or application. The conceptual level is also known as the logical level, and it is usually represented by an entity-relationship diagram (ERD).Reference:Conceptual schema - Wikipedia,Navigating the Three Levels of Database Design: Conceptual, Logical, and Physical


Options Selected by Other Users:
Mark Question:

Start a Discussions

Submit Your Answer:
0 / 1500
Question 2

A ________ is an association between entities.


Correct : A

A relation is a type of association that describes how two or more entities are related to each other. A relation can have different properties, such as cardinality, optionality, and directionality, that specify the nature and constraints of the association. A relation can also have attributes that store information about the association. For example, a relation between Employee and Project entities can have an attribute called Role that indicates the role of each employee in each project. A relation can be represented by a line connecting the entities in an entity-relationship diagram (ERD).Reference:Association and Associative entity - IBM,When to use Associative entities? - Stack Overflow, [Entity-Relationship Model - Tutorialspoint].


Options Selected by Other Users:
Mark Question:

Start a Discussions

Submit Your Answer:
0 / 1500
Question 3

Which key uniquely defines the characteristics of each row?


Correct : A

A primary key is a column or combination of columns that contain values that uniquely identify each row in the table. It enforces the entity integrity of the table and prevents the insertion of duplicate rows. A table can have only one primary key, which is usually defined on an identity column or a column with not null and unique constraints.A primary key also creates a unique index for the table, which allows fast access to data when the primary key is used in queries12.Reference:1: Primary and Foreign Key Constraints - SQL Server12: Primary and Foreign Key in SQL With Examples - DataFlair2


Options Selected by Other Users:
Mark Question:

Start a Discussions

Submit Your Answer:
0 / 1500
Question 4

Which key is used to create a link and relationship between tables in a relational database?


Correct : C

A foreign key is a column or a set of columns in one table that references the primary key of another table. It is used to create a link and relationship between tables in a relational database.A foreign key ensures that the values in the referencing table match the values in the referenced table, thus maintaining the referential integrity of the database12.A foreign key can also be used to implement constraints such as cascading updates or deletes3.Reference:1: CITM Study Guide, Chapter 3: Database Management Systems, Page 41.2:Types of Keys in Relational Model (Candidate, Super, Primary, Alternate and Foreign)3:Database Keys: The Complete Guide (Surrogate, Natural, Composite & More)


Options Selected by Other Users:
Mark Question:

Start a Discussions

Submit Your Answer:
0 / 1500
Question 5

_____________ occurs because the data we want may not be directly under the read-write heads.


Correct : B

Rotational delay is the time it takes for the desired sector of the disk to rotate under the read-write head after the head has been positioned at the correct track. It depends on the rotational speed of the disk and the position of the sector relative to the head. It is one of the components of data access delay, along with seek time, transmission delay, and processing delay.Reference:Delays in Computer Network - GeeksforGeeks,Access time - Wikipedia


Options Selected by Other Users:
Mark Question:

Start a Discussions

Submit Your Answer:
0 / 1500
Page:    1 / 16   
Total 80 questions