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