SQL TEST

Which is the subset of SQL commands used to manipulate oracle database structures,including tables ?

Which operator performs pattern matching?

In SQL, which commands(s) is used to change a table’s storage characteristics?

A command that lets you change one or more fields in a record is:

The FROM SQL clause is used to

Which SQL keyword is used to retrieve only unique values?

What is a View?

Which of the following is a SQL Aggregate function:

Which of the following are TCL commands?

With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?

With SQL, how can you return the number of not null records in the “Persons” table?

Which SQL keyword is used to sort the result-set?

How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

SQL query to find all the cities whose humidity is 95.

The command to remove rows from a table ‘CUSTOMER’ is __________________

Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.

The following SQL is which type of join: 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?

Which of the following function checks whether the expression is a valid date or not?

Table Employee has 10 records.
It has a non-NULL SALARY column which is also UNIQUE.
The SQL statement
SELECT COUNT(*)FROM Employee WHERE SALARY > ANY(SELECT SALARY FROM EMPLOYEE);

Prints

The SQL Statement

SELECT SUBSTR(abcdefghij’,INSTR(‘123321234’,’2’,3,2),2) FROM DUAL;

Prints