CRT Database Management & SQL 1 — Questions and Answers
Question 1: In CRT practice, what is the purpose of version control in software development?
- To track changes, manage code history, and enable collaborative development (Correct answer)
- To control the number of software versions sold
- To limit who can access the internet
- To manage printer settings
Correct answer: To track changes, manage code history, and enable collaborative development
Version control systems track all changes to code over time, maintain a complete history of modifications, enable multiple developers to work simultaneously, and allow reverting to previous versions when issues arise.
Question 2: What does API stand for and what role does it play in CRT development?
- Application Programming Interface — it defines how software components communicate with each other (Correct answer)
- Advanced Processing Intelligence — it manages CPU operations
- Automatic Program Installation — it installs software
- Access Permission Index — it manages user permissions
Correct answer: Application Programming Interface — it defines how software components communicate with each other
An API (Application Programming Interface) defines the methods, data formats, and protocols that software components use to communicate. APIs enable integration between different systems and services.
Question 3: In CRT cybersecurity, what is the principle of least privilege?
- Users should only have the minimum access rights necessary to perform their job functions (Correct answer)
- All users should have administrator access
- Privileges should be assigned based on seniority
- Everyone should share the same login credentials
Correct answer: Users should only have the minimum access rights necessary to perform their job functions
The principle of least privilege limits each user's access rights to only what is strictly necessary for their role, reducing the potential damage from accidents, errors, or malicious actions by minimizing the attack surface.
Question 4: What is the purpose of encryption in CRT data security?
- To convert readable data into an unreadable format that can only be decoded with the proper key (Correct answer)
- To compress files for faster transmission
- To organize data in alphabetical order
- To permanently delete sensitive files
Correct answer: To convert readable data into an unreadable format that can only be decoded with the proper key
Encryption transforms plaintext data into ciphertext using mathematical algorithms and keys, ensuring that only authorized parties with the correct decryption key can access the original information.
Question 5: In CRT project methodology, what distinguishes Agile from Waterfall?
- Agile uses iterative sprints with continuous feedback, while Waterfall follows a sequential linear process (Correct answer)
- Agile is only for small projects
- Waterfall requires daily standup meetings
- There is no meaningful difference between them
Correct answer: Agile uses iterative sprints with continuous feedback, while Waterfall follows a sequential linear process
Agile development uses short iterative cycles (sprints) with continuous customer feedback and adaptation, while Waterfall follows a strict sequential process (requirements → design → implementation → testing → deployment) with limited iteration.
Question 6: What is a firewall's primary function in CRT network security?
- To monitor and filter incoming and outgoing network traffic based on security rules (Correct answer)
- To prevent physical theft of computers
- To increase internet speed
- To store backup copies of data
Correct answer: To monitor and filter incoming and outgoing network traffic based on security rules
A firewall monitors all network traffic and enforces security rules by allowing or blocking specific traffic based on source, destination, port, and protocol, forming the first line of defense against unauthorized network access.
CRT Database Management & SQL 1
In CRT practice, what is the purpose of version control in software development?