Introduction to SQL SQL can be used to: All of these create database structures only. query database data only. modify database data only. All of these create database structures only. query database data only. modify database data only. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query is correct for using comparison operators in SQL? SELECT name, course_name FROM student WHERE age>50 and WHERE age<80; None of these SELECT name, course_name FROM student WHERE age>50 and <80; SELECT name, course_name FROM student WHERE age>50 and age <80; SELECT name, course_name FROM student WHERE age>50 and WHERE age<80; None of these SELECT name, course_name FROM student WHERE age>50 and <80; SELECT name, course_name FROM student WHERE age>50 and age <80; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the original purpose of SQL? To specify the syntax and semantics of SQL data definition language To define the data structures All of these To specify the syntax and semantics of SQL manipulation language To specify the syntax and semantics of SQL data definition language To define the data structures All of these To specify the syntax and semantics of SQL manipulation language ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters." True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? Both of above None Data Manipulation Language(DML) Data Definition Language(DDL) Both of above None Data Manipulation Language(DML) Data Definition Language(DDL) ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS