SQL (100% Errorless Answers)

OR correct answers Requires at least one expression on either side of this operator to be true in order for data to be returned Intersect correct answers Given two queries, this returns only the rows found by both queries union correct answers Returns the results of two queries without duplica...

CREATE TABLE correct answers Creates a new table INSERT INTO correct answers Adds a new row to a table SELECT correct answers Queries data from a table. Lists the fields that contain data of interest. UPDATE correct answers Edits a row in a table ALTER TABLE correct answers Changes an ex...

data definition language (DDL) correct answers commands to create database objects and commands to define access rights to the objects data manipulation language (DML) correct answers commands to insert, update, delete and retrieve data w/in a the database tables query correct answers for a DB...

What is table ? correct answers The table is a collection of record and its information at a single view. What are different types of statements supported by SQL? correct answers 1. DDL - Used to create tables, views etc 2. DML - These statements are used to manipulate the data in records 3. ...

The SELECT statement is used to select data from a database. The result is stored in a result table, called the result-set. correct answers SELECT column_name,column_name FROM table_name; SELECT * FROM table_name; The SELECT DISTINCT statement is used to return only distinct (different) va...

Which SQL statement is used to extract data from a database? correct answers SELECT With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"? correct answers SELECT * FROM Persons WHERE FirstName='Peter' ...

Select Statement correct answers [ WITH { [ XMLNAMESPACES ,] [ <common_table_expression> ] } ] SELECT select_list [ INTO new_table ] [ FROM table_source ] [ WHERE search_condition ] [ GROUP BY group_by_expression ] [ HAVING search_condition ] [ ORDER BY order_expression [ ASC | ...