Title DBMS mcq Set i to 10.pdf ✅

Tribhuvan University Bachelor in computer Application(BCA) Full Mark 60 Course Title: DataBase Management System Pass Mark 24 Semester 4th Time: 3 hour MODEL SET I Group A Attempt all the questions. [101 = 10] Circle (O) the correct answer. i. Database security threats includes loss of (a) Confidentiality (b) Integrity (c) Availability (d) All of the above ii. A database log that is used mainly for security purpose is called (a) Database audit (b) An audit trail (c) History (d) All of the above iii. SQL Authorization mechanism grants privileges on ______? (a) Entire relation (b) Specified attribute (c) Both a and b (d) Specified tuples iv. Privileges that are granted implicitly to all current and future users are called? (a) Private (b) Natural (c) Unnatural (d) Public v. Long form of DBA is (a) None of these (b) Database application (c) Database administrator (d) Database admin vi. DBMS stands for (a) Database Administrator system (b) None of these (c) Database management system (d) Database basic management system vii. A database is a complex type of _______
(a) None of these (b) Manager (c) Data Structure (d) Application viii. In _______ data can be stored in structured manner. (a) CPU (b) Database (c) None of these (d) ALU ix. A property of the entire relation, rather than of the individual tuples, is known as.... (a) Attribute (b) Constant (c) Variable (d) Key Tribhuvan University Bachelor in computer Application(BCA) Full Mark 60 Course Title: DataBase Management System Pass Mark 24 Semester 4th Time: 3 hour MODEL SET II Group A Attempt all the questions. [101 = 10] Circle (O) the correct answer. i. Which of these levels deals with the physical representation of the database on the computer? (a) External level (b) Conceptual level (c) Internal level (d) None of these ii. The ability to change the conceptual schema without affecting the external schemas or application programs is known as (a) Program data independence
(b) Logical data independence (c) Physical data independence (d) Data abstraction iii. Which of these is not a representational data model (a) Entity – relationship model (b) Hierarchical data model (c) Relational data model (d) Network data model iv. Which of these is not a feature of Hierarchical model? (a) Oorganizes the data in tree-like structure (b) Parent node can have any number of child nodes (c) Root node doesnot have any parent (d) Child node can have any number of parent nodes v. Which of these data models is an extension of relational data model (a) Object- oriented data model (b) Object relational data model (c) Semi-structured data model (d) None of these vi. the information about data in a database is called ..... (a) Metadata (b) Hyperdata (c) Tera data (d) None of these vii. Which of these DBMS languages is employed by end users and programmers to manipulate data in the database, (a) Data definition language (b) Data presentation language (c) Data manipulation language (d) Data translation language viii. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record. (a) Candidate key (b) Sub key (c) Super Key (d) Foreign Key ix. The subset of a super key is a candidate ey is a candidate key under what condition? (a) No proper subset is a superkey (b) All subsets are superkeys (c) Subset is a super key (d) Each subset is a super key x. A function that has no partial functional dependencies is in _______ form (a) 3NF (b) 2NF (c) 4NF (d) BCNF
Tribhuvan University Bachelor in computer Application(BCA) Full Mark 60 Course Title: DataBase Management System Pass Mark 24 Semester 4th Time: 3 hour MODEL SET III Group A Attempt all the questions. [101 = 10] Circle (O) the correct answer. I. Triggers are supported in ....... (a) Delete (b) Update (c) Views (d) All of the mentioned II. What are the after triggers? (a) Triggers generated after a particular operation (b) These triggers run after an insert, update or delete on a table. (c) These triggers rrun after an insert, views update or delete on a table (d) All of the mentioned iii. the default extension for an oracle SQL *Plus file is: (a) .txt (b) .pls (c) .ora (d) .sql iv. which of the following is not an oracle supported trigger? (a) BEFORE (b) DURING (c) AFTER (d) INSTEAD OF v. Pepelines can be executed in ......... ways (a) 4 (b) 3 (c) 2 (d) 5 Vi. Database security threats includes loss of: