Introduction to SQL Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? BETWEEN operator None of these EXISTS operator LIKE operator BETWEEN operator None of these EXISTS operator LIKE operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is the meaning of LIKE '%0%0%' Feature has two 0's in it, at any position Feature has more than two 0's Feature ends with two 0's Feature begins with two 0's Feature has two 0's in it, at any position Feature has more than two 0's Feature ends with two 0's Feature begins with two 0's ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. SINGLE ONLY DISTINCT UNIQUE SINGLE ONLY DISTINCT UNIQUE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes may be created or dropped at any time. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? SUM All of these MAX COUNT SUM All of these MAX COUNT ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS