Online Test for Mysql
- TCL is used for _______?
Manage the changes made by DML statementsDefining database schemaControl access to data stored in a databaseNone of the above
- What is IGNORE keyword in MySQL?
Ignores Primary key or Unique key violations and continues processing with the next rowIgnores Primary key or Unique key violations and leaves any remaining rows unprocessed.Do not ignores Primary key or Unique key violationsNone of 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
- DML is used for _______?
Control access to data stored in a databaseDefining database schemaInserting, Deleting and Updating dataNone of the above
- Which statement is used to find out what databases currently exist on the server?
SHOW DATABASESHOW DATABASESSHOW ALL DATABASESAll the above
- Create table employee (name varchar ,id integer) What type of statement is this ?
DMLViewDDLIntegrity constraint
- Which statement is used to connect with mysql server?
mysql -h host_name -u user_name -p passwordmysql -u user_name -p password -h host_namemysql -p password -u user_name -h host_nameAll the above
- Which of the following is used to delete an entire MYSQL database?
drop entiredb dbnamedrop database dbnamedrop db dbnamedrop dbase dbname
- The number of attributes in relation is called as its
CardinalityEntityTuplesDegree
- Storing same data in many places is called.
IterationConcurrencyRedundancyEnumeration
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