Home / Vishal Gupta / Programming MCQs Solution
Vishal Gupta updated solution of these Programming language mcqs.
Q. Which of the following is TRUE about TCL?
Q. Select the correct statement.
Q. Which command will remove the records from the table, but not affect the structure of the table?
Q. The table records can be retrieved using which command?
Q. Which of the following statement(s) is/are TRUE about DCL?
Q. Difference between GRAND & REVOKE command is/are?
Q. What is TRUE about SAVEPOINT?
Q. Commands that come under TCL is/are -
Q. Command that comes under DCL is/are -
Q. Select the correct statement
Q. Command that comes under DML is/are –
Q. Which of the following is/are TRUE about DDL command?
Q. Commands that comes under DDL is/are –
Q. The place where the server stores its databases and status files is called “data”?
Q. The maximum value for FLOAT is ___________?
Q. Are “Datetime” and “Timestamp” the same data type?
Q. What is the default format for the data type “Time”?
Q. What is the default format for the data type “Year”?
Q. Which of the following is the correct representation of “float(5,0)”?
Q. Which of the following is the correct representation of “float(4,2)”?
Q. The size of the BIT type is _____ ?
Q. What statement is used to show the definition of an existing database?
Q. Which clause is used to modify the existing field of the table?
Q. Which of the following is not a query clause?
Q. The keyword “MODIFY” is used with which query clause?
Q. Which clause is used to sort the result by one or more columns?
Q. Which clause is used to filter groups?
Q. Which clause is used to group rows by common column values?
Q. Which clause is used to filter the data?
Q. Which clause is used to identify the table?
Q. Which clause is used to determine which column to include in the query sets?
Q. The file created by the server to store the database attributes is _____?
Q. What keyword is used to create a database?
Q. What keyword is the synonym for DATABASE?
Q. Which statement is used to select a database?
Q. What represents an attribute in a relational database?
Q. What is a tuple in a relational database?
Q. How the communication is established with MySQL server?
Q. MySQL is available for free? Is it open source?
Q. What is the data in a MySQL database?
Q. MySQL is a(n) _________ database management system ?
Q. Which command need to execute from "run window" to open a new excel file