Databases - Upwork

Question: Top N analysis requires _____ and _____.
A
The use of rowed & Only an inline view

B
a GROUP BY clause & Only an inline view

C
an ORDER BY clause & An inline view and an outer query

D
None of these

Note: Not available
1. Report
Question: Which data dictionary view holds information about the column in a view?
A
USER_VIEWS

B
USER_VIEW_COLUMNS

C
USER_TAB_COLUMNS

D
USER_ALL_COLUMNS

Note: Not available
1. Report
Question: Which of the following SELECT statements should be used to extract the year from the system date to display it in the format "2001"?
A
SELECT TO_CHAR(SYSDATE, 'yyyy') FROM dual;

B
SELECT TO_DATE(SYSDATE, 'yyyy') FROM dual;

C
SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;

D
SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;

E
SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;

Note: Not available
1. Report
Question: You want to display the titles of books that meet the following criteria: 1. Purchased before Feb 21, 2002 2. Price is less than $500 or greater than $900 You want to sort the result by the date of purchase, starting with the most recently bought book. Which of the following statements should you use?
A
SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < '21-FEB-2002' ORDER BY purchase_date;

B
SELECT book_title FROM books WHERE price IN (500, 900) AND purchase_date < '21-FEB-2002' ORDER BY purchase date ASC;

C
SELECT book_title FROM books WHERE price < 500 OR > 900 AND purchase_date DESC;

D
SELECT Book_title FROM books WHERE (price < 500 OR price > 900) AND purchase_date < '21-FEB-2002' ORDER BY purchase_date DESC;

Note: Not available
1. Report
Question: Which of the following SQL statements accepts user input for the columns to be displayed, table name, and the WHERE condition?
A
SELECT &1, "&2"FROM &3 WHERE last_name = '&4';

B
SELECT &1, '&2' FROM &3 WHERE '&last_name = '&4'';

C
SELECT &1, &2 FROM &3 WHERE last_name = '&4';

D
SELECT &1, '&2' FROM EMP WHERE last_name = '&4';

Note: Not available
1. Report
Question: Where is the GROUP BY clause statement placed in a SELECT statement that includes a WHERE clause?
A
Immediately after the SELECT clause

B
Before the WHERE clause

C
After the ORDER BY clause

D
After the WHERE clause

Note: Not available
1. Report
Question: Evaluate the SQL statement given below: SELECT ROUND (45.953, -1), TRUNC (45.936, 2) FROM dual; Which of the following values are displayed?
A
46 and 45.93

B
50 and 45.93

C
50 and 45.9

D
45 and 45.93

E
45.95 and 45.93

Note: Not available
1. Report
Question: Which of the following data types stores data outside the Oracle database?
A
UROWID

B
BFILE

C
BLOB

D
NCLOB

E
EXTERNAL

Note: Not available
1. Report
Question: Which of the following statements are correct with regard to NULL values?
A
Only =and !=operator can be used to search for NULL values in a column

B
In an ascending order sort, NULL values appear at the bottom of the result set

C
Both

D
Neither

Note: Not available
1. Report
Question: Which of the following operations cannot be performed using the ALTER TABLE statement?
A
Rename table

B
Rename column

C
Drop column

D
Drop NOT NULL Constraint

Note: Not available
1. Report

First Prev 52 53 54 55 56 Next Last

Question: Top N analysis requires _ and _.

Question: Which data dictionary view holds information about the column in a view?

Question: Which of the following SELECT statements should be used to extract the year from the system date to display it in the format "2001"?

Question: Which of the following SQL statements accepts user input for the columns to be displayed, table name, and the WHERE condition?

Question: Where is the GROUP BY clause statement placed in a SELECT statement that includes a WHERE clause?

Question: Evaluate the SQL statement given below: SELECT ROUND (45.953, -1), TRUNC (45.936, 2) FROM dual; Which of the following values are displayed?

Question: Which of the following data types stores data outside the Oracle database?

Question: Which of the following statements are correct with regard to NULL values?

Question: Which of the following operations cannot be performed using the ALTER TABLE statement?

Question: Top N analysis requires _____ and _____.

Question: Which data dictionary view holds information about the column in a view?

Question: Which of the following SELECT statements should be used to extract the year from the system date to display it in the format "2001"?

Question: Which of the following SQL statements accepts user input for the columns to be displayed, table name, and the WHERE condition?

Question: Where is the GROUP BY clause statement placed in a SELECT statement that includes a WHERE clause?

Question: Evaluate the SQL statement given below: SELECT ROUND (45.953, -1), TRUNC (45.936, 2) FROM dual; Which of the following values are displayed?

Question: Which of the following data types stores data outside the Oracle database?

Question: Which of the following statements are correct with regard to NULL values?

Question: Which of the following operations cannot be performed using the ALTER TABLE statement?

Question: Top N analysis requires _ and _.