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