_____ The wildcard in a WHERE clause is useful when? A. An exact match is necess
ID: 3814571 • Letter: #
Question
_____ The wildcard in a WHERE clause is useful when? A. An exact match is necessary in a SELECT statement. B. An exact match is not possible in a CREATE statement. C. An exact match is necessary in a CREATE statement. D. An exact match is not possible in a SELECT statement. _____ A view is which of the following? A. A virtual table that can be accessed via SQL commands B. A virtual table that cannot be accessed via SQL commands C. A base table that can be accessed via SQL commands D. A base table that cannot be accessed via SQL commands statements? _____ Which of the following is the correct order of keywords for SQL SELECT statements? A. SELECT, WHERE, FROM B. FROM, WHERE, SELECT C. WHERE, FROM, SELECT D. SELECT, FROM, WHERE _____ A subquery in an SQL SELECT statement is enclosed in: A. braces -- {...}. B. CAPITAL LETTERS. C. parameters -- (...). D. brackets -- [...]. _____ The result of a SQL SELECT statement is a(n). A. report B. form C. file D. table _____ Which of the following are the five built-in functions provided by SQL? A. SUM, AVG, MIN, MAX, MULT B. COUNT, SUM, AVG, MAX, MIN C. SUM, AVG, MULT, DIV, MIN D. COUNT, AVG, MIN, MAX, NAME _____ The HAVING clause does which of the following? A. Acts like a WHERE clause but is used for columns rather than groups. B. Acts like a WHERE clause but is used for rows rather than columns. C. Acts like a WHERE clause but is used for groups rather than rows. D. Acts EXACTLY like a WHERE clause. _____ The SQL-92 wildcards are A. asterisk (*); percent sign (%) B. percent sign (%); underscore (_) C. underscore(_); question mark (?) D. question mark (?); asterisk (*)Explanation / Answer
11)
Ans) D. the exacty match is not possible in a select statement.
12)
Ans) A. Virtual table that can be accessed via sql commands.
Reason: We can create view by using the frequently accessing information from the table in the database.Instead of accessing the database table and retriving the data from the table is expensive operation.So to increase the performance we can create the a view by using the Frequently Accessing Information.
13)
Ans) D.Select ,from ,where
14)
Ans) C.paranthesis (..)
A query lies whithin anorther query is called nested query.In that we have to provide the subquery inside the paranthesis.First this query will be executeda and get the data from the database tables.On top of that data the outer query will be eecuted.
15)
Ans) D.table
A table of data will be displayed when we use any sql operations.
16)
Ans) B.Count ,Sum ,Avg,Max,Min
Reason:
There functions are called as Aggregate function.We have to apply these functions on similar type of grouped data.
17)
Ans) C. Acts like a where clause but it is used for groups rather than rows.
18)
Ans) B. Percent sign(%) ,underscore( _ )
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.