HSST CS Mock Test #1 : Answers Published

HSST CS Mock Test #1 10 Questions from DBMS Email address * ufaizal29@gmail.com Q.1 In the relational model, cardinality is termed as: *  (A) Number of tuples.  (B) Number of attributes  (C) Number of tables.  (D) Number of constraints. Q.2 Which component of Database storage manager that is responsible For Fetching data from disk storage to main memory ?  a. File manager 1  b. Buffer manager  c. Transaction manager  d. Integrity manager Q.3 Select * from employeeWhat type of statement is this?  a) DML  b) DDL  c) View  d) Integrity constraint Q.4 If every non-key attribute is functionally depedent primary key,  then the relation will be in  a) First normal form  b) Second normal form  c) Third form  d) Fourth normal form Q.5 ....... introduced the relational database rules.  A. Atul kahate  B. James Gossling  C. EF Codd  D. Dennies Rithchie Q.6 In the ____ normal form, a composite attribute is converted to individual attributes.  A. First  B. Second  C. Third  D. Fourth Q.7 Cartesian product in relational algebra is  (A) a Unary operator.  (B) a Binary operator.  (C) a Ternary operator.  (D) not defined. Q.8 Which of the following gives a logical structure of the database graphically ?  a) Entity-relationship diagram  b) Entity diagram  c) Database diagram  d) Architectural representation Q.9 Third normal form is based on the concept of............  a)closure dependency  b)transitive dependency  c)normal dependency  d)functional dependency Q.10 ‘AS’ clause is used in SQL for  (A) Selection operation.  (B) Rename operation.  (C) Join operation.  (D) Projection operation.

Create your own Google Form