Correct Answer : Structured Query Language
Correct Answer : SELECT * FROM Persons WHERE FirstName='FreeTime' AND LastName='Learning'
Correct Answer : SELECT * FROM Persons WHERE LastName BETWEEN 'FreeTime' AND 'Learning'
Correct Answer : SELECT
Correct Answer : UPDATE
Correct Answer : DELETE
Correct Answer : SELECT DISTINCT
Correct Answer : ORDER BY
SELECT * FROM Persons ORDER BY FirstName DESC
SELECT * FROM Persons SORT 'FirstName' DESC
SELECT * FROM Persons SORT BY 'FirstName' DESC
SELECT * FROM Persons ORDER FirstName DESC
Correct Answer : SELECT * FROM Persons ORDER BY FirstName DESC
Correct Answer : INSERT INTO
Correct Answer : 7
Correct Answer : It selects rows from the two tables having different values in the matched columns.
Correct Answer : SELECT FirstName FROM Persons
Correct Answer : SELECT * FROM Persons
Correct Answer : INSERT INTO Persons VALUES ('Ram', 'Raj')
Correct Answer : INSERT INTO Persons (LastName) VALUES ('Ramana')
Correct Answer : Group functions ignore null values.
Correct Answer : select dept_id, count(name) from employees;
Correct Answer : A statement like, DELETE , would cause deletion of the table from the database.
Correct Answer : UPDATE Persons SET LastName='Suresh' WHERE LastName='Ramana'
Correct Answer : SELECT * FROM Persons WHERE FirstName='Reddy'
Correct Answer : SELECT * FROM Persons WHERE FirstName LIKE 'a%'
Correct Answer : address
Correct Answer : VALUES()
Correct Answer : AND
Correct Answer : FLOOR
Correct Answer : CEILING
Correct Answer : DATEDIFF
Correct Answer : Each DML statement is automatically committed.
DELETE FirstName='Reddy' FROM Persons
DELETE FROM Persons WHERE FirstName = 'Reddy'
DELETE ROW FirstName='Reddy' FROM Persons
Correct Answer : DELETE FROM Persons WHERE FirstName = 'Reddy'
Correct Answer : SELECT COUNT(*) FROM Persons
Correct Answer : MAX
Correct Answer : SUM
Correct Answer : JOIN
Correct Answer : INNER JOIN
Correct Answer : LIKE
Correct Answer : DISTINCT
Correct Answer : CREATE TABLE
Correct Answer : Constraints are defined using the CREATE CONSTRAINT statement.
Correct Answer : Database
Correct Answer : All of the above.
Correct Answer : Relational DBMS
Correct Answer : it is a primary key that consists of more than one field that uniquely identifies a record
Correct Answer : ER models waste the database developer's time
Correct Answer : DROP
Correct Answer : COUNT
Correct Answer : used to perform pattern matches
CREATE DATABASE students
CREATE DATABASE students;
IF NOT EXISTS CREATE DATABASE `STUDENTS`;
Correct Answer : IF NOT EXISTS CREATE DATABASE `STUDENTS`;
SELECT `customer name` FROM customers WHERE cat_id = 12 ORDER BY cat_id;
SELECT `customer name` FROM customers ORDER BY zone WHERE cat_id = 12;
SELECT FROM `customers` 'customer name';
SELECT customer name FROM customers;
Correct Answer : SELECT `customer name` FROM customers WHERE cat_id = 12 ORDER BY cat_id;
Correct Answer : limits the row data are returned.
Correct Answer : An exact match is not possible in a SELECT statement.
Correct Answer : Outer join
Correct Answer : They include procedural and SQL statements.
Correct Answer : A way to establish an IF-THEN-ELSE in SQL.
Correct Answer : Both consist of procedural code.
Correct Answer : A virtual table that can be accessed via SQL commands
Correct Answer : LIKE only
Correct Answer : All of the above
Correct Answer : Involves the use of an inner and outer query.
Correct Answer : DROP TABLE CUSTOMER;
Correct Answer : SELECT, FROM, WHERE
Correct Answer : Uses the result of an outer query to determine the processing of an inner query.
Correct Answer : Data Integrity
Correct Answer : parenthesis -- (...) .
Correct Answer : DDL
Correct Answer : COUNT, SUM, AVG, MAX, MIN
SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID​
Correct Answer : Equi-join
Correct Answer : CREATE INDEX ID;
Correct Answer : Hard-coded SQL statements in a program language such as Java.
Correct Answer : Combines the output from multiple queries and must include the same number of columns.
Correct Answer : They have an event, condition, and action.
Correct Answer : all columns of the table are to be returned.
Correct Answer : for ranges.
Correct Answer : has a distinct form that cannot be duplicated by a join.
Correct Answer : percent sign (%); underscore (_)
Correct Answer : question mark (?); asterisk (*)
Correct Answer : use FROM to name the source table(s) and list the columns to be shown after SELECT.
Correct Answer : SQL
Correct Answer : Reduced training costs
SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');
SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
SELECT NAME IN CUSTOMER WHERE STATE = 'V';
Correct Answer : SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
Correct Answer : program-data independence
Correct Answer : Manage the user interface of database application
Correct Answer : Global Database Design
Correct Answer : a managerial part
Correct Answer : Creativity
Correct Answer : Aggregate functions
Correct Answer : quotes
Correct Answer : commas
Correct Answer : primary key, foreign key
Correct Answer : TRIM
Correct Answer : 1