1. Which operator can be used to free memory allocated for an object in C++?

A. Collect B. Delete C. unallocated D. free ( )

2. Which feature of oops described the reusability of code?
A. Abstraction B. Inheritance C. encapsulation D. polymorphism
3. The type of diagram which specifies operation on objects considered as...............
A. Entity diagram B. Functional diagram C. Attribute diagram D. Class diagram
4. media recovery refers to recovering database
A. After database has been physically damaged B. After a system crash
C. After deadlock D. After some individual transaction has failed
5. To make your website mobile friendly and to adapt it to different screen platform, you must make your website.
A. Fast loading B. Reactive C. Light D. Responsive
6. A criterion for to select a webhosting that measures of the month (or week or year) your website is available.
A. Security features B. Uptime C. Email availability D. Customer service
7. In the three tier architecture ,the intermediate between database and client is classified as
A. Transaction Server B. Functional Server C. Application Server D. Disk Server
8. From the 5s procedures, which one is used to remove unnecessary items from each area
A. Standardize B. Sustain C. Sort D. Shine
9. Which of the following is generality used for performing tasks like creating the structure of the relations, deleting
relation?
A. query B. DML (data manipulation language)
C. DDL (data definition language) D. Relational schema
10. Connecting website to backend servers, processing the data and controlling the higher layers are done by
A. Java scripts B. CSS scripts C. HTML language D. Server side PHP scripts
11. Among the following ,which one is used for communication between the web server and the database server
A. Java database connectivity (JDBC) B. Common gateway interface (CGI) script
C. Middleware D. Native support
12. By normalizing relations or sets of relations,in a database can minimizing.
A. database B. Redundancy C. Data D. Fields
13. Which one the following is not an essential features of when you plan for data conversion from legacy system?
A. Accuracy B. Completeness C. Time lines D. User interface
14. You are looking for a website hosting service to host you online shopping website .what is the criteria that will
put first when you compare ahosting company?
 A. Security features B. Customer service C. Optimization D. Email availability
15. Unnecessary conveyance of products, from one location to another ,or handoff from one employee to another is
A. Processing waste B. Waiting time waste C. Over production waste D. Transport waste
16. What is a functional requirement?
A. Specifies the system’s operation capabilities and constraints and attempt to improve its functionality
B. definessystem attributes such as security, reliability, performance, maintainability, scalability and usability
C. Specifies the tasks the system must complete
D. Specifies the tasks the program should not complete
17. A database key word that indicates the constraint of a database whose column values of a table are required to be
assigned an initial values in the database is usually damage is called..........
A. NOT NULL B. Distinct C. Values D. Where clause
18. What will be the output of the following CSS code snippet? Span (border 1px solid red outline green dotted
thick)
A. All span elements will have an outer red border and inner green dotted border
B. All span elements will have a red border and a green dotted outline
C. All span elements will have a outer green dotted border and an inner red border
D. All span elements will have a green thick border and a red outline
19. Among the following which refers to describing the data description, representing data semantics, and describing
the consistency constraints that apply to the data
A. Adding data B. Modeling data C. Modifying data D. Refining data
20. The service provider for the user described in which section?
A. System requirements B. Appendices C. System model D. User requirements
21. You have table in your database having a foreign key what type of command does you to add new column to the
table
A. On update no action B. On update cascade C. On update set default D. On update restrict
22. Which one describes and explains anything to do with your software product, ranging from internal
documentation for teams to external documentation written for end user
A. Development methods B. Technical documentation C. Security tester D. User documentation
23. Data schemas represent the skeleton structure of a database and it represent the.................. view of the database
as a whole
A. Practical view B. Analytical view C. Semantic view D. Logical view
24. a security mechanism used in data communication environment to filter the packets forwarded to and from the
network is referred to be
A. Firewall B. Biological Biometrics C. Cryptography D. Encryption
25. Which two features of object oriented programming are the same?
A. Abstraction and polymorphism features are the same
B. Encapsulation and abstraction
C. Encapsulation and polymorphism
D. Inheritance and Encapsulation features are the same
26. When deadlock is detected the recovery is normally accomplished by
A. Locking of data [Link] checking C. Roll back of transaction D. Transaction lock
27. Which one of the following given statements possibly contains the error?
A. Select empid from emp;
B. Select empid from epm where empid =10006;
C. Select * from emp where empid =10003;
D. Select empid where empid =1009 and last name = GELLER;
28. Backward recovery is which of the following?
A. Where the before images are applied to the database
B. Where the after images and before images are applied to the database
C. Switching to an existing copy of the database
D. Where the after images are applied to the database
29. While SQL operate the power failure occurred,if you want to recover transaction which was executing at failure
time ,what you have to
A. Run roll forward all transactions
B. Nothing SQL server will recover automatically, rolling back pending transactions and rolling forward
committed ones
C. Nothing all transactions since the last check point are lost the effects of the others are in the database
D. Take a backup the transaction log restore the database from the last full database backup and then restore all
the transaction logs
30. Which one of the following SQL command helps to add a record in to a row using SQL in a database?
A. Create B. Insert C. Add D. Make
31. Performance analysis and tuning is which of the following?
A. Undertaken as an ongoing part of managing a database
 B. Undertaken as an ongoingpart of the backup of database
C. Undertaken one time at the time of aDBMS installation
D. Undertaken one time at the time of the implementation of a new application
32. .................is the data that has been organized or presented in a meaning full way
A. Software B. Application C. Storage D. Information
33. Which one is a step that records client support requirements based on organizational rules,regulation and policies
A. Priority B. Log C. Escalate D. Client
34. Which one of the following is typed correctly?
A. <h1> write your first CSS example <h1> B.</p> write your first paragraph </p>
C. <imgsrc= ''images/nature_3.jpg'' style=''with:300px''> D. <td> so no</td
35. Which one is data manipulation command
A. Select B. Truncate C. drop D. Delete
36. The collection of documents that are designed to help people who need to manage operate or maintain computer
hardware or software
A. Technical documentation B. Inventory documentation C. Hardware inventoryD. Inventory record
37. It is clear that now a days most organizations are developing database systems over their file management system
that they are using before .so why do you think that organizations prefer database management systems over file
management methods?
A. Database management has simple structure to implement than file management
B. File management supports more files than database management systems
C. Database management provides rigorous security than file management
D. File management provides complex back up / recover than database system
38. among the following which one is the cheapest type of hosting
A. VPS web hosting services B. Free web hosting service
C. Dedicated web hosting service D. Shared web hosting service
39. a small piece of data sent from awebsite and stored in users web browser while a user is browsing awebsite
A. Web firewall B. Web cookie C. Web cache D. Web client
40. Which one of the following is an integrated part can restore the database to the consistent state of before failure?
A. Backup scheme B. Transaction scheme C. Recovery scheme D. Restoring scheme
41. Which one is a step in system development that lays out functional and non-functional requirements?
A. Software requirements specification B. Software version
C. Database development D. Web development
42. What does the <br>tag addto your web page?
A. Paragraph breaks B. Long break [Link] breaks D. Section break
43. Which of the following techniques can be used for optimizing backed up space?
A. Encryption and duplication B. Duplication only
C. Compression and duplication D. Authentication and duplication
44. If a database has to be maintained using OOP to store the details of each employee in a company which would be
the best choice among the following?
A. Define a class to store details of each employee
B. Define a structure to store details of each employee
C. Define separate variable for eachdetail
D. Define a generic type to store string and number details
45. Which SQL operator is used as aconjunction that connects the two queries to return only the required sets of
data?
A. From clause B. And C. Like D. Update
46. Which of the following is the correct syntax to make the back ground color of all paragraph elements to yellow?
A. p{back ground-color: #yellow;} B. all p {back ground-color: #yellow;}
C. p{back ground-color: yellow;} D. all {back ground-color: yellow;}
47. What is the name of the feature in which we enforce the definitions of the abstract function at the compile time?
A. Static polymorphism B. Dynamic polymorphism
C. Dynamic or static polymorphism according to need D. Polymorphism
48. To estimate the cost of the query ............... it is possible to determine the response time i.e., the time it takes to
execute the plan
A. Evaluation time B. Query time C. Response time D. Plan time
49. Type of database system test that carried as part of system testing to check and detect if there is a problem in the
system as a result of a change made to another component of the system
A. Functional testing B. Recovery testing C. Regression testing D. Load testing
50. A network device used to connect two or more dissimilar networks
A. Router B. Gateway C. Hub D. Switch
51. It is a field (or collection of fields) in one table that refers to the PRIMARY KEY in another table which ensures
arelationship is created.
A. Referential integrity B. Foreign key C. Metadata D. Primary key
52. The property in CSS used to change the back ground color an element is...........
 A. Font-size B. Background-color C. bgcolor D. Color
53. What is the correct HTML for creating a hyperlink?
A. <a>[Link] .com</a>
B.<a href ="[Link]
C. <a name =[Link]
D. <a url="[Link] .com>[Link]</a>
54. What is an abstraction in object oriented program?
A. Hiding the implementation and showing only the features
B. Hiding the implementation
C. Showing the important data
D. Hiding the important data
55. You are adatabase developer for an insurance company. Every insurance policy is managed by one andonly one
product manager. One product managercan manage many [Link] can you represent that information in the
database?
A. Include the policy ID in the manager’s entity
B. Include the manager ID in the policies entity
C. Create another entity which contains policy ID and the manager ID
D. Include the manager ID in the policies entity and the policy ID in the manager’s entity.
56. Which process involves developing an approximation of the costs of resource needed to complete a project?
A. Estimating cost B. Controlling cost C. Determining the budget D. finalizing the cost base line
57. It is a video transmission interface that offers better resolution than the others and supports up to 8k (7680×4320)
resolution at 60HZ with an increased band width of 77.73Gbps
A. HDMI port [Link] port C. DVI port D. Display port
58. Suppose the database consists of multiple transactions that are used to manage organization's group of related
data So which database attribute best describes the characteristics of a transaction that it shouldn.t be divided or
split rather it can exist as single unit is
A. Atomicity B. Consistency C. Durability D. Isolation
59. From computer maintenance procedures which one is the process of reorganizing the data stored on the hard
drive so that related pieces of data are put back together all lined up in a continuous fashion.
A. Antivirus B. Disk formatter C. Defragmenter D. Memory partitioning.
60. Mr. Alemu is a database manager at XYZ Company. He is required to plan and organize the overall works done
in his respective responsibility. Then which task is going to be executed atlast by Mr. Alemu?
 A. Implantation of the work plan out line
B. Setting the organizational objectives
C. Reviewing and evaluating work plans and activities as per the set plan.
D. Escalation of problems
61. You have run an SQL statement that asked the DBMS to display data from a table named USER_TABLS the
result include columns of data labeled" Table name ", Number of column", and primary key " you are looking at
A. Indexes data B. User data C. Metadata D. Report data
62. the SQL statement that queries or reads data from a table is returns a result set of record ,from one or more tables
A. Read B. Select C. Query D. Order
63. One of the following tasks is highly important while you are setting organization's objectives when you plan and
organize works?
A. Enhancing the motivation and commitment of the group members
B. Identification of objectives which are not attainable
C. Setting objectives which are difficult to measure as per the standards
D. Developing objectives which are inconsistent with organizational aims
64. which one is a collection of similar types of entities
A. ER set B. Attribute set C. Relationship set D. Entity set
65. A UNION query is which of the following?
A. Combines the output from no more than two queries andinclude the same number of columns
B. Combines the output from multiple queries and must include the same number of columns
C. Combines the output from multiple queries and does not include the same number of columns
D. Combines the output from no more than two queries and does not include the same number of columns
66. Which of the following is true about PHP
A. it is a client side scripting language
B. it is a data definition language
C. it is a database application
D. it is a server side scripting language
67. the number of blocks transferred from the disk ,along with the number of disks seeks ,are used to estimate cost of
a query evaluation plan
A. Query implementation plan C. Query Estimation plan
B. Query Exemption plan D. Query Evaluation plan
68. Which type of CSS is used in the below code? {p style="border2px solid red",}
 A. Inline CSS B. Outside CSS [Link] CSS D. External CSS
69. Suppose you are recruited as database Administrator in Fulbright PLC company where records of exchange
commodities are expected to be managed centrally for the sake of administration using SQL .thus ,which of the
following syntax is the correct implementation of SQL commands used to build a table products and add fields
such as proid ,prod name ,item quantity , prod unit price and description for the table.
A. Select *from prodld ,prod name item quantity ,prod unit price description
B. Create table products ( prodld ,prod name ,itemquantity prod unitprice description )
C. Insert table products ( prodld ,prod name ,item quantity ,pro unit price description
D. Update products set prodld ,prod name ,item quantity,prod unit price description ,where prodld ='ETH30;
70. A Databaseuser who maintains a database management system and necessarily responsible for looking after its
overall usage and apply limitation to maintain enforce security is
A. Database designers B. End users C. Database Administrators D. Database Architects
71. Assume that you are asked to design the logical view of database for ABC PLC as database expert which one
clearly shows the skeleton structure that defines how the data is organized and how the relationships are
associated ?
A. Database Architecture B. Database schema C. Database manipulation D. Database Retrieval
72. A copy of database is called..........
A. Mailbox B. Sandbox C. instance D. Alias
73. Database Regression test can be done
A. Sometimes B. Occasionally C. Regular basis D. not required
74. Which of the following is used in the application programs to request data from the database management
system?
A. data control language B. data manipulation language
C. transaction control language D. data definition language
75. which of the following statements is false about hosting
A. Shared hosting is safer than dedicated hosting
B. Dedicated hosting is safer than shared hosting
C. Though more expensive than shared hosting,dedicated hosting is more secure
D. Shared hosting is cheaper than dedicated hosting
76. Below the following one is a process of analyzing the data objects and their relationship to the other objects.
A. System modeling B. Storage modeling [Link] modeling D. Web modeling
77. Which Microsoft office package enables users to perform mathematical computation and visualization of data?
 A. Microsoft word B. Microsoft publisher C. Microsoft PowerPoint D. Microsoft Excel
78. Which of the following are not characteristics of database driven web sites?
A. Data Availability B. Data security C. Data accuracy D. Data integrity
79. Microsoft windows IOS and Linux are all types of software that belong to ............ category.
A. Hardware systems B. Database system C. Operating system D. Application software
80. Which operator is used to compare a value to a specified list of values?
A. between B. where C. any D. in