Which of the following is used for defining relation structures, deleting relations, and relating schemas?
Show answer Hide answer
Answer: B. DDL(Data Definition Langauge)
Explanation
DDL stands for Data Definition Language used to define database schema structures. It allows administrators to create, alter, and delete database relations and schemas. Commands like CREATE and DROP belong entirely to the data definition language. Database management systems separate data definition from data manipulation functionalities. DDL statements compile into metadata stored inside the database system catalog. Relational databases rely on DDL to establish tables, constraints, and relationships.
Database architects write DDL scripts to initialize tables and foreign key relationships. Modifying a database schema requires executing administrative data definition commands. Schema definitions ensure data integrity before any manipulation operations can occur. DML or Data Manipulation Language handles retrieving and modifying stored data records. Query refers to requests for data retrieval rather than structural schema definitions. Relational Schema describes the logical blueprint rather than the language executing commands.
- Subject
- Computer Science
- Category
- Software Engineering
- Topic
- —
- Difficulty
- medium
Related questions
Q1. Which among these options is wrong ?
Show answer Hide answer
Answer: C. Computer science belongs to Software engineering
Software engineering is widely recognized as a specialized sub-discipline contained within broader computer science. Computer science encompasses theoretical foundations, algorithms, and hardware architecture far beyond...
Q2. What is a set of software elements treated as a single unit for SCM purposes?
Show answer Hide answer
Answer: A. Software Configuration Item
A Software Configuration Item represents a managed unit within configuration management processes. SCIs are uniquely identified and formally controlled throughout the software development lifecycle. Treating related soft...
Q3. Which option is excluded from standard change management processes?
Show answer Hide answer
Answer: D. None of the mentioned
All listed steps are fundamental components of standard change management procedures. Logging changes ensures traceability and accountability throughout the software lifecycle. Estimating impact and reviewing with stakeh...
Q4. What is the cause of software bugs and failures_____________________?
Show answer Hide answer
Answer: C. Both Software companies and Developers
Software defects originate from multiple sources including organizational flaws and developer mistakes. Software companies establish faulty processes while individual developers introduce specific coding errors. Comprehe...
Q5. Which of these is not among the eight principles of the Software Engineering Code of Ethics and Professional Practice?
Show answer Hide answer
Answer: D. ENVIRONMENT
The environment is not listed as one of the fundamental ethical principles. Professional software engineering ethics focus primarily on human stakeholders and products. Environmental concerns are broad but omitted from t...
Q6. Which of the following terms characterizes testing?
Show answer Hide answer
Answer: B. Evaluating deliverable to find errors
Testing involves evaluating software deliverables systematically to uncover hidden defects and errors. Executing programs under controlled conditions helps discover discrepancies between expected and actual results. Qual...