infs
Que 40: Which command undo all the updates performed by the SQL in the transaction ?
ROLLBACK
Que 31: Which of the following query finds the names of the sailors who have reserved at least one boat ?
SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid;
With MySQL, how do you select a column named "FirstName" from a table named "Persons"?
SELECT FirstName FROM Persons
Which of the following is illegal
SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL;
The NOT NULL constraint enforces a column to not accept NULL values.
True
The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true
True
In SQL, which of the following is not a data definition language commands
UPDATE
Which MySQL statement is used to update data in a database?
UPDATE
Which SQL statement is used to update data in a database ?
UPDATE
How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
Que 42: The FROM SQL clause is used to
specify what table we are selecting or deleting data FROM
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables
Data Definition Language(DDL)
Que 47: Which of the following SQL commands is used to retrieve data ?
SELECT
Which MySQL statement is used to select data from a database?
SELECT
With MySQL, how do you select all the columns from a table named "Persons"?
SELECT * FROM Persons
With MySQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
SELECT * FROM Persons ORDER BY FirstName DESC
With MySQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?
SELECT * FROM Persons WHERE FirstName LIKE 'a%'
With MySQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
SELECT * FROM Persons WHERE FirstName='Peter'
With MySQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?
SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'
With MySQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?
SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
Que 28: Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79
SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79
Que 30: Find the name of cities with all entries whose temperature is in the range of 71 and 89
SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89;
With MySQL, how can you return the number of records in the "Persons" table?
SELECT COUNT(*) FROM Persons
In SQL, which command is used to SELECT only one copy of each set of duplicable rows
SELECT DISTINCT
Which MySQL statement is used to return only different values?
SELECT DISTINCT
Que 32: Which of the following query finds the name of the sailors who have reserved at least two boats ?
SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid <> r2.bid
Que 41: Which of the SQL statements is correct ?
SELECT Username, Password FROM Users
Find all the cities whose humidity is 89
SELECT city FROM weather WHERE humidity = 89;
Que 27: Find the temperature in increasing order of all cities
SELECT city, temperature FROM weather ORDER BY temperature;
Que 37: Which of the following is not true about creating constraints ?
Constraints are defined using the CREATE CONSTRAINT statement.
Que 34: Which of the following is true about Cartesian Products ?
A Cartesian product is formed when a join condition is omitted.
What is a view
A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are.
In SQL, which command(s) is(are) used to change the storage characteristics of a table
ALTER TABLE
Que 48: Which of the following is NOT a type of SQL constraint ?
ALTERNATE KEY
Which of the following is a SQL aggregate function ?
AVG
Which operator is used to select values within a given range?
BETWEEN
Que 39: Which of the following command makes the updates performed by the transaction permanent in the database ?
COMMIT
Which of the following group functions ignore NULL values ?
COUNT SUM MAX
Which of the following code would create a role named student_admin ?
CREATE ROLE student_admin
Which MySQL statement is used to create a database table called 'Customers'?
CREATE TABLE Customers
Which of the following must be enclosed in double quotes ?
Column Alias
What is MySQL
Cross-platform, open-source and free Developed, distributed, and supported by Oracle Corporation A relational database management system
Which MySQL statement is used to delete data from a database?
DELETE
Which SQL statement is used to delete data FROM a database ?
DELETE
With MySQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?
DELETE FROM Persons WHERE FirstName = 'Peter'
Que 43: Which SQL keyword is used to retrieve only unique values ?
DISTINCT
Which of the following code will successfully delete the table LOCATIONS from the database
DROP TABLE locations
Which of the following is true about a group function ?
Group functions ignore null values
What are the supported types of joins in MySQL?
INNER JOIN, LEFT JOIN, RIGHT JOIN, CROSS JOIN
Which of the following SQL commands can be used to add data to a database table
INSERT
Which MYSQL statement is used to insert new data in a database?
INSERT INTO
With MySQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
INSERT INTO Persons (LastName) VALUES ('Olsen')
With MySQL, how can you insert a new record into the "Persons" table?
INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
Que 45: What operator tests column for the absence of data ?
IS NULL operator
Which of the following is not true about the ALTER TABLE statement ?
It can add a new row
Which of the following is not true about Natural Joins ?
It selects rows from the two tables having different values in the matched columns.
Which operator is used to search for a specified pattern in a column?
LIKE
Which operator performs pattern matching ?
LIKE operator
Which SQL keyword is used to retrieve a maximum value ?
MAX
A command that lets you change one or more fields in a record is
Modify
If a query involves NOT, AND, OR with no parenthesis
NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last
Which MySQL keyword is used to sort the result-set?
ORDER BY
Which SQL keyword is used to sort the result-set ?
ORDER BY
Que 29: Find the name of all cities with their temperature, humidity and countries.
SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city;
Que 35: Which of the following is not true about single-row subqueries ?
Single row subqueries return one row from the outer SELECT statement.
What is the full form of SQL
Structured Query Language
Que 38: Which of the following is not true about database synonyms ?
Synonyms are used for shortening lengthy object names. Synonyms can be created for tables, views, sequences, procedures and other database objects. A synonym is just an alternative name.
Que 44: A subquery can be placed in which of the SQL clause(s) ?
The WHERE clause The FROM clause The HAVING clause
Which of the following is not true about inserting new rows to a table ?
You cannot insert rows with NULL values to a table.
Que 36: Which of the following is true about removing rows from a table ?
You remove existing rows from a table using the DELETE statement
Which of the following is true about removing rows from a table ?
You remove existing rows from a table using the DELETE statement
Which of the following statements allows Deepak to change his database user account password to patel
alter user deepak identified by patel
Which of the following code will delete a view named all_marks_english ?
drop view all_marks_english
