Tag Archives: Examine

Examine the description of the CUSTOMERS table: (Exhibit) For customers whose income level has a value,

Examine the description of the CUSTOMERS table:For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.Which query should be used? A. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level <> NULLAND due_amount <>… Read More »

Examine the description of the EMPLOYEES table: (Exhibit) Which query is valid?

Examine the description of the EMPLOYEES table:Which query is valid? A. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id; B. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date; C. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id; D. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id; Correct Answer: B

Given: (Exhibit) You want to examine the items list it contains an item for which the variable count

Given:You want to examine the items list it contains an item for which the variable count is below zero.Which code fragment at line 1 accomplish this? A. If (items.stream () .filter (i -> count < 0) . findFirst () ) { B. If (items.stream () .anymatch (i -> count < 0) < 0) ) { C. If (items.stream… Read More »

Examine this command: CREATE UNDO TABLESPACE undotbs01 DATAFILE `undotbs_01.dbf' SIZE 100M AUTOEXTEND

Examine this command:CREATE UNDO TABLESPACE undotbs01DATAFILE `undotbs_01.dbf’SIZE 100MAUTOEXTEND ON;Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.) A. Add the ONLINE clause B. Set UNDO_TABLESPACE to UNDOTBS01 C. Add the NOLOGGING clause D. Add the SEGMENT SPACE MANAGEMENT AUTO clause E. Make certain that the database operates in automatic… Read More »

Examine these commands: (Exhibit) Which two statements are true about the sqlldr execution? (Choose two.)

Examine these commands:Which two statements are true about the sqlldr execution? (Choose two.) A. It uses the database buffer cache to load data B. It overwrites data in EMP with data in EMP.DAT C. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations D. It appends data from EMP.DAT to… Read More »

Examine this command: (Exhibit) Which two statements are true? (Choose two.)

Examine this command:Which two statements are true? (Choose two.) A. The file is renamed and stored in the same location B. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command. C. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command. D. If Oracle Managed Files (OMF) is used, then the file… Read More »

Table ORDER_ITEMScontains columns ORDER_ID, UNIT_PRICEand QUANTITY, of data type NUMBER. Examine these

Table ORDER_ITEMScontains columns ORDER_ID, UNIT_PRICEand QUANTITY, of data type NUMBER.Examine these SQL statements:Statement 1:SELECT MAX(unit_price * quantity) “Maximum Order”FROM order_items;Statement 2:SELECT MAX(unit_price * quantity) “Maximum Order”FROM order_itemsGROUP BY order_id;Which two statements are true? A. Statement 2 returns only one row of output. B. Statement 2 may return multiple rows of output. C. Both the statements give the same… Read More »

View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require subqueries?

View the Exhibit and examine the structure of the PRODUCTS table.Which two tasks require subqueries? (Choose two.) A. Display suppliers whose PROD_LIST_PRICE is less than 1000 B. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE C. Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is… Read More »

Given this enum declaration: (Exhibit) Examine this code: System.out.println(Letter.values()[1]); What

Given this enum declaration:Examine this code:System.out.println(Letter.values()[1]);What code should be written at line 5 for this code to print 200? A. public String toString() { return String.valueOf(ALPHA.v); } B. public String toString() { return String.valueOf(Letter.values()[1]); } C. public String toString() { return String.valueOf(v); } D. String toString() { return “200”; } Correct Answer: C

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE. Examine this command: SQL> CREATE TABLE

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.Examine this command:SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);Which segment or segments, if any, are created as a result of executing the command? A. T1, an index segment for the primary key, a LOB segment, and a lobindex segment B. T1, an index segment for the primary key, and a… Read More »