databases Online Quiz - 160 Online Test

Back

databases Online Quiz - 160

Description: databases Online Quiz - 160
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

Start the Quiz

____________ is used to join a table to itself.

technology databases

Selfjoin
Outerjoin
innerjoin
equijoin

A null is the same as zero or a blank space.

technology databases

True
False

What is the output of the following? SELECT ROUND(1111.93412,3) FROM DUAL;

technology databases

1112
1111.93
1111.93412
1111.934

What does the MOD Function do?

technology databases

It divides both the values and gives the quotient.
It multiplies both the values and gives the product.
It divides both the values and gives the remainder.
There is no such function.

Duplicate values are eliminated by which keyword

technology databases

Duplicate
Distinct
Remove
Delete

The two types of subqueries are:

technology databases

Single-row subquery, Double-row subquery
Double-row subquery, Multiple-row subquery
Multiple-row subquery
Single-row subquery and Multiple subquery

Single-row subquery returns:

technology databases

Only one row
Two rows
Zero rows
There is no such subquery

What is the result of the query below? SELECT Stud_name, Rollnum FROM STUDENT WHERE stud_marks=(SELECT MIN (stud_marks) FROM STUDENT GROUPBY Rollnum);

technology databases

It gives the name and marks of all the students.
It does not return anything.
It shows an error saying” INVALID SYNTAX ERROR”
It shows an error saying” Single-row subquery returns more than one row

Which of the following is not a multiple-row operator?

technology databases

Which operator compares a value to every value returned by a subquery?

technology databases

A DML statement is executed when you

technology databases

Add new rows to a table
Modify existing rows of a table
Remove existing rows from a table
All of the above

The right syntax insert a row into a table is

technology databases

Insert to table tablename (….);
Insert into table tablename (….);
Insert into table tablename values (…..);
Any one of the above

Which is the function that records the current date?

technology databases

Date
Sysdate
Current Date
System Date

Limiting the rows in a select statement for a specific condition is done by the clause

technology databases

Distinct
Projection
Where
All of the above

Character values are case insensitive

technology databases

True
False

Arithmetic expressions containing a null value evaluate to null.

technology databases

True
False

Concatenation operator is

technology databases

What are SQL “SELECT” statement capabilities.

technology databases

Projection
Selection
Join
All of the above

To select all the columns from a table EMP, which one of the following is TRUE?

technology databases

Select all columns from EMP;
Select distinct columns from EMP;
Select * from EMP;
All of the above

Select ename from emp where ename =”Scott”; This select statement executes successfully.

technology databases

True
False

- Hide questions

databases Online Quiz - 160

Find more quizzes from top tags