Data Processing Assistant Model Paper
If You are appearing in UPSC exam for Data Processing Assistant posts in Information Technology Department, Govt. of NcT of Delhi or in National Crime Records Bureau (NCRB), Women Safety, Ministry of Home Affairs which will be conducting on 30th Jan 2022 at various exam centers and searching the Data Processing Assistant Previous year papers. Then you are at right place. Here we are providing the Data Processing Assistant Model paper on Database Management Systems
| Sr. No. | Question |
| 1 | In an object-oriented model, one object can access data of another object by passing _______
(a) Instance variable (b) Message (c) Variable (d) None of these |
| 2 | Which of the following is an aggregate function used in SQL?
(a) Union (b) Like (c) Group by (d) Max |
| 3 | Tree structures are used to store data in ________
(a) Network model (b) Relational model (c) Hierarchical model (d) File based system |
| 4 | Which of the following is NOT a recovery technique?
(a) Deferred update (b) Immediate update (c) Two – phase commit (d) Shadow paging |
| 5 | Every-Boyce-Codd normal form is in ______
(a) First normal form (b) Second normal form (c) Third normal form (d) All of the above |
| 6 | Which command is used to add a column to an existing table?
(a) Create (b) Update (c) Alter (d) None of these |
| 7 | _______ operator is used to compare a value to a list of literals values that have been specified.
(a) LIKE (b) COMPARE (c) BETWEEN (d) IN |
| 8 | In ER model the details of the entities are hidden from the user. This process is called ______
(a) Generalization (b) Specialization (c) Abstraction (d) None of these |
| 9 | Isolation of the transactions is ensured by ________
(a) Transaction management (b) Application programmer (c) Concurrency control (d) Recovery management |
| 10 | A view of database that appears to an application program is known as ______
(a) Scheme (b) Subschema (c) Virtual table (d) None of these |
| 11 | _____ command can be used to modify a column in a table.
(a) Alter (b) Update (c) Set (d) Create |
| 12 | ______ is a full form of SQL.
(a) Standard query language (b) Sequential query language (c) Structured query language (d) Server-side query language |
| 13 | The key to represent relationship between tables is called ______
(a) Primary key (b) Secondary key (c) Foreign key (d) None of these |
| 14 | _________ statements can use correlated sub queries.
(a) DELETE (b) SELECT (c) UPDATE (d) INSERT |
| Published on 27th Sept 2021 | |
Leave a Reply