Dbms1 mcq123 - DBMS PDF

Preview

Summary

DBMS...

Description

NAME OF THE STUDENT:ROLL N0:-

Que.No.

1

DIVISION:-

Question What do you mean by one to many relationship between Teacher and Class table? A : One class may have many teachers B : One teacher can have many classes C : Many classes may have many teachers D : Many teachers may have many classes ANS: B

Unit

Marks

Unit1

1

Unit1

1

3

A data dictionary is a repository that manages A : Memory B : Metadata C : Spell Checker D : Data Validator ANS: B

Unit1

1

4

A logical description of some portion of database that is required by a user to perform task is called as A : System View B : User View C : Logical View D : Data View ANS: B

Unit1

1

Unit1

1

6

Which of the follow is not the degree of relationship? A : Single B : Binary C : Ternary D : N-array ANS: A

Unit1

1

7

In an Entity-Relationship diagram “Double Rectangles” represents A : Relationship Set B : Weak Entity Sets C : Derived Attributes D : Multi-valued Attributes ANS: B

Unit1

1

Unit1

1

2

5

8

Which of the following is not a database model A : Network Database Model B : Relational Database Model C : Object Oriented Database Model D : None ANS: D

is a classical approach to database design? A : Left – Right approach B : Right – Left approach C : Top – Down approach D : Bottom – Upapproach ANS: C

A Database Management System (DBMS) is A : Collection of interrelated data B : Collection of programs to access data C : Collection of data describing one particular enterprise D : All of the above ANS: D

Que.No.

Question

Unit

Marks

9

Logical design of database is called A : Database Instance B : Database Snapshot C : Database Schema D : All of the above ANS: C

Unit1

1

10

The attribute that can be divided into other attributes is called A : Simple Attribute B : Composite Attribute C : Multi-valued Attribute D : Derived Attribute ANS: B

Unit1

1

Unit1

1

Unit1

1

Unit1

1

Unit1

1

Unit1

1

unit 1

1

11

12

13

14

15

16

Conceptual design A : Is a documentation technique. B : Needs data volume and processing frequencies to determine the size of the database. C : Involves modelling independent of the DBMS D : Is designing the relational model. ANS: C Data independence means A : Data is defined separately and not included in programs B : Programs are not dependent on the physical attributes of data. C : Programs are not dependent on the logical attributes of data D : Both (B) and (C). ANS: D E-R model uses this symbol to represent weak entity set ? A : Dotted rectangle B : Diamond C : Doubly outlined rectangle D : None of these ANS = C Which database level is closest to the users? A : External B : Internal C :Physical D : Conceptual ANS: A The users who use easy-to-use menu are called A : Sophisticated end users B : Naïve users. C : Stand-alone users. D : Casual end user ANS: B A logical schema A : Is the entire database. B : describe data in terms of relational tables and columns, object-oriented classes, and XML tags. C : Describes how data is actually stored on disk. D : Both (A) and (C) ANS: D

17

Que.No.

18

19

20

21

22

23

24

In E-R Diagram derived attribute are represented by A : Ellipse B : Dashed ellipse C : Rectangle D : Triangle ANS: B Question 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 ANS: C This key that uniquely identifies each record is called : A : Primary Key B : Key Record C : Unique Key D : Field Name ANS: A Which of the following is not Modification of the Database A : Deletion B : Insertion C : Sorting D :Updating ANS: C In a database Table, the each category of information Is called A : Tuple B : Field C : Record D : All Of The Above ANS: B Which of the following in not Outer join? A : Left outer join B : Right outer join C : Full outer join D : All Of The Above ANS: D A command to remove a relation from an SQL database A : Delete table table name B : Drop table table name C : . Erase table tablename D : Alter table table name ANS: B Data Manipulation Language (DML) is not to A : Create information table in the Database B : Insertion of new information into the Database C : Deletion of information in the Database D : Modification of information in the Database ANS: A

Unit1

Unit

1

Marks

Unit2

1

Unit2

1

Unit2

1

Unit2

1

Unit2

1

Unit2

1

Unit2

1

25

26

The natural join is equal to : A : Cartesian Product B : Combination of Union and Cartesian product C : Combination of selection and Cartesian product D : Combination of projection and Cartesian product ANS: D A is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data. A : Procedures B : Triggers C : Functions D : None of the mentioned ANS: B

Que.No.

27

28

29

30

31

Question Which of the following is used to access the database server at the time of executing the program and get the data from the server accordingly? A : Embedded SQL B : Dynamic SQL C : SQL declarations D : SQL data analysis ANS: B The statement in SQL which allows to change the definition of a table is A : Alter B : Update C : Create D : Select ANS: A Which of the following is a valid SQL type? A : CHARACTER B : NUMERIC C : FLOAT D : All of the above ANS: D The full form of DDL is A : Dynamic Data Language B : Detailed Data Language C : Data Definition Language D : Data DerivationLanguage ANS: C To delete a particular column in a relation the command used is: A : UPDATE TABLE B : DELETE COLUMN C : TRUNCATE COLUMN D : ALTER , DROP ANS: D

Unit2

1

Unit2

1

Unit

Marks

Unit2

1

unit 2

1

unit 2

1

unit 2

1

unit 2

1

Unit2

1

A stored procedure in SQL is a 32

A : Block of functions B : Group of Transact-SQL statements compiled into a single execution plan. C : Group of distinct SQL statements D : None of the mentioned ANS: B

33

34

35

Temporary stored procedures are stored in A : Master B : Model C : User specific D : Tempdb ANS: D

database.

The union operation is represented by A :  B: U C: – D:* ANS: B The A : Like Predicate B : Null Predicate C : In Predicate D : Out Predicate ANS: A

Unit2

1

Unit2

1

Unit2

1

is essentially used to search for patterns in target string.

Que.No.

Question

Unit

Marks

36

A relation that has no partial dependencies is in which normal form A : First B : Second C : Third D : BCNF ANS: B

UNIT3 1

37

A functional dependency between two or more non-key attributes is called A : Transitive dependency B : Partial transitive dependency C : Functional dependency D : Partial Functional dependency ANS: A

UNIT3 1

38

39

40

How many rules in “CODD’S RULES” of Relational Model of database systems? A : 11 B : 12 C : 13 D : 14 ANS: B Which of the following is not Unary operation? A : Select B : Project C : Rename D : Union ANS: D In DBMS FD stands for A : Facilitate data B : Functional data C : Facilitate dependency D : Functional dependency ANS: D

UNIT3 1

UNIT3 1

UNIT3 1

41

42

An instance of relational schema R (A, B, C) has distinct values of A including NULL values. Which one of the following is true? A : A is a candidate key B : A is not a candidate key C : A is a primary Key D : Both (A) and (C) ANS: B The following functional dependencies hold for relation R(A, B, C) and S(B, D, E) B —> A, A —>C , the relation R contains 200 tuples and relation S contains 100 tuples. What is maximum number of tuples possibles in natural join R and S ? A : 100 B : 200 C : 300 D : 400 ANS: A

43

A Relational model which allows non-atomic domains is A : nested relational data model B : non-atomic data model C : hierarchical data model D : none of these ANS: A

44

allow us to identify uniquely a tuple in the relation. A : Superkey B : Domain C : Attribute D : Schema ANS: A

Que.No.

45

46

47

48

UNIT3 1

UNIT3 1

.

Question Minimal Superkeys are called A : Schema keys B : Candidate keys C : Domain keys D : Attribute keys ANS: B Which of the following in true regarding Referential Integrity? A : Every primary-key value must match a primary-key value in an associated table B : Every primary-key value must match a foreign-key value in an associated table C : Every foreign-key value must match a primary-key value in an associated table D : Every foreign-key value must match a foreign-key value in an associated table ANS: Domain constraints, functional dependency and referential integrity are special forms of . A : Foreign key B : Primary key C : Assertion D : Referential constraint ANS: C The fastest read/write time and most efficient data storage of any disk array type is: A : RAID-1 B : RAID-2 C : RAID-3 D : RAID-4 ANS: RAID 0

UNIT3 1

UNIT3 1

Unit

Marks

UNIT3 1

UNIT3 1

UNIT3 1

UNIT3 1

49

50

In formal relational model, the set of indivisible values is called A : Range B : Domain C : Relation D : Tuple ANS: B In tuple relational calculus P1 P2 is equivalent to A : ¬ P1 P2 B : P1 P2 C : P1 P2 D : P1 ¬P2 ANS: A Where is metadata stored in MySQL? Options are: A.) In the MySQL database meta B.) In the MySQL database metasql C.) In the MySQL database metadata D.) In the MySQL database mysql ANS = D A relational database consists of a collection of Options are: A.) Keys B.) Records C.) Tables D.) Fields ANS = C Which of the following is not a level of data abstraction? Options are: A.) View Level B.) Physical Level C.) Logical Level D.) Critical Level ANS = D What MySQL property is used to create a surrogate key in MySQL? Options are: A.) IDENTICAL B.) UNIQUE C.) AUTO_INCREMENT D.) SEQUENCE ANS = C ) Which of the following is not an Schema? Options are: A.) Logical Schema B.) Physical Schema C.) Database Schema D.) Critical Schema ANS = D Which of the following is true regarding Null Value? Options are: A.) Null0 ANS = C

How can we get the number of records or rows in a table? A. Using COUNT B. Using NUM C. Using NUMBER D. Both a and c above

UNIT3 1

unit 3

1

Right Answer: A Que.13. Which of the following ways below are the correct way to get the current date? A. SELECT CURTIME(); B. SELECT CURDATE(); C. SLELCT CURRRENT_TIME() D. All of the above Right Answer: D Que.14. USE keyword is used to select a ____________________ A. Table B. Column C. Database D. All of the above Right Answer: C How much storage space does DATETIME require? A. 4 bytes B. 2 bytes C. 8 bytes D. 1 bytes Right Answer: C On executing DELETE command, if you get an error “foreign key constraint” – what does it imply? A. Foreign key not defined B. Table is empty C. Connectivity issue D. Data is present in the other table Right Answer: D How do I find out all databases starting with `test to which I have access to ? A. SHOW DATABASES LIKE `%test%`; B. SHOW DATABASES LIKE `%test; C. SHOW DATABASES LIKE `’test’%’; D. SHOW DATABASES LIKE `%test%’; Right Answer: D 1.) Where is metadata stored in MySQL? Options are: A.) In the MySQL database meta B.) In the MySQL database metasql C.) In the MySQL database metadata D.) In the MySQL database mysql Answer: D 3.) What MySQL property is used to create a surrogate key in MySQL? Options are: A.) IDENTICAL B.) UNIQUE

C.) AUTO_INCREMENT D.) SEQUENCE Answer: C 4.) A relational database consists of a collection of Options are: A.) Keys B.) Records C.) Tables D.) Fields Answer: C 5.) A Database Management System (DBMS) is: Options are: A.) Collection of data describing one particular enterprise B.) Collection of programs to access data C.) All Options are correct D.) Collection of interrelated data Answer: C 6.) Which of the following is not a level of data abstraction? Options are: A.) View Level B.) Physical Level C.) Logical Level D.) Critical Level Answer: D 7.) Disadvantages of File systems to store data is: Options are: A.) Data isolation B.) Data redundancy and inconsistency C.) Difficulty in accessing data D.) All options are correct Answer: D 8.) In an Entity Relationship Diagram Rectangles represents Options are: A.) Tables B.) Attributes C.) Database D.) Entity Sets Answer: D 9.) Which of the following is not a Storage Manager Component? Options are: A.) Transaction Manager B.) Logical Manager C.) File Manager D.) Buffer Manager Answer: B 10.) Data Manipulation Language enables users to Options are: A.) Retrieval of information stored in database B.) Insertion of new information into the database

C.) Deletion of information from the database D.) All the options are correct Answer: D 11.) Which of the following is not an Schema? Options are: A.) Logical Schema B.) Physical Schema C.) Database Schema D.) Critical Schema Answer: D 12.) Which of the following is Database Language? Options are: A.) Data Definition Language B.) Data Manipulation Language C.) Data Query Language D.) All of the options Answer: D 13.) Which of the following in not a function of DBA? Options are: A.) Network Maintenance B.) Schema Definition C.) Authorization for data access D.) Routine Maintenance Answer: A 14.) Which of the following is a Data Model? Options are: A.) Entity Relationship Model B.) Object Based Data Model C.) All of the options are correct D.) Relational Data Model Answer: C 15.) A Database Management System (DBMS) is Options are: A.) Collection of interrelated data B.) Collection of data describing one particular enterprise C.) All of the options D.) Collection of programs to access data Answer: C 16.) Which of the following is not a level of data abstraction? Options are: A.) Physical Level B.) View Level C.) Critical Level D.) Logical Level Answer: C 17.) Disadvantages of File systems to store data is: Options are: A.) Data redundancy and inconsistency B.) Data isolation C.) All of the options

D.) Difficulty in accessing data Answer: C 18.) Which of the following is not a Storage Manager Component? Options are: A.) Transaction Manager B.) Buffer Manager C.) File Manager D.) Logical Manager Answer: D 19.) Data Manipulation Language enables users to Options are: A.) Retrieval of information stored in database B.) Deletion of information from the database C.) All of the above D.) Insertion of new information into the database Answer: C 20.) Which of the following is not an Schema? Options are: A.) Logical Schema B.) Critical Schema C.) Database Schema D.) Physical Schema Answer: B 21.) Which of the following is Database Language? Options are: A.) All of the options B.) Query Language C.) Data Definition Language D.) Data Manipulation Language Answer: A 22.) Which of the following in not a function of DBA? Options are: A.) Authorization for data access B.) Network Maintenance C.) Routine Maintenance D.) Schema Definition Answer: B 23.) Which of the following is a Data Model? Options are: A.) Object-Based data model B.) All of the options C.) Entity-Relationship model D.) Relational data model Answer: B 24.) Column header is refer as Options are: A.) Table B.) Domain C.) Attributes

D.) Relation Answer: C 25.) _______ allow us to identify uniquely a tuple in the relation. Options are: A.) Schema B.) Superkey C.) Domain D.) Attribute Answer: B 26.) Minimal Superkeys are called Options are: A.) Schema keys B.) Attribute keys C.) Candidate keys D.) Domain keys Answer: C 27.) Which of the following is not Modification of the Database Options are: A.) Updating B.) Sorting C.) Deletion D.) Insertion Answer: B 28.) Which of the following in not Outer join? Options are: A.) Left outer join B.) Full outer join C.) All of the options D.) Right outer join Answer: C 29.) Set of premitted values of each attribute is called Options are: A.) Tuple B.) Schema C.) Domain D.) Relation Answer: C 30.) Which of the following is true regarding Null Value? Options are: A.) Null0 Answer: C 31.) Logical design of database is called Options are: A.) All of the options B.) Database Schema C.) Database Instance

D.) Database Snapshot Answer: B 32.) Snapshot of the data in the database at a given instant of time is called Options are: A.) Database Instance B.) All of the options C.) Database Schema D.) Database Snapshot Answer: A 33.) Which of the following is not Unary operation? Options are: A.) Rename B.) Union C.) Select D.) Project Answer: B 34.) Which of the following is not binary operation? Options are: A.) Union B.) Set Difference C.) Cartesian Product D.) Project Answer: D 35.) Which of the following is correct regarding Aggregate functions? Options are: A.) It takes a single value and returns a single value as result B.) It takes a list of values and return a single values as result C.) It takes a list of values and return a list of values as result D.) It takes a single value and returns a list of values as result Answer: B 36.) The Primary key must be Options are: A.) Non Null B.) Unique C.) Option A or B D.) Option A and B Answer: D 37.) A command to remove a relation from an SQL database Options are: A.) Delete table B.) Erase table C.) Alter table D.) Drop table Answer: D 38.) which of the following is not an Aggregate function? Options are: A.) Select B.) Avg C.) Min D.) Max

Answer: A 39.) The attribute that can be divided into other attributes is called Options are: A.) Composite Attribute B.) Derived Attribute C.) Simple Attribute D.) Multi-valued Attribute Answer: A 40.) What is ACID properties of Transactions? Options are: A.) Atomicity, Consistency, Isolation, Database B.) Automatically, Concurrency, Isolation, Durability C.) Atomicity, Consistency, Isolation, Durability D.) Atomicity, Consistency, Inconsistent, Durability Answer: C 41.) If every non-key attribute is functionally dependent on the primary key, the relation will be in Options are: A.) Fourth Formal Form B.) Third Normal Form C.) First Normal Form D.) Second Normal Form Answer: B 42.) Database locking concept is used to solve the problem of Options are: A.) Inconsistent Data B.) All of the options C.) Lost Update D.) Uncommitted Dependency Answer: B 43.) UML is stands for Options are: A.) Universal Modeling Language B.) United Modeling Language C.) Uni Modeling Language D.) Unified Modeling Language Answer: D 44.) Data Manipulation Language (DML) is not to Options are: A.) Insertion of new information into the Database B.) Modific...