MYSQL MCQ's Set-3
41. A relational database consists of a collection of
A. Table
B. Fields
C. Records
D. Keys
ANS: A
42. Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database ?
A. DML(Data Manipulation Language)
B. DDL(Data Definition Language)
C. Query
D. Relational Schema
ANS: A
43. Create table employee (name varchar ,id integer) What type of statement is this ?
A. DML
B. View
C. DDL
D. Integrity constraint
ANS: C
44. To remove a relation from an SQL database, we use the ______ command.
A. Delete
B. Purge
C. Remove
D. Drop table
ANS: D
45. Insert into instructor values (10211, 'Smith', 'Biology', 66000); What type of statement is this?
A. Query
B. DML
C. Relational
D. DDL
ANS: D
46. Insert into instructor values (10211, 'Smith', 'Biology', 66000); What type of statement is this?
A. Query
B. DML
C. Relational
D. DDL
ANS: B
47. The term attribute refers to a ___________ of a table.
A. Record
B. Column
C. Tuple
D. Key
ANS: B
48. The number of attributes in relation is called as its
A. Cardinality
B. Entity
C. Tuples
D. Degree
ANS: D
49. Which of the following is used to delete an entire MYSQL database?
A. drop entiredb dbname
B. drop database dbname
C. drop db dbname
D. drop dbase dbname
ANS: B
50. Drop Table cannot be used to drop a table referenced by a ______________ constraint.
A. Primary Key
B. Sub Key
C. Super Key
D. Foreign Key
ANS: D
51. Function which causes retrieval of any kind of data from database is considered as
A. Interface or Signature
B. User friendly signature
C. Conceptual signature
D. Logical signature
ANS:B
52. Type data abstraction which allows conceptual representation of data in database management system is considered as
A. Logical design model
B. Data model
C. Interface model
D. User friendly model
ANS:B
53. The data type BLOB stands for:
A. Binary Large Object
B. Big List Object
C. Binary List Object
D. None of the above
ANS:A
54. The student marks should not be greater than 100. This is
A. Integrity constraint
B. Referential constraint
C. Over-defined constraint
D. Feasible constraint
ANS:A
55. BCNF Stands for _________.
A. Binary Coded Normal Form
B. Boyce - Codd Normal Form
C. Bit Code Normal Form
D. Boyce Codd Natural Form
ANS:B
56. In an RDBMS relationship between tables are created by using
A. Alternate Keys
B. Foreign Keys
C. Candidate Keys
D. Composite Keys
ANS:B
57. In order to add a new column to an existing table in SQL, we can use the command
A. MODIFY TABLE
B. EDIT TABLE
C. ALTER TABLE
D. ALTER COLUMNS
ANS:C
58. Which of the following statements is NOT true for views in SQL?
A. Select statement used in the view definition cannot include ORDER BY clause.
B. A view drives its data from the base tables(s)
C. A view is updatable if it has been defined from a single relation
D. A view contains a copy of the data
ANS:D
59. _____ is process of extracting previously non known valid and actionable information from large data to make crucial business and strategic decisions.
A. Data Management
B. Database
C. Data Mining
D. Meta Data
ANS:C
60. Referential integrity is directly related to
A. Relation Key
B. Primary Key
C. Unique Key
D. Foreign Key
ANS:D