MCQ | Database Management System (DBMS) Database Management System (DBMS) 1 / 53 The server process that implements lock Manages functionality, is called Lock Manager Proceses Database Writer Process Manager processes Server Processes 2 / 53 Which of the following is/are the main goals of a distributed database? All of the options are correct Reduced communication overhead Incremental growth Interconnection of database 3 / 53 The term "Data" refers to: All of above Basic information The electronic representation of the information ( or data) Raw Facts and figures 4 / 53 In a distributed Database reduction of redundancy is obtained by_____ Data Replication Data fragmentation Data Sharing None of the above 5 / 53 Which of the following is generally used for performing tasks like creating the structure of the relations, deleting Relations? Query DDL(Data Definition Language) DML(Data Manipulation Language) Relational Schema 6 / 53 Functional Dependencies are the types of constraints that are based on_____ Key Key revisited None of the mentioned Superset key 7 / 53 A table on the many side of a one to many or many to many relationship must: Have a single attribute key Have a composite key Be in Third Normal Form (3NF) Be in Second Normal Form (2NF) 8 / 53 The data type appropriate to store salary is. . Currency Text Memo Auto number 9 / 53 A relational database consists of a collection of Fields Tuples Keys Tables 10 / 53 With SQL, how do you select all the records from a table named "Persons" where the value of the column “FirstName” ends with an “a” ? SELECT * FROM Persons WHERE FirstName='a' SELECT * FROM Persons WHERE FirstName LIKE '%a' SELECT * FROM Persons WHERE FirstName='%a' SELECT * FROM Persons WHERE FirstName LIKE 'a%' 11 / 53 The columns in a database table are called. .. record field report Memo 12 / 53 Which of the following is not a database application? MS-Access MS-Excel Oracle FoxPro 13 / 53 Which of the following refers to the level of data abstraction that describes exactly how the data actually stored? Conceptual Level File Level Physical Level Logical Level 14 / 53 Which data type provides storage for variable length and arbitrary format data? OLE object Text Memo Hyperlink. 15 / 53 CREATE TABLE employee (name VARCHAR, id INTEGER ) What type of statement is this? Integrity constrain DDL View DML 16 / 53 The default data type in MS-Access if . . . Text Memo Number Data/Time 17 / 53 Storing a separate copy of the database at multiple locations is which of the following? Horizontal Partitioning Vertical Partitioning Data Replication Vertical Partitioning 18 / 53 The primary key does not accept . . . None of above Text Null Value Number 19 / 53 The UPDATE SQL clause can______ update more than one row at a time delete only one row at a time delete more than one row at a time update only one row at a time 20 / 53 The maximum size of the text field in MS. Access is . 50 255 6400 10 21 / 53 A distributed database is a collection of data which belong to the same system but are spread over the of the network. Logically, sites None of the above Database, DBMS Physically, sites 22 / 53 object of access is used to print formatted data. Report Query Form Table 23 / 53 In the __________ normal form, a composite attribute is converted to individual attributes. First Second Fourth Third 24 / 53 Which of the following SQL statement is used to DELETE rows from a database table? . REMOVE DROP CLEAR DELETE 25 / 53 The extension of the database file in MS Access is MDB DBM DBF DMB 26 / 53 _____is not the data type of MS-Access. Memo Form Number Text 27 / 53 Tables in second normal form (2NF): Have a composite key Eliminate all hidden dependencies Have all non key fields depend on the whole primary key Eliminate the possibility of a insertion anomalies 28 / 53 The report can be generated by using data from... Query Table Both Table And Query Forms 29 / 53 A data dictionary is repository that manages _________ Memory Spell Checker Data validator Metadata 30 / 53 Which of the following gives a logical structure of the database graphically? Entity-Relationship diagram Database diagram Entity diagram Architectural representation 31 / 53 A field that is used to uniquely define particular record in a table is called: Entity Relationship Primary Key Constraints 32 / 53 In MS Access data are stored In . . …. All of the options are correct Query Table Form 33 / 53 This key that uniquely identifies each record is called: Field Name Key Record Unique Key Primary Key 34 / 53 A Detail Management System is a type of _______ software. Bot A and C It is a kind of general software Its a type of system software It is a kind of application software 35 / 53 Which of the following is not a DDL command? UPDATE TRUNCATE ALTER None of the option 36 / 53 In the given query which of the keyword has to be inserted?INSERT INTO employee ___ (4,Alok,2000); Table Values Relation Field 37 / 53 A relationship is considered a: three-dimensional table one-dimensional table Column two-dimensional table 38 / 53 Which of the following is a group of one or more attributes that uniquely identifies a row? Determinant Relation Tuple Key 39 / 53 Which forms simplifies and ensures that there are minimal data aggregates and repetitive groups: 2NF 1NF All of the mentioned 3NF 40 / 53 The term attributes refers to a________ of a table. Key Column Record Tuple 41 / 53 An _______ is a set of entities of the same type that share the same properties, of attributes. Entity model Relation set Entity set Attribute set 42 / 53 Which SQL keyword is used to retrieve a maximum value? UPPER MAX MOST TOP 43 / 53 ….. query changes the value in the main table Select both Select & Update None Update 44 / 53 A........ key uniquely identifies a record. Foreign Primary None Composite 45 / 53 Which is a bottom-up approach to database design that design by examining the relationship between attributes: Decomposition Functional dependency Database modeling Normalization 46 / 53 In general, a file is basically a collection of all related_____ Records Rows & Columns Fields Database 47 / 53 The term ________ is used to refer to a row Attribute Tuple Field Instance 48 / 53 Which is not a type of query? All the options are correct Search Select Update 49 / 53 Which-one ofthe following statements about normal forms is FALSE? Lossless, dependency –preserving decomposition into 3 NF is always possible BCNF is stricter than 3 NF Loss less, dependency – preserving decomposition into BCNF is always possible Any relation with two attributes is BCNF 50 / 53 The entity relationship set is represented in E-R diagram as Dashed lines Double diamonds Diamond Undivided rectangles 51 / 53 The term "SQL" stands for Sequential query language Structured query language Standard query language Server-side query language : 52 / 53 In the __________ normal form, a composite attribute is converted to individual attributes. First Third Second Fourth 53 / 53 Date/Time occupies . . . bytes of memory. 8 4 16 2 Your score isThe average score is 56% 0% Restart quiz