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
1.%a%
2.a%
3._a&
4.None
1.create database structures
2.query database data
3.modify database data
4.All of the above
1.brackets -- [...]
2.parenthesis -- (...)
3.CAPITAL LETTERS
4.braces -- {...}
1.DROP TABLE tablename ;
2.DELETE TABLE tablename ;
3.REMOVE TABLE tablename ;
4.UPDATE TABLE tablename ;
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
1.file
2.report
3.table
4.None
1.to limit the columns displayed
2.for ranges
3.as a wildcard
4.None of these is correct
1.NOT IN only
2.LIKE only
3.IN only
4.IN and NOT IN
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
1.Structured Query Language
2.Structured Query List
3.Simple Query Language
4.All of the above
1.NOT IN only
2.LIKE only
3.IN only
4.Both IN and NOT IN
1.Data types
2.Primary keys
3.Default values
4.All of the above
1.MAX
2.COUNT
3.SUM
4.All of the above
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