67 MySQL MCQ Questions in english

Home
Subjects
MySQL

Subjectwise MCQ

English Hindi General Knowledge Mathematics History Geography Science Reasoning Economics Business Computer Government Scheme 1st CM List Biology Invention Environment Science Polity Sports GK JavaScript C And C++HTML and CSS MS Word MS Excel MS PowerPoint Bootstrap Python PHP MySQL

Select Subject

Statewise Prepration

Andaman Nicobar Andhra Pradesh Arunchal Pradesh Assam Bihar Chandigarh Chhatisgarh Dadra & Nagar Haveli and Daman & Diu Delhi Goa Gujarat Haryana Himachal Pradesh Jammu & Kashmir Jharkhand Karnatka Kerala Laddakh Lakshadweep Madhya Pradesh Maharashtra Manipur Meghalaya Mizoram Nagaland Odisha Pondicherry Punjab Rajasthan Sikkim Tamil Nadu Telangana Tripura Uttar Pradesh Uttarakhand West Bengal

Select State

Govt. Examwise MCQ

Group C IAS PCS Lower PCS Railway SSC Bank UKPSC Police Group D FCI LIC CAT MAT GMAT TET CTET CUET B. Ed Bank PO Bank Special Officer

Select Examination

Group C IAS PCS Lower PCS Railway SSC Bank UKPSC Police Group D FCI LIC CAT MAT GMAT TET CTET CUET B. Ed Bank PO Bank Special Officer

67 MySQL MCQ Questions in english हिन्दी

39. Which abstraction level best describes the data that is kept in the database?

A. Physical Level

B. View Level

C. Abstraction Level

D. Logical Level

38. The problem that occurs when one transaction updates a database item and then the transaction fails for some reason is ________.

A. Dirty Read Problem

B. Temporary Modify Problem

C. Temporary Select Problem

D. None of the above

37. Data Warehouse provides

A. Transaction Responsiveness

B. Demand and Supply Responsiveness

C. Storage, Functionality Responsiveness to queries

D. None of the above

36. Which of the following is true?

A. A relation in BCNF is always in 3NF.

B. A relation in 3NF is always in BCNF.

C. BCNF and 3NF are same.

D. A relation in BCNF is not in 3NF

35. Reference integrity has a direct connection to

A. Relation Key

B. Primary Key

C. Unique Key

D. Foreign Key

34. _____ is the process of extracting previously unknown 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

33. Which of the following statements is NOT true for views in SQL?

A. The select statement used in the view definition cannot include the 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

32. In SQL, we may use the command to add a new column to an existing table.

A. MODIFY TABLE

B. EDIT TABLE

C. ALTER TABLE

D. ALTER COLUMNS

31. Relationships between tables are formed in an RDBMS by using

A. Alternate Keys

B. Foreign Keys

C. Candidate Keys

D. Composite Keys

30. BCNF Stands for

A. Binary-Coded Normal Form

B. Boyce - Codd Normal Form

C. Bit Code Normal Form

D. Boyce Codd Natural Form

29. The total grade a student receives should not exceed 100. Here is

A. Integrity constraint

B. Referential constraint

C. Over-defined constraint

D. Feasible constraint

28. The BLOB data type is an acronym for:

A. Binary Large Object

B. Big List Object

C. Binary List Object

D. None of the above

27. Type data abstraction which allows the conceptual representation of data in a database management system is considered as

A. Logical design model

B. Data model

C. Interface model

D. User friendly model

26. A function that permits any type of data to be retrieved from a database is referred to as

A. Interface or Signature

B. User friendly signature

C. Conceptual signature

D. Logical signature

25. Each key in a relational schema that has many keys in a database management system is categorized as

A. Prime key

B. Super key

C. Candidate key

D. Primary key

24. Which command is used to remove a relation from a SQL database?

A. Delete

B. Purge

C. Remove

D. Drop table

23. Insert into instructor values (10211, 'Smith', 'Biology', 66000); What kind of claim is this?

A. Query

B. DML

C. Relational

D. DDL

22. The phrase "attribute" describes a ___________ of a table.

A. Record

B. Column

C. Tuple

D. Key

21. The quantity of attributes and qualities in a relation is referred to as its

A. Cardinality

B. Entity

C. Tuples

D. Degree

20. Which of the following commands deletes a MYSQL database in its entirety?

A. drop entiredb dbname

B. drop database dbname

C. drop db dbname

D. drop dbase dbname

19. Drop-Table cannot be used to drop a table referenced by a

A. Primary Key constraint

B. Sub Key

C. Super Key

D. Foreign Key

18. A function that permits any type of data to be retrieved from a database is referred to as

A. Interface or Signature

B. User friendly signature

C. Conceptual signature

D. Logical signature

17. The type of data abstraction that permits the conceptual representation of data in database management systems is considered as

A. Logical design model

B. Data model

C. Interface model

D. User friendly model

16. The BLOB data type is an acronym for:

A. Binary Large Object

B. Big List Object

C. Binary List Object

D. None of the above

15. The total grade a student receives should not exceed 100. Here is

A. Integrity constraint

B. Referential constraint

C. Over-defined constraint

D. Feasible constraint

14. BCNF is short for

A. Binary Coded Normal Form

B. Boyce - Codd Normal Form

C. Bit Code Normal Form

D. Boyce Codd Natural Form

13. Relationships between tables are formed in an RDBMS by using

A. Alternate Keys

B. Foreign Keys

C. Candidate Keys

D. Composite Keys

12. In SQL, we can use the command to add a new column to a table that already exists.

A. Modify Table

B. Edit Table

C. Alter Table

D. Alter Columns

« Previous
Next »

Showing 29 to 56 of 67 results

Latest Jobs

AIIMS Non Faculty Group A, B & C Recruitment 202 ...

Apr 13, 2024

High Court of Kerala Recruitment

Last Date: Apr 26

Recruitment In Staff Selection Commission

Last Date: Apr 18

SSC

Deputy Collector Recruitment In Tamil Nadu Publi ...

Last Date: Apr 27

TNPSC

Kurnool District Court Jobs Notification for the ...

Last Date: Apr 11

Latest Blogs

Subjectwise MCQ

Statewise Prepration

Govt. Examwise MCQ

67 MySQL MCQ Questions in english हिन्दी

39. Which abstraction level best describes the data that is kept in the database?

38. The problem that occurs when one transaction updates a database item and then the transaction fails for some reason is ________.

37. Data Warehouse provides

36. Which of the following is true?

35. Reference integrity has a direct connection to

34. _____ is the process of extracting previously unknown valid and actionable information from large data to make crucial business and strategic decisions.

33. Which of the following statements is NOT true for views in SQL?

32. In SQL, we may use the command to add a new column to an existing table.

31. Relationships between tables are formed in an RDBMS by using

30. BCNF Stands for

29. The total grade a student receives should not exceed 100. Here is

28. The BLOB data type is an acronym for:

27. Type data abstraction which allows the conceptual representation of data in a database management system is considered as

26. A function that permits any type of data to be retrieved from a database is referred to as

25. Each key in a relational schema that has many keys in a database management system is categorized as

24. Which command is used to remove a relation from a SQL database?

23. Insert into instructor values (10211, 'Smith', 'Biology', 66000); What kind of claim is this?

22. The phrase "attribute" describes a ___________ of a table.

21. The quantity of attributes and qualities in a relation is referred to as its

20. Which of the following commands deletes a MYSQL database in its entirety?

19. Drop-Table cannot be used to drop a table referenced by a

18. A function that permits any type of data to be retrieved from a database is referred to as

17. The type of data abstraction that permits the conceptual representation of data in database management systems is considered as

16. The BLOB data type is an acronym for:

15. The total grade a student receives should not exceed 100. Here is

14. BCNF is short for

13. Relationships between tables are formed in an RDBMS by using

12. In SQL, we can use the command to add a new column to a table that already exists.

Latest Jobs

Latest Blogs

for Latest Updates