Which one of the options given below refers to the degree (or arity) of relation in relational database system? (A) Number of attributes of its relation schema (B) Number of tuples stored in the relation (C) Number of entries in the relation (D) Number of distinct domains of its relation schema
Asked in APSC 66 12/ Junior Manager (Electrical / Mechanical / IT/ INSTRUMENTATION) , in Assam Power Generation Corporation Limited (APGCL) (Advt. No. 12/, dtd 25-04-) ELECTRICAL ENGINEERING ME 2023
Show answer
Answer: A. Number of attributes of its relation schema
More APSC Prelims previous year questions questions
- For a database relation R (a, b, c, d) where the domains of a, b, c, d include only atomic values, only the following functional dependencies and those that can be inferred from them hold : a → c, b → d The relation is in (A) first normal form but not in second normal form (B) second normal form but not in third normal form (C) third normal form (D) All of the above
- ______ is a hardware component that is most important for the operation of a database management system. (A) Microphone (B) High speed, large capacity disk to store data (C) High resolution video display (D) Printer
- The DBMS acts as an interface between ______ and ______ of an enterprise-class system. (A) data, DBMS (B) application, SQL (C) database application, database (D) user, software
- Which of the following commands is used to remove a relation from an SQL? (A) Drop table (B) Delete (C) Purge (D) Remove
- Which of the following commands is correct to delete the values in the relation teaches? (A) Delete from teaches; (B) Delete from teaches where Id = 'Null'; (C) Remove table teaches; (D) Drop table teaches;
- Which one of the following statements possibly contains the error? (A) Select * from emp where empid=10003; (B) Select empid from emp where empid=10006; (C) Select empid from emp; (D) Select empid where empid= 1009 and Lastname = 'GELLER';
- In a strict two-phase locking protocol
- Memory management technique in which a system stores and retrieves data from secondary storage for use in main memory is called