Dee Cra) RPSC Programmer DBMS Questions Questions Latest RPSC Programmer DBMS Questions & ER ABU Re ial Start Complete Exam Preparation CR ere heroes te ra (im) Prstice es re Las Rees Download App Ex.) Question 1: View this Question Online > Data warehouse contains data that is seldom found in the operational environment. 1. Informational 2. Normalized 3. Denormalized 4. Summary ‘Answer! (Detailed Solution Below) ~. 4: Summaryforoy-Lel a2) India's Super Teachers for all govt. exams Under One Roof (FD) vor cassesvainle RPSC Programmer DBMS Questions Question 1 Detailed Solution The correct answeris Summary. Data warehousescontain several types of data that are seldom found in'the operational environment, but the most accurateanswer depends on the context. Here are some possibilities: 1, Summarized and aggregated data: Operational environments typically store detailed transaction data, while data warehousestocuson aggregated and summarized data for historical analysisand decision-making. This could includ Roll-up data: Daily salesfigures might be rofet up into monthly or quarterly totals. Derived data: Customer loyalty scoresor product profitability metrics might be calculated and stored in the data warehouse. Dimensional data: Product attributes, customer demographics, or ceographic data might be stored separately from transactional data for easier analysis 2. Historicaldata: Operational systemsoften prioritize recent data for performance purposes, archiving or purging older data. Data warehouses, however, retain historical data for longer periods, enabling long-term trends and comparisons. 3. Integrated data from multiple sources: Operational systemsmay store date in silos specificto their functions. Data warehousesintegrate data from various operational systemsand external sources, providing a unified view for comprehensive analysis 4, Non-transactional data: Operational systemsfocuson core businessprocesses,while data warehousescan include non-transactional data like market research reports, competitor analysis,or customer feedback for richer insights. Therefore, the most accurateanswerto the blank in "Data warehouse contains. data that is seldom found in the operational environment” depends on whet specificaspectof data storage and usage you're focusingon ,_ i eeCR ABR UT Rell) Start Complete Exam Preparation aS cos Cire Oe roe Rear Oe etc: Download App Question 2: View this Question Online > Which databases supports Polymorphism,Inheritance, Encapsulation, and Abstraction concepts? 1. RDBMS 2_ Distributed. DBMS 3. Network DBMS 4. OODBMS: Answer (Detailed Solution Below) Option 4: OODBMS RPSC Programmer DBMS Questions Question 2 Detailed Solution The correct answeris option 4. Object Oriented DBMS: Object-oriented DBMS is based on the object-oriented programming paradigm's model. They are useful for expressing both consistent data saved in databasesand transitory data encountered in running applications. They employ simple, reusable parts known as objects. Explanation: Object-oriented databasesclosely relate to object-oriented programming concepts. The four main ideas of object-oriented programming are: + Polymorphism + Inheritance + Encapsulation +. AbstractionThese four attributes describe the critics! characteristicsof object-oriented management systems, Hence the correct answer is 0005! B Additional Information Network DBMS: Network DBMS is one where the relationshipsamong data in the databaseare of type many to many in the form of anetwork. Relational DBMS: In relational databases, the databases represented in the form of relations. Each relation models an entity and is represented as 2 table of values. In the relation or table, a row iscalleda tuple and denotes a single record. Distributed DBMS: Adistributed databaseis a set of interconnected databasesthat are distributed over the computer network or intemet. rd CR ABR UT Rell) Start Complete Exam Preparation Dose ee need sige resend Exc Jownload App Question 3: View this Question Online > Match the following - List | List I i LOCK (@) Do |) Teele \(b)|_DML_ | (ii) COMMIT. (©) ToL di bivetored (a) Binet (iy) REVOKE 1. @ (i), D- @,c- (i), d- (iv) 2. a- (),b- (il), c- (W),d- (ill)3. a- (Ww),d- (i, c- (i), d- (il) 4, a Gil), 0 -(i),c- (d= (iv) Answer (Detailed Solution Below) Option 3: a- (iv), b- (i), c- (i), d- (i) RPSC Programmer DBMS Questions Question 3 Detailed Solution Correct Answer: Option 3 Explanation: + DDL stands for Data Definition Language. This includescommands that define or modify the structure of a schema, including the attributes. The REVOKE command withdraws the permissionsfrom a user of tabase object or schema.Since it modifies the users who can accessa schema, REVOKE DL command + DML stands for Data Manipulation Language . Thisincludes commends that modify the data contained in the database. It can enter new data, delete existing data and change the data. A LOCK TABLEcommand is implicitly applied when an INSERT, UPDATE, DELETE,MERGE and SELECTcommand is being executed. Therefore, LOCK TABLE is a DML command . + TCL stands for Transaction Control Language . They are used to maintain the integrity of the database tables and are committed at the end of any DML operation. Thus, COMMIT is a TCL command + Abinary operation is 2 set operation that is performed between two database tables. The natural difference finds the set difference between two database schemasand so it isa binary operation. & eee rca PS Elam CM cme L i cola) Renee ronan ones aca Dos caper Download App Question Bank Prete) Question 4: View this Question Online > To maintain materialized view in RDBMS, we use -SF yh ae 2. Pointer Answer (Detailed Solution Below) Option 1: Trigger RPSC Programmer DBMS Questions Question 4 Detailed Solution The correct answeris option 1. Concept: To maintain materialized view in RDBMS, we use Trigger. Triggers: Triggers are SQL statementsthet are run eutomaticelly whenever there isa change in the database. Triggers are run in reaction to certain table events (INSERT, UPDATE, or DELETE) Thesetriggers serve to maintain the datas integrity by updating the database's data in a regular manner. Syntax: create trigger Trigger_name@ (before | after) [insert | update | delete] on [table_name] [for each row] [trigger_body] Pointer and Clone objects are not related to RDBMS and those useful for programming language. Hence the correct answer is Trigger. ECE seer peti) Start Complete Exam Preparation Ree Reeceiar eeranes bor Download App Question 5: é View this Question Online’. In RDBMS, Single row functions are also known as. _e, 2. Numeric function 3. Column function 4. Instance function Answer (Detailed Solution Below) Option 1: ScalarFunctions RPSC Programmer DBMS Questions Question 5 Detailed Solution The correct option is (1) Concept- fy Single row functions in SQL are the ones that work onva singlé'tow.and return one output per row. Single row functions in SQL can be character, numeric, date, and conversion functions. These functions are used to modify data items. @ Key Points + Single row functions are al Wn as scalarfunctions which return a value for every row that isprocessedin aquery. * A scalarfunction is a function that returns one value per invocation; in most casesyou can think of this as retuming one value per row. + Character functions are those that enable you to manipulate character date. Justas character datatypes are sometimescalled string datatypes. + Numeric functions allow for the manipulation of numeric values. Numeric functions are sometimescalled mathematical functions. + Instance functions are the main tool for modifying or extracting data stored in an object. Instance functions are applied to objectsrather than classes. ss Be Dla Beds cece eh Boeck Wha nila Ps caine st Tie tt eee obinstance of a class,the instance variables are different. Fd PR ABR Re la) co PS Ela MO) CCM Cmte related) RRO et Cuan one) Tacs oer eee Yat Download App Question 6: View this Question Online > Which of the following is true concerning an Object-Oriented Databases (ODBMS)? 1. They have the ability to store complex data types omthe Web 2. They are overtaking RDBMS forall applications 3. They are mostuséful for traditional, two-dimensional database table applications 4 ie are correct Answer (Detailed Solution Below) Option 1: They have the ability to store complex data types on the Web RPSC Programmer DBMS Questions Question 6 Detailed Solution The correct option is (1) © Key Points + Object-Oriented Databaseshave the ability to store complex data types on the web. + A database that Is bullt on object-oriented programming is known asan object database management system (QODBMS) or an object database management system (ODBMS) (00P). + The two key benefits of MySQL data types are complex deta and a greater range of datakinds. Data is immediately retrieved and saved easily. + Instead of actions and data, an object-oriented database's structured around Objects ss a a EO ge Ne eel a, el Erre Lee eae gT RL ee Vater We NE eT NAO EU AL NRC ERR OL TA RN Ta” aS ee ees MTS specified data item. + Generally, an Object-Oriented Database is considered aysubset (@ kind of) NoSQL Database. Object-Oriented Database Object oriented programming Polymorphism ee Integrity > Fe Quer Encapsulation Goa rd CR ABR UT Rell) Start Complete Exam Preparation Dose (8) een oie) = j Par Question Bank Pera Jownload App Question 7: View this Question Online > DBMS is used to 1. Eliminate data redundancy 2. Maintain data integrity 3. Establishrelationshipsamong different files 4. All options are correct a ‘Answer (Detailed Solution Below)Option 4: All options are correct RPSC Programmer DBMS Questions Question 7 Detailed Solution The correct option is (4) All options are correct @ Key Points + By decreasing isolated files in which the same data is repeated, a DBMS can reduce data redundancy and inconsistency. + Although the DBMS may not be able to completely eliminate data redundancy, It can help lirnit it + The overall quality, completeness, and consistencyof date is known as data integrity. Data integrity alsorefers to the data’s safety and security in terms of regulatory compliance, suchas GDPR compliance. ’ + Data integrity is critical becauseit ensures and safeguardsyour datas searchabilityand traceability backto its original source. + Atelational databaseisa collection of data elements that are linked by predetermined connections. These elements ere laid out in a table format with columnsand rows. + Relationshipsenable relational databasesto partition and store data in several tables while also linking disparate data pieces. + The database management system (DBMS) organizés and manages incoming data, as well as allowsusersand other programs to modify or extractIt. Uses of DBMS. | Prenat] Pe eee eee eco Coca osc Start Complete Exam Preparation Peay Pr anaes MasterCl Cresco Gag eter D> Download AppQuestion 8: View this Question Online > Which of these is not TRUE in caseof responsibilities of Database Administrator? 1. Acquiring hardware end software resources 2. Authorizing aecessto database 3 m,_\ into the database 4. All options are correct Answer (Detailed Solution Below) Option 4 : All options are correct RPSC Programmer DBMS Questions Question 8 Detailed Solution The correct option is (4) All options are correct © Key Points + Within a wide range of public and private sector companies, database administratorsare responsible for accurately and securely using, maintaining, and developing computerized databases. + The primary Srcorongs ceptor cnet guarantee that data is available, secureagainstl@ssend corruption, and conveniently accessiblewhen needed. + The system administrator configures the database server's hardware and installsthe operating system, after which the DBA installsand configures the database software. + Setting up employee accessisa vital part of securing database. DBAsare in charge of determining who has accessand what kind of accessthey have. + Database administrators and architectsdesign and build systemsthat store and safeguard a wide range of data, including financial data and customer shipping records. + Itisthe jod of a Data Entry Clerk (or Database Administrator) to keep the information up to date and accurateon computer systemsand in archives. & eee eon ere ORG aE as Start Complete Exam PreparationDownload App Question 9: View this Question Online > Given a relation scheme (x,y, 2, w) with functional dependencies set F = {x — y, 2 — w). All attributes take single and atomic values only. A. Relation R is in FirstNormal FORM. [ B. Relation R is in Second Normal FORM C. Primary key of Ris xz_ Choose the correctanswe 2. Band Conly ‘om the options given below : 3. Aand C only 4. Bonly Answer (Detailed Solution Below) Option 3: A and Conly RPSC Programmer DBMS Questions Question 9 Detailed Solution First Normal Form (INF): If a relation contains a composite or multi-valued attribute, it violates the first normal form, or the relation is in first normal form ifit des not contain any composite or multi- valued attribute. A relation isin firstnormal form if every attribute in that relation is singled valued attribute. o r + Relation Ris in INF becauseit is given that for each attribute, R will have single and atomic values only. . ‘Second Normal Form (2NF): | 10 relations with composite keys, that is, relations with a primary key composed of two of more attributes. A relation with a single-attribute primary key is automatically in at least 2NF. A relation that isnot in 2NF may suffer from the update anomalies. + Relation R may or may not be 2NF.Primary Key: It is the column or columns that contain values that uniquely identify each row in a table. + Since R has F= {x — y, z — w}, it shows that if x and z are taken together, they will uniquely identify eachrow in the relation R. ieee aR Beet Ps Start Complete Exam Preparation Rect Ginn mpes Mock Tests Poecre eens Download App Ca ree og Gas ett Question 10: View this Question Online > In RDBMS, domain constraint is also called: 1. Tableconstraint 2. Database constraint 3. Tuple constraint 4, Attribtite constraint a Answer (Detailed Solution Below) Option 4: Attribute constraint RPSC Programmer DBMS Questions Question 10 Detailed Solution The correct answeris option 4. Concept: Arelational database management system(RDBMS)is a collection of programs and capabilities that enable IT teams and others to create, update, administer and otherwise interact with a relational database. Domain Constraints:Domain Constraints are user-defined columnsthat help the user to enter the value according to the data type. Columns are called attributes of a relation. It is also called an attribute constraint. Hence the correct answer is attribute constraint. oO : 7 B; Additional—_information— Oo There are two types of constraints that come under x d they are: Domain Constraints Not Null: Null values are the values that are unassign [so say that which are unknown or the missing attribute values and by det colt old the null values. Example: Create table employee (employee.id varchar(30),employee_name varchar(30)not null, salary NUMBER); Domain Constraints Check: Itdefines a condition that each row must satisfywhich meansit restrictsthe value of a column between ranges or we can say that it isjust like a condition or filter checking before saving data into a column. Example: Create table employee (employee_id varchar(30)not null check(employee_id> 0), employee_name varchar(30),salary NUMBER);