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