What are the results of the following queries if col is an integer col – McqOptions

MCQOPTIONS

1.	What are the results of the following queries if col is an integer column?1. SELECT * FROM student WHERE id = '6';2. SELECT * FROM student WHERE id = 6;
A.	1 is an error
B.	2 is an error
C.	same
D.	different
E.	None of these
Answer» D. different

Discussion

No Comment Found

Related MCQs

Which of the following WHERE clauses is faster?1. WHERE col * 3 < 92. WHERE col < 9 / 3
What are the results of the following queries if col is an integer column?1. SELECT * FROM student WHERE id = '6';2. SELECT * FROM student WHERE id = 6;
Find the errorCREATE TABLE Employee (Employee_id SMALLINT, name VARCHAR, LAST VARCHAR, Bith_date DATE CONSTRAINTS pk_Employee PRIMARY KEY (Employee_id)); INSERT INTO Employee VALUES(Employee_id, name, LAST, Birth_date) (1, s , p , 24-1991-01);
Find the error?CREATE TABLE Employee( Employee_id SMALLINT, name VARCHAR, LAST VARCHAR CONSTRAINTS pk_Employee PRIMARY KEY (Employee_id)); INSERT INTO Employee VALUES( Employee_id, name, LAST) (1, s , p ); INSERT INTO person ( Employee_id, name, LAST) VALUES(1, s , p );
Find the error
Which of the following are the valid database datatypes in Mysql?
To perform analysis of key values by the server, the statement used is __________.
What are the results of the following queries if col is an integer column?
Which of the following WHERE clauses is faster?