DBSkool Header Image Background

Category: SQL_MCQPage 1 of 2

Creating Other Schema Objects

1. Evaluate the following SQL statement: CREATE INDEX upper_name_idx ON product_information(UPPER(product_name)); Which query would use the UPPER_NAME_IDX index? A. SELECT UPPER(product_name) FROM product_information WHERE product_id = 2254; B….

Using DDL Statements to Create & Manage Tables

1. For which two constraints does the Oracle Server implicitly create a unique index? (Choose two.) A. NOT NULL B. PRIMARY KEY C. FOREIGN KEY D. CHECK E….

Manipulating Data

1. Which of the following commands can be rolled back? A. COMMIT B. DELETE C. INSERT D. MERGE E. TRUNCATE F. UPDATE Answer: B, C, D, F 2….

Using the Set Operators

1. Which of these set operators will not sort the rows? (Choose the best answer.) A. INTERSECT B. MINUS C. UNION D. UNION ALL Answer: D 2. Which…

Using Subqueries to Solve Queries

1. Given a multi-row subquery is used in a statement, which operator will match values in the outer query that are less than the highest value returned by…

Displaying Data from Multiple Tables

1. The relationships between tables are defined by what? A. Their query results B. The columns they have in common C. The number of rows they contain D….

Reporting Aggregated Data Using the Group Functions

1.What result is returned by the following statement? SELECT COUNT(*) FROM DUAL; (Choose the best answer.) A. NULL B. 0 C. 1 D. None of the above Answer:C…

Using Conversion Functions & Conditional Expressions

1. What type of conversion is performed by the following statement? SELECT LENGTH(3.14285) FROM DUAL; (Choose the best answer.) A. Explicit conversion B. Implicit conversion C. TO_NUMBER function…

Using Single-Row Functions to Customize Output

1. The following data exists in the PRODUCTS table: PROD ID PROD LIST PRICE 123456, 152525.99 You issue the following query: SQL> SELECT RPAD(ROUND(prod_list_price),10,’*’) FROM products WHERE prod_id…

Restricting & Sorting Data

1. Which two clauses of the SELECT statement facilitate selection and projection? A. SELECT, FROM B. ORDER BY, WHERE C. SELECT, WHERE D. SELECT, ORDER BY Answer: C…