Online Test for Mysql
- Which command is used to import data form text file in MySQL on MySQL editor?
mysql> source text_file_path;mysql> \. text_file_pathNone of the aboveA and B Both
- What will be the output of this query UPDATE tab_name SET col1 = col1 + 1, col2 = col1;
col1 and col2 have different valuecol1 and col2 have same valuecol2 has original value of col1None of the above
- The problem that occurs when one transaction updates a database item and then the transaction fails for some reason is ________.
Dirty Read ProblemTemporary Modify ProblemTemporary Select ProblemNone of the above
- The data type BLOB stands for:
Binary Large ObjectBig List ObjectBinary List ObjectNone of the above
- Query result can be displayed vertically by terminating the query____?
With \V instead of a semicolonWith \G instead of a semicolonWith \M instead of a semicolonAll the above
- Which of the following is true?
A relation in BCNF is always in 3NF.A relation in 3NF is always in BCNF.BCNF and 3NF are same.A relation in BCNF is not in 3NF
- To remove a relation from an SQL database, we use the ______ command.
DeletePurgeRemoveDrop table
- DDL is used for _______?
Manage the changes made by DML statementsDefining database schemaControl access to data stored in a databaseNone of the above
- BCNF Stands for _________.
Binary Coded Normal FormBoyce - Codd Normal FormBit Code Normal FormBoyce Codd Natural Form
- A relational database consists of a collection of
TableFieldsRecordsKeys
Also Exercise
Post Your Question
Social Sharing
Facebook
Search
Articles
Recently Added Jobs
Rajasthan High Court - Jodhpur Recruitment 2017 for Civil Judges
Last Date: 21 December, 2017
Last Date: 21 December, 2017
WBSEDCL Recruitment - 2017 for Office Executive
Last Date: 16 May, 2017
Last Date: 16 May, 2017
RECRUITMENT OF PROBATIONARY OFFICERS IN STATE BANK OF INDIA
Last Date: 06 March, 2017
Last Date: 06 March, 2017
UPSC Combined Medical Services Examination 2015
Last Date: 10 April, 2015
Last Date: 10 April, 2015
UPSC Engineering Services Examination 2015
Last Date: 10 April, 2015
Last Date: 10 April, 2015