Online Test for Mysql
- DDL is used for _______?
Manage the changes made by DML statementsDefining database schemaControl access to data stored in a databaseNone of the above
- 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 statement is used to count number of rows in table?
SELECT COUNT(*) FROM placement_question;SELECT COUNT ALL(*) FROM placement_question;SELECT ROWS(*) FROM placement_question;All the above
- The primary key is selected from the:
composite keys.determinantsforeign keyscandidate keys
- DCL is used to _______?
Manage the changes made by DML statementsInserting, Deleting and Updating dataControl access to data stored in a databaseNone of the above
- Function which causes retrieval of any kind of data from database is considered as
Interface or SignatureUser friendly signatureConceptual signatureLogical signature
- 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
- BCNF Stands for _________.
Binary Coded Normal FormBoyce - Codd Normal FormBit Code Normal FormBoyce Codd Natural Form
- The data type BLOB stands for:
Binary Large ObjectBig List ObjectBinary List ObjectNone of the above
- Which join refers to join records from the write table that have no matching key in the left table are include in the result set:
Left outer joinFull outer joinRight outer joinHalf outer join
Also Exercise
Post Your Question
Social Sharing
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