20 Questions

Oracle database sql Quiz

1 :-

In your session, the NLS_DATE_FORMAT is DD-MM-YYYY. There are 86400 seconds in a day. Examine this result: DATE ----------- 02-JAN-2020 Which statement returns this?

2 :-

Which two statements are true regarding indexes? (Choose two.)

An Update To A Table Can Result In Updates To Any Or All Of The Table's Indexes. An Update To A Table Can Result In No Updates To Any Of The Table's Indexes. A Unique Index Can Be Altered To Be Non-unique. When A Table Is Dropped And Is Moved To The Recycle Bin All Indexes Built On That Table Are Permanently Dropped. A Table Belonging To One User Cannot Have An Index That Belongs To A Different User

3 :-

Which two statements are true about the SET VERIFY ON command? (Choose two.)

It Displays Values For Variables Used Only In The Where Clause Of A Query. It Displays Values For Variables Created By The Define Command It Can Be Used Only In Sql*plus It Displays Values For Variables Prefixed With &&. It Can Be Used In Sql Developer And Sql*plus.

4 :-

Which two actions can you perform with object privileges? (Choose two.)

Create Roles. Create Foreign Key Constraints That Reference Tables In Other Schemas. Delete Rows From Tables In Any Schema Except Sys. Set Default And Temporary Tablespaces For A User. Execute A Procedure Or Function In Another Schema.

5 :-

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE. You want to display the date of the first Monday after the completion of six months since hiring. The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day of the week.Which query can be used?

6 :-

Examine this SQL statement:

update orders 0

set customer _name=

(select cast _last _name

from customers

where customer_id = 0 customer_id);

Which two are true? (Choose two.)

All Existing Rows In The Orders Table Are Updated. The Subquery Is Executed Before The Update Statement Is Executed. The Subquery Is Not A Correlated Subquery. The Subquery Is Executed For Every Updated Row In The Orders Table. The Update Statement Executes Successfully Even If The Subquery Selects Multiple Rows.

7 :-

Which two are true about granting object privileges on tables, views, and sequences? (Choose two.)

Insert Can Be Granted Only On Tables And Sequences. Delete Can Be Granted On Tables Views And Sequences. Select Can Be Granted On Tables Views And Sequences. Alter Can Be Granted Only On Tables And Sequences. References Can Be Granted Only On Tables.

8 :-

Which two statements are true about TRUNCATE and DELETE? (Choose two.)

Delete Can Use A Where Clause To Determine Which Row(s) Should Be Removed. Truncate Can Use A Where Clause To Determine Which Row(s) Should Be Removed. Truncate Leaves Any Indexes On The Table In An Unusable State. The Result Of A Truncate Can Be Undone By Issuing A Rollback. The Result Of A Delete Can Be Undone By Issuing A Rollback

9 :-

Examine these SQL statements which execute successfully:

create table emp

( emo_no number(2)constraint emp_emp_no_pk primary key ,

ename varchar2(15),

salary number(8,2),

mgr_no number(2));

alter table emp add constraint emp_mgr_fk

foreign key (mgr_no)

references emp ( emp_no)

on delete set null ;

alter table emp

disable constraint emp-emp-no-pk

cascade;

alter table emp

enable constraint emp-emp -no-pk;

Which two statements are true after execution? (Choose two.)

The Primary Key Constraint Will Be Enabled And Immediate The Foreign Key Constraint Will Be Enabled And Deferred. The Primary Key Constraint Will Be Enabled And Deferred The Foreign Key Constraint Will Be Disabled. The Foreign Key Constraint Will Be Enabled And Immediate.

10 :-

Which two statements are true about *_TABLES views? (Choose two.)

11 :-

Which two statements are true about the COUNT function? (Choose two.)

Count(*) Returns The Number Of Rows In A Table Including Duplicate Rows And Rows Containing Nulls In Any Column. It Can Only Be Used For Number Data Types. Count(distinct Inv_amt) Returns The Number Of Rows Excluding Rows Containing Duplicates And Nulls In The Inv_amt Column. Count(inv_amt) Returns The Number Of Rows In A Table Including Rows With Null In The Inv_amt Column A Select Statement Using The Count Function With A Distinct Keyword Cannot Have A Where Clause.

12 :-

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY. Only the EMPLOYEE_ID column is indexed. Rows exist for employees 100 and 200. Examine this statement:

UPDATE EMPLOYEES

SET (JOB_ ID SALARY ) =

(SELECT JOB _ID , SALARY

FROM EMPLOYEES

WHERE EMPLOYEES _ID =200

WHERE EMPLOYEES _ID =100;

Which two statements are true? (Choose two.)

Which Two Statements Are True? (choose Two.) Employee 100 Will Have Job_id Set To The Same Value As The Job_id Of Employee 200 Employee 200 Will Have Job_id Set To The Same Value As The Job_id Of Employee 100. Employees 100 And 200 Will Have The Same Job_id As Before The Update Command. Employee 100 Will Have Salary Set To The Same Value As The Salary Of Employee 200. Employee 200 Will Have Salary Set To The Same Value As The Salary Of Employee 100.

13 :-

Which two are true? (Choose two.)

Concat Joins Two Character Strings Together. Concat Joins Two Or More Character Strings Together. Floor Returns The Largest Positive Integer Less Than Or Equal To A Specified Number. Instr Finds The Offset Within A Character String Starting From Position 0. Instr Finds The Offset Within A String Of A Single Character Only Floor Returns The Largest Integer Less Than Or Equal To A Specified Number.

14 :-

Examine this statement:

SELECT 1 AS ID ‘JOHN’ AS FIRST NAME , NULL AS COMMISION

FROM DUAL

INTERSECT

SELECT 1 ‘JOHN ’ NULL

FROM DUAL

ORDER BY 3;

What is returned upon execution?

An Error 2 Rows 0 Rows 1 Rows

15 :-

Examine the data in the INVOICES table:

INVOICE ID CURRENCY CODE RAISED _DATE

1 EUR 01-JAN-2019

2 USD 01- FEB -2019

3 JPY 31-MAR-2019

CURRENCY _ CODE

JPY

GPB

CAD

EUR

USD

Examine the data in the CURRENCIES table:

A) SELECT * FROM CURRENCIES

WHERE NOT EXISTS (

SELECT NULL FROM INVOICES WHERE CURRENCY-CODE =CURRENCY_CODE);

B) SELECT * FROM CURRENCIES

MINUS

SELECT * FROM INVOICES ;

C) SELECT CURRENCY -CODE FROM CURRENCIES

MINUS

SELECT CURRENCY _CODE FROM INVOICES

D) SELECT CURRENCY _CODE FROM CURRENCIES

INTERSECT

SELECT CURRENCY _ CODE FROM INVOICES ;

Which query returns the currencies in CURRENCIES that are not present in INVOICES?

A B C D

16 :-

Which two statements are true about an Oracle database? (Choose two.)

A Table Can Have Multiple Primary Keys. A Column Definition Can Specify Multiple Data Types. A Table Can Have Multiple Foreign Keys. A Varchar2 Column Without Data Has A Null Value. A Number Column Without Data Has A Zero Value.

17 :-

Examine the description of the PROMOTIONS table:

name null type

promo_id not null number (6)

promo_name not null varchar2(30)

promo_category not null varchar2(30)

promo_cost not null number (10,2)

You want to display the unique promotion costs in each promotion category. Which two queries can be used? (Choose two.)

Select Distinct Promo_category || ' Has ' || Promo_cost As Costs From Promotions Order By 1; Select Distinct Promo_cost || ' In ' || Distinct Promo_category From Promotions Order By 1; Select Distinct Promo_category Promo_cost From Promotions Order By 1; Select Promo_category Distinct Promo_cost From Promotions Order By 2; Select Promo_cost Promo_category From Promotions Order By 1;

18 :-

Which three are true about scalar subquery expressions? (Choose three.)

They Can Be Nested. They Cannot Be Used In The Values Clause Of An Insert Statement. A Scalar Subquery Expression That Returns Zero Rows Evaluates To Zero. They Can Be Used As Default Values For Columns In A Create Table Statement. A Scalar Subquery Expression That Returns Zero Rows Evaluates To Null. They Cannot Be Used In Group By Clauses.

19 :-

Which two are true about the precedence of operators and conditions? (Choose two.)

|| Has A Higher Order Of Precedence Than + (addition). + (addition) Has A Higher Order Of Precedence Than * (multiplication). Not Has A Higher Order Of Precedence Than And And Or In A Condition. And And Or Have The Same Order Of Precedence In A Condition Operators Are Evaluated Before Conditions.

20 :-

Which three statements are true about Structured Query Language (SQL)? (Choose three.)

It Requires That Data Be Contained In Hierarchical Data Storage It Best Supports Relational Databases. It Provides Independence For Logical Data Structures Being Manipulated From The Underlying Physical Data Storage. It Is The Only Language That Can Be Used For Both Relational And Object-oriented Databases. It Guarantees Atomicity Consistency Isolation And Durability (acid) Features. It Is Used To Define Encapsulation And Polymorphism For A Relational Table.

Back

Mock Test Completion Certificate

You scored 0 out of 20 questions.

🏅

For your extraordinary service and contributions to your profession.

We are delighted in providing this certificate to you.

Tips for improving your score:

Make sure to read the questions and answer choices carefully.
Don't try to answer any choices that you don't know. It's better to skip a question.

Back Load More