Q1. What does RDBMS stand for?
Answer: A) Relational Database Management System
Q2. Which of the following is a feature of Oracle 11g?
Answer: D) All of the above (Real Application Clusters, Automatic Storage Management & Flashback Technology)
Q3. In database normalization, what is the primary goal?
Answer: A) Minimize redundancy
Q4. What is a DFD?
Answer: A) Data Flow Diagram
Q5. Which SQL command is used to remove a table from a database?
Answer: B) DROP
Q6. What does ERD stand for?
Answer: A) Entity Relationship Diagram
Q7. Which command is used to create a backup in Oracle?
Answer: C) RMAN
Q8. Which of the following is a type of JOIN in SQL?
Answer: D) All of the above (INNER JOIN, OUTER JOIN & CROSS JOIN)
Q9. What is the maximum number of rows returned by a SELECT statement if no LIMIT is applied?
Answer: C) Unlimited
Q10. What does PL/SQL stand for?
Answer: B) Procedural Language/SQL
Q11. What is the purpose of the Oracle Data Pump?
Answer: A) Data Import and Export
Q12. In which SQL statement is the WHERE clause used?
Answer: D) All of the above (SELECT, INSERT & UPDATE)
Q13. What is a primary key in a database?
Answer: A) A unique identifier for a record
Q14. Which of the following tools is used for database modeling?
Answer: D) All of the above (MS Vision, Toad Modeler & Oracle SQL Developer)
Q15. What is the main function of a data warehouse?
Answer: B) Historical data analysis
Q16. What is Shell Scripting primarily used for?
Answer: B) System administration tasks
Q17. What is the function of data mining?
Answer: C) Discovering patterns in large datasets
Q18. Which of the following is not a data modeling technique?
Answer: D) Object-Oriented Model
Q19. What does the term “Disaster Recovery” refer to?
Answer: B) Restoring systems after a disaster
Q20. What does normalization do in database design?
Answer: B) Eliminate duplicate data
Q21. In Oracle, which command is used to retrieve data from a table?
Answer: B) SELECT
Q22. Which of the following is a valid SQL data type?
Answer: D) All of the above (INTEGER, CHAR & VARCHAR)
Q23. In a database, what is a foreign key?
Answer: A) A primary key from another table
Q24. Which command is used to modify existing data in a table?
Answer: A) UPDATE
Q25. What is a view in SQL?
Answer: A) A virtual table
Q26. Which of the following is a non-relational database?
Answer: C) MongoDB
Q27. In Oracle, what does RMAN stand for?
Answer: B) Recovery Manager
Q28. What is the purpose of data normalization?
Answer: A) To organize data efficiently
Q29. Which of the following is not a type of join?
Answer: D) COMPOSITE JOIN
Q30. What is the main purpose of an Entity-Relationship Diagram (ERD)?
Answer: B) To visualize database structure
Q31. What is the output of the SQL query SELECT COUNT(*) FROM table_name;?
Answer: A) Total number of rows
Q32. In a SQL database, what does the acronym DDL stand for?
Answer: A) Data Definition Language
Q33. What is a composite key?
Answer: A) A key made up of multiple attributes
Q34. Which of the following statements is true about a database?
Answer: B) It is a collection of related data.
Q35. What is the use of an index in a database?
Answer: B) To speed up data retrieval
Q36. In SQL, which keyword is used to filter records?
Answer: D) Both A and B (WHERE & HAVING)
Q37. What does a database trigger do?
Answer: A) Automatically executes a specified action when certain events occur
Q38. Which command is used to add new rows to a table?
Answer: A) INSERT
Q39. What does SQL stand for?
Answer: A) Structured Query Language
Q40. In Oracle, which command is used to grant privileges to users?
Answer: B) GRANT
Q41. Which of the following is a characteristic of a relational database?
Answer: D) All of the above (Data is stored in tables, Relationships between data are defined & Data can be queried using SQL)
Q42. What is the purpose of the GROUP BY clause in SQL?
Answer: B) To aggregate data
Q43. In Oracle, what is the use of the ALTER command?
Answer: B) To modify an existing table
Q44. What is a stored procedure?
Answer: B) A set of SQL statements that can be executed as a unit
Q45. What does a foreign key establish in a relational database?
Answer: B) Data integrity
Q46. Which of the following is a benefit of using a data warehouse?
Answer: A) Enhanced data analysis
Q47. What is the purpose of data mining?
Answer: A) To analyze past data for patterns
Q48. What is the role of a database administrator?
Answer: D) All of the above
Q49. Which SQL clause is used to sort the result set?
Answer: A) ORDER BY
Q50. What does Toad Modeler primarily assist with?
Answer: B) Database modeling
Q51. In Oracle, what is the primary purpose of the RMAN tool?
Answer: B) Backup and recovery
Q52. What type of data does a data warehouse primarily store?
Answer: B) Historical data
Q53. What is a shell script?
Answer: A) A file that contains a series of commands for the shell
Q54. What does the acronym SQL stand for?
Answer: B) Structured Query Language
Q55. What is the main function of the SELECT statement?
Answer: A) To retrieve data from a database
Q56. Which Oracle feature allows for point-in-time recovery?
Answer: A) Flashback
Q57. Which of the following is a valid SQL function?
Answer: D) All of the above
Q58. In SQL, what does the DISTINCT keyword do?
Answer: B) Returns unique values only
Q59. What does a data model represent?
Answer: A) Data structures and relationships
Q60. What is the purpose of an index in a database?
Answer: B) To optimize data retrieval
Q61. What is the purpose of the HAVING clause in SQL?
Answer: A) To filter groups
Q62. Which of the following is an example of a NoSQL database?
Answer: C) MongoDB
Q63. In a relational database, which term describes a one-to-many relationship?
Answer: A) Cardinality
Q64. What is the main purpose of using PL/SQL?
Answer: C) Procedural programming within Oracle databases
Q65. Which command is used to delete all records in a table without removing the table structure?
Answer: C) TRUNCATE
Q66. Which of the following is not a type of database model?
Answer: D) Functional
Q67. In SQL, which keyword is used to limit the number of records returned?
Answer: D) BOTH A and C
Q68. Which of the following is a benefit of using Oracle Data Pump?
Answer: A) Fast data export and import
Q69. What is the main advantage of using a data warehouse?
Answer: B) Historical analysis and reporting
Q70. What is the purpose of the GROUP BY clause?
Answer: A) To group rows that have the same values
Q71. Which SQL command is used to change data in a database?
Answer: C) UPDATE
Q72. What does a relational database use to establish relationships between tables?
Answer: B) Keys
Q73. Which command is used to display all records from a table called ’employees’?
Answer: A) SELECT * FROM employees;
Q74. What is the main use of Oracle RMAN?
Answer: C) Backup and recovery
Q75. Which of the following describes the term “data integrity”?
Answer: A) Accuracy and consistency of data
Q76. In Oracle, what is the purpose of the EXPLAIN PLAN command?
Answer: A) To analyze SQL statements
Q77. Which of the following best describes data mining?
Answer: A) Extracting patterns and knowledge from large amounts of data
Q78. What is the main function of a database trigger?
Answer: B) To execute code automatically when specific conditions are met
Q79. Which of the following is a benefit of using a data warehouse?
Answer: A) Improved data analysis and reporting
Q80. What does the SQL command CREATE TABLE do?
Answer: C) Creates a new table in the database
Q81. What is the capital city of Pakistan?
Answer: C) Islamabad
Q82. Which river is known as the lifeline of Pakistan?
Answer: A) Indus River
Q83. Who is known as the “Father of the Nation” in Pakistan?
Answer: B) Muhammad Ali Jinnah
Q84. Which of the following is a major mountain range in Pakistan?
Answer: A) Himalayas
Q85. The national flower of Pakistan is:
Answer: A) Jasmine
Q86. In which year did Pakistan become independent?
Answer: B) 1947
Q87. What is the currency of Pakistan?
Answer: B) Rupee
Q88. The largest city of Pakistan by population is:
Answer: B) Karachi
Q89. Which of the following is a UNESCO World Heritage Site in Pakistan?
Answer: B) Moenjodaro
Q90. Which element is represented by the chemical symbol ‘H’?
Answer: B) Hydrogen
Q91. The process of converting a liquid to a gas is known as:
Answer: C) Evaporation
Q92. The earth revolves around the sun in approximately how many days?
Answer: A) 365
Q93. Which gas is essential for photosynthesis in plants?
Answer: C) Carbon Dioxide
Q94. The capital of the province of Sindh is:
Answer: B) Karachi
Q95. The sum of angles in a triangle is always:
Answer: B) 180 degrees
Q96. What is the square root of 64?
Answer: C) 8
Q97. Which of the following is a synonym for “happy”?
Answer: B) Joyful
Q98. The national language of Pakistan is:
Answer: B) Urdu
Q99. Which planet is known as the “Red Planet”?
Answer: B) Mars
Q100. Who wrote the famous poem “Saare Jahan Se Achha”?
Answer: A) Allama Iqbal
×
I need army UDC past papers