Description of this paper

MCQ of Database Management System (DBMS) Set - 4

Description

solution


Question

1. The number of attributes in relation is called as its.....................;A) Cardinality;B) Degree;C) Tuples;D) Entity;2. The DBMS utility,...................... allows to reconstruct the correct state of database from the backup and history of transactions.;A) Backup;B) Recovery;C) Monitoring;D) Data loading;3. In the........... normal form, a composite attribute is converted to individual attributes.;A) First;B) Second;C) Third;D) Fourth;4. In RDBMS, Data is presented as a collection of............;A) Table;B) Attributes;C) Relations;D) Entities;5. A.................. normal form normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.;A) First;B) Second;C) Third;D) Fourth;6. To select all column from the table the syntax is;A) select all from table_name;B) select * from table_name;C) select from table_name;D) Non of the above;7. If an attribute of a composite key is dependent on an attribute of the other composite key, a normalization called................ is needed.;A) DKNF;B) BCNF;C) Fourth;D) Third;8. Identify the criteria for designing database from the point of view of user;A) No redundancy;B) No inapplicable attributes;C) Uniformity in naming & definitions of the data items;D) All of the above;9. The............ operator preserves unmatched rows of the relations being joined.;A) Inner join;B) Outer join;C) Union;D) Union join;10. The reasons leading to popularity of client-server systems are;A) More powerful workstations on LANs;B) Needed for graphical user interfaces of end users.;C) Remove computing load for presentation services from the system managing a shared database resource.;D) All

 

Paper#68168 | Written in 18-Jul-2015

Price : $22
SiteLock