Which best describes an inline view?

Which best describes an inline view? A. a schema object B. a sub query that can contain an ORDER BY clause C. another name for a view that contains group functions D. a sub query that is part of the FROM clause of another query Show Answer

Read More

What are two reasons to create synonyms?

What are two reasons to create synonyms? (Choose two.) A. You have too many tables. B. Your tables names are too long. C. Your tables have difficult names. D. You want to work on your own tables. E. You want to use another schema’s tables. F. You have too many columns in your tables. Explanation:Create […]

Read More

Which statement returns the city address and the number of customers in the cities Los Angeles or San Francisco?

Examine the description of the CUSTOMERS table:The CUSTOMER_ID column is the primary key for the table.Which statement returns the city address and the number of customers in the cities Los Angelesor San Francisco? A. SELECT city_address, COUNT(*) FROM customers WHERE city_address IN ( `Los Angeles’, `San Fransisco’); B. SELECT city_address, COUNT (*) FROMcustomers WHERE city […]

Read More

Which SQL statement will return the ENAME, length of the ENAME, and the numeric position of the letter “a” in

The EMPLOYEES table contains these columns:EMPLOYEE_ID NUMBER(4)ENAME VARCHAR2 (25)JOB_ID VARCHAR2(10)Which SQL statement will return the ENAME, length of the ENAME, and the numeric position ofthe letter “a” in the ENAME column, for those employees whose ENAME ends with a the letter “n”? A. SELECT ENAME, LENGTH(ENAME), INSTR(ENAME, ‘a’) FROM EMPLOYEES WHERE SUBSTR(ENAME, -1, 1) = […]

Read More

What is true about the SQL statement?

The PRODUCTS table has these columns:PRODUCT_ID NUMBER(4)PRODUCT_NAME VARCHAR2(45)PRICE NUMBER(8,2)Evaluate this SQL statement:SELECT *FROM PRODUCTSORDER BY price, product_name;What is true about the SQL statement? A. The results are not sorted. B. The results are sorted numerically. C. The results are sorted alphabetically. D. The results are sorted numerically and then alphabetically. Explanation:the result is sort by […]

Read More

Which is an iSQL*Plus command?

Which is an iSQL*Plus command? A. INSERT B. UPDATE C. SELECT D. DESCRIBE E. DELETE F. RENAME Explanation:The only SQL*Plus command in this list : DESCRIBE.It cannot be used as SQL command. This command returns a description of table name, includingall columns in that table, the datatype for each column and an indication of whether […]

Read More

Which four are valid Oracle constraint types?

Which four are valid Oracle constraint types? (Choose four.) A. CASCADE B. UNIQUE C. NONUNIQUE D. CHECK E. PRIMARY KEY F. CONSTANT G. NOT NULL Explanation:Oracle constraint type is Not Null, Check, Primary Key, Foreign Key and UniqueIncorrect answer:AIs not Oracle constraintCIs not Oracle constraintFIs not Oracle constraint Show Answer

Read More

Which SQL statement do you use?

The EMPLOYEES table contains these columns:EMPLOYEE_ID NUMBER(4)LAST_NAME VARCHAR2 (25)JOB_ID VARCHAR2(10)You want to search for strings that contain ‘SA_’ in the JOB_ID column.Which SQL statement do you use? A. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘%SA\_’ ESCAPE ‘\’; B. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘%SA_’; C. SELECT employee_id, last_name, […]

Read More

Which statement accomplishes this task?

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column.The table is currently empty.Which statement accomplishes this task? A. ALTER TABLE students ADD PRIMARY KEY student_id; B. ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id); C. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id; D. ALTER TABLE students […]

Read More