Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. DISTINCT SINGLE UNIQUE ONLY DISTINCT SINGLE UNIQUE ONLY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes can usually be created for both primary and secondary keys. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement is enclosed in: braces -- {...}. parenthesis -- (...) . CAPITAL LETTERS. brackets -- [...]. braces -- {...}. parenthesis -- (...) . CAPITAL LETTERS. brackets -- [...]. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Most companies keep at least two versions of any database they are using. False True False True ANSWER DOWNLOAD EXAMIANS APP
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 Select the right statement to insert values to the student table. INSERT INTO student VALUES ( INSERT student VALUES ( INSERT VALUES INTO student ( INSERT VALUES ( INSERT INTO student VALUES ( INSERT student VALUES ( INSERT VALUES INTO student ( INSERT VALUES ( ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS