46051. SQL data definition commands make up a(n) ________ .
46052. Which of the following is valid SQL for an Index?
46053. The SQL keyword(s) ________ is used with wildcards.
46054. Which of the following is the correct order of keywords for SQL SELECT statements?
46055. A subquery in an SQL SELECT statement is enclosed in:
46056. The result of a SQL SELECT statement is a(n) ________ .
46057. Which of the following are the five built-in functions provided by SQL?
46058. In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk () means that:
46059. The HAVING clause does which of the following?
46060. The SQL -92 wildcards are ____ and ____ .
46061. To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
46062. The benefits of a standard relational language include which of the following?
46063. Which of the following do you need to consider when you make a table in SQL?
46064. SQL query and modification commands make up a(n) ________ .
46065. When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
46066. The Microsoft Access wildcards are ____ and ____ .
46067. One consistent feature found in the history of Southern India was the growth of small reiognal kingdoms rather than large empires because of?
46068. Which one of the following sorts rows in SQL?
46069. To sort the results of a query use:
46070. To define what columns should be displayed in an SQL SELECT statement:
46071. SQL can be used to:
46072. The SQL statement that queries or reads data from a table is ________ .
46073. The SQL keyword BETWEEN is used:
46074. A subquery in an SQL SELECT statement:
46075. ________ was adopted as a national standard by ANSI in 1992.
46076. SQL is:
46077. The condition in a WHERE clause can refer to only one value.
46078. The ADD command is used to enter one row of data or to add multiple rows as a result of a query.
46079. SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.
46080. The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.
46081. A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.
46082. The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.
46083. There is an equivalent join expression that can be substituted for all subquery expressions.
46084. A dynamic view is one whose contents materialize when referenced.
46085. SQL is a programming language.
46086. SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.
46087. Indexes can usually be created for both primary and secondary keys.
46088. Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.
46089. The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.
46090. SQL is a data sublanguage.
46091. The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.
46092. DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.
46093. The result of every SQL query is a table.
46094. COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.
46095. SUM, AVG, MIN, and MAX can only be used with numeric columns.
46096. Most companies keep at least two versions of any database they are using.
46097. The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.
46098. Indexes may be created or dropped at any time.
46099. The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.
46100. ORDER BY can be combined with the SELECT statements.