0 of 20 questions completed
Questions:
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
0 of 20 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
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