Question 1

Which character is used to continue a statement in SQL*Plus?

*
/
-
@

Answer

Correct Option: C

Question 2

Assuming today is Monday, 10 July 2000, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;

technology databases

17-JUL-00
11-JUL-00
09-JUL-00
03-JUL-00

Answer

Correct Option: A

Question 3

SELECT NULLIF('testing','testing') FROM DUAL ;

technology databases

testing
True
null
error

Answer

Correct Option: C

Question 4

SELECT NULLIF(NULL,'testing') FROM DUAL ;

technology databases

testing
True
null
error

Answer

Correct Option: D

Question 5

SELECT NVL2(null,'second','third') FROM DUAL ;

technology databases

second
third
null
error

Answer

Correct Option: B

Question 6

SELECT NVL2('first','second','testing') FROM DUAL ;

technology databases

third
null
second
error

Answer

Correct Option: C

Question 7

SELECT NVL(null,'testing') FROM DUAL ;

technology databases

testing
null
False
error

Answer

Correct Option: A

Question 8

select decode('a','b','value-b','d','value-d','a','value-a','NA') result from dual;

technology databases

NA
value-d
value-b
value-a

Answer

Correct Option: D

Question 9

What is true about subqueries ?

technology databases

A single row subquery can retrieve data from only one table.
A SQL query statement cannot display data from table B that is referred to in its subquery,unless table B is included in the main query's FROM clause.
A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause
A single row subquery can retrieve data from more than one table.

Answer

Correct Option: B,D

Question 10

What is true about an equijoin?

technology databases

You can join a maximum of two tables through an equijoin.
You can join a maximum of two columns through an equijoin.
You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.
To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.
You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.

Answer

Correct Option: C

Question 11

What type of object privileges can be granted on a view?

technology databases

DELETE, INSERT,SELECT
DELETE, INSERT, SELECT, UPDATE
ALTER, DELETE, INSERT, SELECT
NONE

Answer

Correct Option: B

Question 12

Two reasons to create table alias :

technology databases

You have too many tables.
You have too many columns in your tables.
You want to work on your own tables.
You want to use another schema's tables.
Your tables have difficult names.
Your tables are too long.

Answer

Correct Option: D,E

Question 13

When the full outer join is used?

technology databases

You want all unmatched data from both tables.
One of the tables has more data than the other.
You want all matched data from both tables.
You want all matched and unmatched data from only one table.

Answer

Correct Option: A

Question 14

Which constraint can only be applied at the column level?

technology databases

Primary Key
Check
Not Null
Unique

Answer

Correct Option: C

Question 15

What is true about WHERE clause ?

technology databases

A WHERE clause can be used to restrict rows only.
A WHERE clause CANNOT be used in a query if the query uses a HAVING clause.
WHERE clause can be used to restrict both rows and groups.
WHere clause filters the columns from the output

Answer

Correct Option: A

Question 16

What is true about the Truncate statement?

technology databases

It is faster than the Delete operation.
You can roll back the deletion of rows after the statement executes.
You must be the owner of the table or have DELETE ANY TABLE system privileges
It releases the storage space used by the table.

Answer

Correct Option: A,C,D

Question 17

WHat is not true about the constaints ?

technology databases

A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.
The UNIQUE constraint does not permit a null value for the column
The NOT NULL constraint ensures that null values are not permitted for the column
The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index

Answer

Correct Option: B,D

Question 18

Once a sequence is created

technology databases

It is automatically used in all INSERT and UPDATE
It is linked to a specific table.
It belongs to a specific schema.
It is automatically available to all users.

Answer

Correct Option: C

Question 19

PRODUCT ======= Product ID Product Description Manufacturer ID MANUFACTURER ============ Manufacturer ID Manufacturer Name Referring to the above table, what type of relationship exists between the Product table and the Manufacturer table?

technology databases

Product - Many,Manufacturer - Many
Product - One or Many,Manufacturer - One or Many
Product - Many,Manufacturer - One
Product - One,Manufacturer - One
Product - One,Manufacturer - Many

Answer

Correct Option: B

Question 20

You are writing a database application to run on your DBMS. You do not want your users to be able to view the underlying table structures. At the same time you want to allow certain update operations. Referring to the above scenario, what structure will you deploy?

technology databases

Cursor table
Table filter
Dynamic procedure
View
Summary table

Answer

Correct Option: D

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

databases Online Quiz - 116

Find more quizzes from top tags