Mysql/MY SQL Basic Sample Test 01 Sample Test,Sample questions

Question:
According to the SQL-92 standard the asterisk (*) means in Select statements 

1.all columns of the table are to be returned

2.all records meeting the full criteria are to be returned

3. all records with even partial criteria met are to be returned

4.None

Posted Date:-2019-06-12 02:10:01


Question:
How to select all data from student table starting the name from letter a?

1.%a%

2.a%

3._a&

4.None

Posted Date:-2019-06-12 02:26:10


Question:
SQL can be used to

1.create database structures

2.query database data

3.modify database data

4.All of the above

Posted Date:-2019-06-12 02:14:21


Question:
sub-query in an SQL SELECT statement is enclosed in

1.brackets -- [...]

2.parenthesis -- (...)

3.CAPITAL LETTERS

4.braces -- {...}

Posted Date:-2019-06-12 02:07:04


Question:
The command to delete a table from a database 

1.DROP TABLE tablename ;

2.DELETE TABLE tablename ;

3.REMOVE TABLE tablename ;

4.UPDATE TABLE tablename ;

Posted Date:-2019-06-12 02:04:47


Question:
The HAVING clause does which of the following?

1.Acts EXACTLY like a WHERE clause

2.Acts like a WHERE clause but is used for columns rather than groups

3.Acts like a WHERE clause but is used for groups rather than rows

4.Acts like a WHERE clause but is used for rows rather than columns

Posted Date:-2019-06-12 02:11:28


Question:
The result of a SQL SELECT statement is a _______

1.file

2.report

3.table

4.None

Posted Date:-2019-06-12 02:08:25


Question:
The SQL keyword BETWEEN is used 

1.to limit the columns displayed

2.for ranges

3.as a wildcard

4.None of these is correct

Posted Date:-2019-06-12 02:15:41


Question:
The SQL keyword(s) ________ is used with wildcards

1.NOT IN only

2.LIKE only

3.IN only

4.IN and NOT IN

Posted Date:-2019-06-12 02:06:07


Question:
The wildcard in a WHERE clause is useful when?

1.An exact match is necessary in a CREATE statement

2. An exact match is necessary in a SELECT statement

3.An exact match is not possible in a SELECT statement

4.An exact match is not possible in a CREATE statement

Posted Date:-2019-06-12 02:03:14


Question:
What is the full form of SQL?

1.Structured Query Language

2.Structured Query List

3.Simple Query Language

4.All of the above

Posted Date:-2019-06-12 02:27:12


Question:
When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s)

1.NOT IN only

2.LIKE only

3.IN only

4.Both IN and NOT IN

Posted Date:-2019-06-12 02:13:28


Question:
Which of the following do you need to consider when you make a table in SQL?

1.Data types

2.Primary keys

3.Default values

4.All of the above

Posted Date:-2019-06-12 02:12:32


Question:
Which of the following group functions ignore NULL values?

1.MAX

2.COUNT

3.SUM

4.All of the above

Posted Date:-2019-06-12 02:28:04


Question:
Which of the following statement is correct for using comparison operators in SQL?

1.SELECT * FROM user WHERE id>50 and id <80

2.SELECT * FROM user WHERE id>50 and <80

3.SELECT * FROM user WHERE id>50 and where id <80

4.SELECT * FROM user WHERE id>50, where id <80

Posted Date:-2019-06-12 02:18:34


More MCQS

  1. Function Sample Test
  2. MY SQL Basic Sample Test
  3. MY SQL Basic Sample Test 01
  4. MY SQL Basic Sample Test 02
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!