Quiz Questions

1. Quiz Questions Q.1 An entity set that does not have sufficient attributes to form a primary key is a (A) strong entity set. (B) weak entity set. (C) simple entity set. (D) primary entity set Q.2 In a relational model, relations are termed as (A) Tuples. (B) Attributes (C) Tables. (D) Rows. Q.3 In the relational models, cardinality is termed as: (A) Number of tuples. (B) Number of attributes. (C) Number of tables. (D) Number of constraints. Q4. Key used to represent relationship between tables is called (A) Primary key (B) Candidate Key (C) Foreign Key (D) Super Key Q5. A set of possible data values is called (A) attribute. (B) degree. (C) tuple. (D) domain.

2. Quiz Questions Q6. In a relational model, columns are termed as (A) Tuples. (B) Attributes (C) Tables. (D) Attributes Q7. Logical design of database is called (a) Schema (b) Instance (c) database snapshot (d) none of above Q8. Snapshot of data in database at given instant of time is called (a) Schema (b) Instance (c) database snapshot (d) none of above Q9. Primary Key must be (a) NOT NULL (b) Unique (c) Option a or b (d) Option a and b Q10. The primary key is selected from the: A. composite keys. B. super key. C. candidate keys. D. foreign keys.

3. Q.1 ‘AS’ clause is used in SQL for (A) Selection operation. (B) Rename operation. (C) Join operation. (D) Projection operation. Q.2 DML is provided for (A) Description of logical structure of database. (B) Addition of new structures in the database system. (C) Manipulation & processing of database. (D) Definition of physical structure of database system. Q.3 The language used in application programs to request data from the DBMS is referred to as the (A) DML (B) DDL (C) VDL (D) SDL

4. Quiz Questions Q.4 In which constraint type we can apply conditional operators? (A) primary key (B) Unique Constraint (C) Check (D) Foreign key Q.5 To delete a particular column in a relation the command use d is: (A) UPDATE (B) DROP (C) ALTER (D) DELETE

5. Q.6 A primary key is combined with a foreign key creates (A) Parent-Child relation ship between the tables that connect them. (B) Many to many relationship between the tables that c onnect them. (C) Network model between the tables that connect them. (D) None of the above. Q.7 choose the correct syntax to change the datatype of any attribute? a) alter table table_name alter column new datatype b) alter table table_name modify column_name new-datatype c) alter table table_name update column_name new-datatype d) alter table table_name modify column column_name new-datatype

6. Quiz Questions Q.8 choose the correct syntax to change the name of any attribute? a) alter table table_name alter column new_name b) alter table table_name modify column_name new-name c) alter table table_name rename column_name to new_name d) alter table table_name rename column column_namenew_name Q.9 Drop is a) ddl b) dml c) dcl d) svl

7. QUIZ 1) The process of defining one or more subtypes of a supertype and forming Relationships of data? • Specialization • Generalization • Creating discord • Selecting classes 2) Let E1 and E2 be two entities in an E/R diagram with simple single-valued attributes. R1 and R2 are two relationships between E1 and E2, where R1 is one-to-many and R2 is many-to-many. R1 and R2 do not have any attributes of their own. What is the minimum number of tables required to represent this situation in the relational model? • 2 • 3 • 4 • 5

8. 3) A weak entity type • Must have total participation in an identifying relationship • Does not have key attribute • Both a and b • None of the above 4) In the Network data model, relationship between records is implemented using _______. • Keys • Pointers • parent-child relationship • None of these 5) _______ constraint is used to maintain consistency among tuples in two relations. a) key b) domain c) referential-integrity d) entity-integrity

9. 6) The null value of an attribute indicates ______ value. • zero b) unknown c) infinite d) error 7) When there is more than one key in a relation, then each such key is called ______. a) primary b) useful c) multiple d) candidate 8) Foreign key is the one in which the ________ of one relation is referenced in another relation.a) Foreign keyb) Primary keyc) Referencesd) Check constraint

10. Quiz 1Q: You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results? SELECT last_name FROM EMP WHERE last_name LIKE '_A%’; SELECT last_name FROM EMP WHERE last name='*A%’; SELECT last_name FROM EMP WHERE last name ='* _A%’; SELECT last_name FROM EMP WHERE last name LIKE '*a%’; 2Q: To write a query that performs an outer join of tables A and B and returns all rows from B, You need to write Any outer join (B) Left outer join (C) Right outer join (D) Cross join Inner join

11. Q3: If every non-key attribute is functionally dependent on the primary key, then the relation will be in 1NF (B) 2NF (C) 3NF (D) 4NF Q4: Match the following (a) Create      (i) The E-R Model (b) Select     (ii) Relationship Model (c) Rectangle     (iii) DDL (d) Record      (iv) DML Codes :(a) (b) (c) (d) (A) (iii) (iv) (i) (ii) (B) (iv) (iii) (ii) (i) (C) (iv) (iii) (i) (ii) (D) (iii) (iv) (ii) (i) 5Q: Which level of abstraction describes how data are stored in the database Physical level (B) View level (C) Logical level (D) Abstraction level 6Q: SQL command to delete a column from an existing table: Delete column (B) Drop table (C) Delete table (D) Alter table 7Q: An attribute or set of attributes within one relation that matches the candidate key of some (possibly the same) relation: Super Key (B) Candidate Key (C) Primary key (D) Foreign Key

12. Q8: If there exist Lossy decomposition between two tables then the tables may contain? • Multivalued attribute • Partial dependency • Spurious tuples • Transitive dependency Q9: Which of the following statement is true? • A relation is in Third Normal Form then it will be always in BCNF. • A relation is in Second normal form then it is not in first normal form • A relation is in BCNF then it is in second normal form • A relation is in second normal form then it contains partial dependency Q10: To write a query that performs an outer join of tables A and B and returns all rows from B, You need to write a. Any outer join b. Left outer join c. Right outer join d. Cross join e. Inner join

13. Q11: In the INTERSECTION of two sets (set A and Set B). This corresponds to • A OR B • A + B • A AND B • A - B Q12: In relational operations the UNION of two sets (set A and Set B). This corresponds to a. A OR B b. A + B c. A AND B d. A - B 

14. (a) If you were to assign a unique number or code to each album you owned in your record collection, this code would be considered a(n) _____. A) Entity B) Instance C) Associate D) Primary key  (b) If you were collecting and storing information about your music collection, an album would be considered a(n) _____. A) Relation B) Entity C) Instance D) Attribute  (c ) Which level of Abstraction describes how data are stored in the data base ? A. Physical level B. View level C. Abstraction level D. Logical level  (d) The Primary key must be: A) NOT NULL B) unique C) option A and B D) option A or B  (e) The number of attributes a relation consists is called …………. Of relation: A) association B) cardinality C) degree D) domain In data Independence we can Change the schema at one level A. Without having to change the schema at the next lower level B. Without having to change the schema at the next higher level C. Without having to change the schema at the top level D. Without having to change the schema at the bottom level 

15. (a) The attribute AGE is calculated from DATE_OF_BIRTH . The attribute AGE is a) Single valued b) Multi valued c) Composite d) Derived  (b) The attribute name could be structured as a attribute consisting of first name, middle initial, and last name . This type of attribute is called a) Simple attribute b) Composite attribute c) Multivalued attribute d) Derived attribute  (c ) An entity set that does not have sufficient attributes to form a primary key is termed a __________ . a) Strong entity set b) Variant set c) Weak entity set d) Variable set  (d) Which of the following is true ? A) A relation in BCNF is always in 3NF B) A relation in 3NF is always in BCNF C) BCNF and 3NF are same D) A relation in BCNF is not in 3NF  (e) If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form? A. First normal form B. Second normal form C. Third normal form D. Fourth normal form 

16. (a) In relational operations the UNION of two sets (set A and Set B). This corresponds to a. A OR B b. A + B c. A AND B d. A - B  (b) Which of the following SQL statements can calculate and return the absolute value of -33? A. SELECT ABS("-33") Absolute FROM DUAL; B. SELECT ABS('-33') "Absolute" FROM DUAL; C. SELECT ABS(-33) "Absolute" FROM DUAL; D. SELECT ABS(-33), Absolute FROM DUAL;  (c) To write a query that performs an outer join of tables A and B and returns all rows from B, You need to write A. any outer join B. a left outer join C. a cross join D. a right outer join E. an inner join  (d) In the INTERSECTION of two sets (set A and Set B). This corresponds to a. A OR B b. A + B c. A AND B d. A - B