MYsql single file

If you don't specify ASC or DESC after a SQL ORDER BY clause, the following is used by default: A) DESC B) no default value C) first by DESC then by ASC D)ASC

ASC

Which SQL keyword is used to eliminate duplicate fields from the SELECT output? A) UNIQUE B) DISTINCTIVE C) DISTINCT D) DIFFERENT

DISTINCT

what does DBMS stand for? A)Database Management System B)left field system C)Dumb Bull Marketing System D)Doug Brown Marketing System

Database Management System

What does follow after the SQL WHERE clause? a)A list of columns to be selected. B)Definition of the condition to be met for the rows to be returned. C)The name of the table we are selecting from. D) The locate of the table we are selecting from.

Definition of the condition to be met for the rows to be returned.

The SQL BETWEEN operator ... A) Specifies a range to test. B) Specifies that a column is a secondary key. C) Specifies which tables we are selecting from. D) Specifies that a column is a primary key.

Specifies a range to test.

Which is the the operator for the NOT equal to search condition? a)<> B)> C)>= D)=>

<>

What is the correct when we want to specify greater or equal search condition? a)<= B)=> C)=> D)>=

>=

the IN sql keyword.. a)Is used with the DISTINCT SQL keyword only. b)Determines of a table is IN a database. c)Defines the tables we are selecting or deleting data from. d)Determines if a value matches any of the values in a list or a sub-query.

Determines if a value matches any of the values in a list or a sub-query.

RDBMS stands for... a)Relational Database Management System B)Read Database Master System C)Real Database Management System D)Relational Database Masteer System

Relational Database Management System

Which of the following SQL statements selects the string 'Success'? A) SELECT LEFT('Success is all I need.', 15) B)SELECT 'Success' C)SELECT '%Success ' D)SELECT Sucess

SELECT 'Success'

Which SQL statement selects all rows from table called Contest, with column ContestDate having values greater or equal to May 25, 2006? A) SELECT * FROM Contest WHERE ContestDate >= '05/25/2006' B)SELECT * FROM Contest WHERE ContestDate < '05/25/2006' C) SELECT * FROM Contest WHERE ContestDate > '05/25/2006' D) SELECT * FROM Contest HAVING ContestDate >= '05/25/2006'

SELECT * FROM Contest WHERE ContestDate >= '05/25/2006'

Which of the following SQL statements is correct? a)SELECT SALES between '10/12/2005' and '01/01/2006' B)SELECT FROM Sales WHERE Date BETWEEN ('10/12/2005', '01/01/2006') C)SELECT * FROM Sales WHERE Date BETWEEN '10/12/2005' AND '01/01/2006' D)SELECT FROM Sales WHERE Date BETWEEN '10/12/2005' AND '01/01/2006'

SELECT * FROM Sales WHERE Date BETWEEN '10/12/2005' AND '01/01/2006'

Which of the following SQL statements has correct syntax? a)SELECT FROM Table1 WHERE Column1 => 10 B) SELECT * FROM Table1 WHERE Column1 >= 10 C) SELECT * FROM Table1 WHERE Column1 = = 10 D)SELECT * FROM Table1 WHERE Column1 => 10

SELECT * FROM Table1 WHERE Column1 >= 10

Which of the following statements gets the total value of the column 'Price' in the 'Sales' table? a)SELECT ADD(Price) FROM Sales B)SELECT SUM(Price) FROM Sales C)SELECT SUM(Price) WHERE Sales D)SELECT TOTAL(Price) WHERE Sales

SELECT SUM(Price) FROM Sales

Which of the following SQL statements is correct? a)SELECT Username, Password FROM Users B)SELECT Username, Password WHERE Username = 'user1' C)SELECT Username AND Password FROM Users D)SELECT Username, Password FROM Users HAVING Username = 'user1'

SELECT Username, Password FROM Users

What does the following SQL statement do: SELECT Customer, COUNT(Order) FROM Sales GROUP BY Customer HAVING COUNT(Order) >5 ; a)Selects all Customers from the Sales table B)Will not execute C)Selects the total number of orders from the Sales table, if this number is less than 5 D)Selects all customers from table Sales that have made more than 5 orders.

Selects all customers from table Sales that have made more than 5 orders.

What does the FROM SQL keyword specify? a)The FROM SQL keyword specifies the tables B)The FROM SQL keyword specifies a search condition. C)The FROM SQL keyword specifies a column list D) The FROM SQL keyword specifies the physical location of the database

The FROM SQL keyword specifies the tables

What does the HAVING clause do? a)The HAVING keyword specifies a search condition for an aggregate. B)The HAVING keyword is used to select distinct values. C)The HAVING keyword is used to show a relationship between fields in a table D)The HAVING keyword specifies a search condition for a specific record

The HAVING keyword specifies a search condition for an aggregate.

which of the following is a sql aggregate function? a)min b)right c)cast d)left

min

What is the difference between the WHERE and HAVING SQL clauses? a)There is no HAVING clause. b)The WHERE and the HAVING clauses are identical c)The HAVING SQL clause condition(s) is applied to all rows in the result set before the WHERE clause is applied (if present). The WHERE clause is used only with SELECT SQL statements and specifies a search condition for an aggregate or a group. d) The WHERE SQL clause condition(s) is applied to all rows in the result set before the HAVING clause is applied (if present). The HAVING clause is used only with SELECT SQL statements and specifies a search condition for an aggregate or a group.

The WHERE SQL clause condition(s) is applied to all rows in the result set before the HAVING clause is applied (if present). The HAVING clause is used only with SELECT SQL statements and specifies a search condition for an aggregate or a group.

What will be the result of the following SQL statement: SELECT * FROM Table1 where Column1 > 10 a)The SQL statement will generate an error. B)The result will be empty data set. C)The result will be all rows from Table1 which have Column1 values greater than 10. D)The result will be all rows having a row number > 10

The result will be all rows from Table1 which have Column1 values greater than 10.

What is the ABS SQL function used for? a)To return the absolute average value of a numeric expression. B)To return the absolute maximum value of a numeric expression. C)To return the absolute minimum value of a numeric expression. D)To return the absolute positive value of a numeric expression.

To return the absolute positive value of a numeric expression.

The AVG SQL function returns the ... A) maximum value from a column B) the sum of values in a column C) median of the values in a group D)average of the values in a group

average of the values in a group

Which SQL functions is used to count the number of rows in a SQL query? a)number() B)cardinal() C)count() D)sum()

count()

What will be the result of the following SQL statement: SELECT LEFT('Have a nice day.', 4) A)produce an error B) have C) nice D)day

have

normalization is.... a) removing neither ambiguity or redundancy b)removing ambiguity and redundancy c)removing redundancy only d)removing ambiguity only

removing ambiguity and redundancy

The table rows are also known as... a)attributes B)tuples C)relations D)fields

tuples

order there in mySQL order and tell me what the third clause is a) group by b) from c) select d) where

where

which SQL keyword is used to specify conditional search? a)search b)find c)where d)select

where

can you use both select and where sql clauses in one sql statement a) no b) yes

yes