521. ER model includes I.diagram II.attributes III.relationships IV.semantic constraints. Which?

Databases • ER Modeling • UGC NET Paper 2 Computer Science DEC 2013

522. GO BOTTOM then SKIP-3 in 30 records shifts to

Databases • File Handling • UGC NET Paper 2 Computer Science DEC 2013

523. R=ABCDE, F={A→B,B→C,AC→D}. Closures of A and E are

Databases • Functional Dependencies • UGC NET Paper 2 Computer Science DEC 2013

524. Which is false?

Databases • Normalization • UGC NET Paper 2 Computer Science DEC 2013

525. __________ rules limit log volume on volatile failure.

Databases • Recovery • UGC NET Paper 2 Computer Science DEC 2013

526. A Trojan horse is

Databases • Security • UGC NET Paper 2 Computer Science DEC 2013

527. Data integrity control uses _______.

Databases • • UGC NET Paper 2 Computer Science DEC 2013

528. For R(a,b,c,d) with FDs a→c, b→d, the relation is in

Databases • Normalization • UGC NET Paper 2 Computer Science DEC 2013

529. The “PROJECT” operator of relational algebra creates a new table that has always

Databases • Relational algebra • UGC NET Paper 2 Computer Science DEC 2013

530. Given Employee(name,sex,salary,deptname), which SQL finds departments whose male average salary exceeds the overall average?

Databases • SQL aggregation • UGC NET Paper 2 Computer Science DEC 2013

531. Thomas’s write rule is ______.

Databases • Concurrency Control • UGC NET Paper 2 Computer Science DEC 2013

532. Cross-tab displays permit users to view ______ of multidimensional data.

Databases • OLAP & Reporting • UGC NET Paper 2 Computer Science DEC 2013

533. Preemption plus transaction rollback prevents ______.

Databases • Transaction Management • UGC NET Paper 2 Computer Science DEC 2013

534. Views are useful for ______ unwanted information and aggregating relations.

Databases • Views & Materialized Views • UGC NET Paper 2 Computer Science DEC 2013

535. Match: (a) Create (b) Select (c) Rectangle (d) Record — (i) DDL (ii) DML (iii) E-R model (iv) Relational model

Databases • Data Modeling • UGC NET Paper 2 Computer Science DEC 2013

536. Match: (a) one-to-one (b) relationship (c) many-to-many (d) many-to-one — codes below.

Databases • ER Modeling • UGC NET Paper 2 Computer Science DEC 2013

537. constraints ensure values in one relation also appear in another.

Databases • Integrity constraints • UGC NET Paper 2 Computer Science DEC 2013

538. SQL SELECT DISTINCT T.branch_name … T.assets>S.assets AND S.branch_city='Mumbai' finds

Databases • SQL queries • UGC NET Paper 2 Computer Science DEC 2013

539. A fact-less fact table contains ___.

Databases • Data Warehousing • UGC NET Paper 2 Computer Science DEC 2013

540. Which e-business model lets consumers name their own price?

Databases • E-Business • UGC NET Paper 2 Computer Science DEC 2013