pata aiffe’ mi ables al pata control Language (DCL) comman, ie ata Manipulation Language (OML) ehayi 39 Pemmmon DMI- statements are SELE¢ bles Report it structures In a database, ‘an obtain info r ils that define th database object ction Control x = pansion Cont angage Tanne INSERT INTO. AND Deiere, nt sects on the database, 1 can also rotiyacy, ne MANSIONS by fommands are COMMIT, ROLLBACK eye nanees made by tie ener ae and SAVERON by other commands. Some cor 5 Sse, ———— 9 bjective Questions eee povnntle Choice Questions (McQs) x incorrect and inconsistent data should not be st M ” database features? *tored in a database ~ this is ensured by which of the following a. Security Goan iecovery », Data sharing 4 4, Referential integrity ‘fy, The class teacher of class 10th is creating a database table to note down the dally att @ down the dally attend ‘ ance to check f the student is present or Not. Which data type is most suitable for such a field? a. Char b. Varchar ¢. Boolean d. Real are ref ps. Database servers are referred! toa z {C8Se Semple Paper, 20281 a. Front-ends b. Back-ends ¢. Clients 4, Model = are dedicated computers that store the actual databases for the database software . Web servers d, None of these 2, Database servers c. Both a and b 5, In design view which is not a part of properties of afield? (nay a. Primary Key b. Default value - Length 4, Auto Value © ‘ Database Management Systemhave primary key columns. b. Many to One eee 4, Both b and ¢ © Many to Many «° a relationship, both the tables must ternative name for any field allows the userto speci an al 7. The property alias a. Default . Edit «. Format el of vertical hot hat is organized using a mod! is ore: ; 8. A table is a set of data elements t are bb. Columns, Rows ny a. Rows, Tables sh sh rabase. {CBSE Sample 2 statement is used to retrieve records in a databas he ae 2. Alter b. Update Select d, Create nd change field type. 10. 1h snes View in Database we can set Primary Key and change felt! tYP a a, Datasheet view b, Design Query ©. Wizard d, Design View e ws a occurs when the same piece of data is duplicated multiple times. a. Data integrity b, Data Inconsistency © Data Redundancy 4. Backup 12, sunmuau afe used to display the selected data in a printable format. | 2. Reports b. Forms ©. Queries d. Wizard Which among the following is a well known DBMS? ua 2. Oracle b, Microsoft SQL Server ae d. All of these --svensonsn Gata i stored in a single table and is usually suitable for less amount of data. & a. Flat File b, Single File ¢. Relational d. None of these 415. Data .-» means that the data is accurate and consistent in the database. Xa. Privacy , Duplication . Security d, Integrity 16. By default, length of the field is 50 but the size of the field can be set to maximum length sng : field property. 2. Format b. Default: c. Length d. Auto Value ID. sosnninenovenosnes MANS that the QuerY Uses criteria you provide to hide some data and present only what! want to see, a. Filtering b. Sorting . Reports 4, None of these 90: Touchpad Question Bank (IT 402)-Xal Bi Uy 8 Qu ; of the follow! wie ing is NOL a con mon DOL e ate aoe Staten, vent? OP eo" b.Alter om mgnour oF «UKE 5. oFDER ey = Is anintert ace ina or avase objects such astables, Pesta A) les. fied tay ind a. Table Fut that allows users 15 to ew, enter and edt data direchy a, Required b.Defauit : helps to display the data in a sums a format. - a summarized manner and generate the print out sin a clear for 3 Table ap. ou can insert tables from. OpenOffice.org Calc oF Microsoft Excel ira ee ees ans ste locate, aes, within named ranges fom an 3. HTML et into Cale spreadsheet, es b.T™L oct a.1AVA inatabie, b. Mutinle columns 4. None ofthe above Record or Tuple that represents 2 24, Arowis? A 4, Single data item «Multiple records items 2s, what datatype should you prefer for 32 ‘code fieldin a table? a. Text b, Number 4d. all ofthe above unauthorised user can acess te ¢, Memo ig the important concept of database {0 ensure that no ® database. a. Data security ‘bata Intesity Primary Key 4, Data shaving 7. in. _celationship notable as the primary key colar © onetoone b. Many to Mary . none ofthese ae ready been created wih 312 86 ag it we have to enter one value 2 ceturn for spe ree0ra nee table has a i ment in SOL will use _state Res 4, select a. alter «. Edit[ease ' ey “ 389. Which one ofthe fotowing isan example of ROBMS? a ogity ins d. Oracle. main systems. Fy . pice ree) Syst b. Formula concept ny ¢, Database concept a ee ey 6. a 7b 8b Xe mS SES 15,4 16. ¢ ne tag or oe 28. b ERIE Competency Based Questions /f// Az. A: Database Management System automatically takes care of R: User need not take backup regularly. backup and recovery. Choose the correct option as: ‘. Both A and Rare true and reason is the correct explanation of the A. b. Both A and R are true but reason is not the correct explanation of the A. c. Ais true but Ris false. 4. Ais false but Ris true ‘Akshat wants to store a huge amount information about his firm in a database. Which type of table organization would be most suitable for this purpose? b. Flat File: a. Relational 4d, Hierarchical c. Either Relational or Fiat file 3+ A: Record is a set of information consisting of fields stored in your database about one of the items. R: A value that is the actual text cannot be put in this record. Choose the correct option as: 42, Both A and R are true and reason is the correct explan: b. Both A and R are true but reason is not the correct explanation of the A. n of the A. c. Ais true but R is false d. Ais false but Ris true. 4_ A: When we put in information in the table , we cannot have people with the same name. R: This can be done by using some number or value that uniquely identifies a record, Choose the correct option as: a. Both A and R are true and reason is the correct explanation of the A. b. Both A and R are true but reason is not the correct explanation of the A, ¢, Ais true but R is false. d. Ais false but Ris true. 22) Touchpad Question Bank (IT 402)-xtors base objectis ber ets Aaa In te in rrr UNM mane or sad Forms ae user while creating ada im ye 1 database has 4 Alo these asks the user to allow software to specin net APY ek ecity Pri Idas ify Primary Key field ry. a. SNo ek Pe 1. This felis called as b.1D 7, while creating a database user wants 4. Index no that cor poe MPaNY name to apps cee 0 appear for eve PANY name va TY new record thathe enters. Hstime ue is same forall the reco ies ds, 50 it need not be typed for for data entering will also reduce. Th a. Format : ¢, Default Value b.Lenath 6. Auto value I be used for this 8, Ateacher is entering data to maintain are mandatory fields. Therefore Ge ween must be necessarily filled in before movin, Reno Sent. Tete are mays for whieh als cn uigety, Whereas Aisin number an student sae 3 ropa ata ing ate se al ery Whi tld property bese? a bs. EntyReauied Lary Rey . AHospital staff h i 5 pee ews ined the data of patients in database table. Their purpose is that after jo be extracted or retrieved they shouldbe able to do so from poo of da nea ian lose they require to not only extract the information but also jin information from diferent ble ee mation nt tables to fiter what i required? a. query bb Sorting, «c, Functions o. Edit 410, Malini wants to store a huge amount of information about her zone in a database, ‘Should not be repeated in her file. Her friend Gargi explained her various benefits of storing data in RDBMS. & helps in preventing/controlling duplication of data. Which of the following terms is used to refer tO duplication data? (case, 2022), a. Data sharing b. Data privacy c. Data redundancy Data integrity {Bse, 20201 ed to add one or more: records toa database, nesystem (93) statement is Us patabase Manager