071题库含新题20210115

Which two statements will return the names of the three employees with the lowest salaries?

Examine this description of the PRODUCTS table: 

You successfully execute this command:

CREATE TALE new_prices(prod_id NUBER(2),price NUMBER(8,2)); 

Which two statements execute without errors?

You must find the number of employees whose salary is lower than employee 110. 

Which statement fails to do this?

Examine the description of the CUSTOMERS table:

 CUSTOMER Id          CUSTOMER_ NAME

10                            MARK

20                             Mandy

30                             Mary

40                            MARVIN

50                            MARTIN

Which two SELECT statements will return these results: 

CUSTOMER_ NAME

--------------------

Mandy 

Mary

Examine the data in the EMPLOYEES table:

EMPLOYEE ID LAST NAME MONTHLY SATARY MONTHLY COMMISSION PCT

101         Kochhar          24000          <NULL>

102          Ernst               17000            .5

103          Rajs                 21000            .2

104          Lorentz           25000         <NULL>

105          Morris            12000          <NULL >

Which statement will compute the total annual compensation for each employee?

Which three statements are true about an ORDER BY clause?

Which three statements are true about performing DML operations on a view with no Instead of triggers defined?

The SYSDATE function displays the current Oracle Server date as: 

21 -MAY-19

You wish to display the date as:

MONDAY, 21 MAY, 201 9

Which statement will do this?

Which two statements are true about * _ TABLES views?

Which statement will return the last sequence number generated by the EMP_ SEQ sequence?

Which two statements are true about an Oracle database?

You execute these commands successfully:

CREATE GLOBAL TEMPORARY TABLE invoices _ gtt 

( customer idINTEGER,

Invoice_ totalNUMBER (10, 2)

) ON COMMIT PRESERVE ROWS;

INSERT INTO invoices_ gtt VALUES (1, 100); 

COMMIT;

Which two are true?

You own table DEPARTMENTS, referenced by views, indexes, and synonyms. 

Examine this command which executes successfully:

DROP TABLE departments PURGE; 

Which three statements are true?

Which two are true about the USING clause when joining tables?

Examine the data in the PRODUCTS table:

PROD ID PROD NAME PROD LIST CATEGORY ID

101           Plate            10            1

102            Cup            20            1

103            Saucer         20            1

104            Knife            30            1

105            Fork            30            1

Examine these queries:

1. SELECT prod name, prod list

FROM products

WHERE prod 1ist NOT IN(10，20) AND category _id=1;

2. SELECT prod name, | prod _ list

FROM products

WHERE prod list < > ANY (10，20) AND category _id= 1;

3.SELECT prod name, prod _ list

FROM products

WHERE prod_ list <> ALL (10， 20) AND category _ id= 1;

Which queries generate the same output?

Which two are true about self joins?

Examine this description of the EMP table:

Name                Null?                        Type

EMPNO           NOT NULL           NUMBER (4) 

ENAME                                            VARCHAR2 (10)

SAL                                                       NUMBER (7, 2)

DEPTNO                                            NUMBER (2)

You execute this query:

SELECT deptno AS "departments", SUM (sal) AS "salary" 

FROM emp

GROUP | BY 1

HAVING SUM (sal)> 3 000;

What is the result?

Which two queries return the string Hello! we're ready?

Examine the description of the PRODCTS table which contains data: 

Name                      Null?                      Type

----------------------------------------------

PROD ID                 NOT NULL            NUMBER (2) 

PROD NAME                                            VARCHAR2 (20) 

EXPIRYDATE            NOT NULL                   DATE

Which two are true?

Which three items does a direction of a relationship contain?