0

databases Online Quiz - 111

Description: databases Online Quiz - 111
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

What is true of using group functions on columns that contain NULL Values

  1. Group functions on columns ignore NULL values.

  2. Group functions on columns returning dates include NULL values

  3. Group functions on columns returning numbers include NULL values.

  4. Group functions on columns cannot be accurately used on columns that contain NULL values.


Correct Option: A

You cannot modify data in a view if it contains: Group functions such as SUM, MIN, MAX, AVG, … A GROUP BY clause. The DISTINCT keyword. Columns defined by expressions (i.e, SAL * 12). The ROWNUM pseudo column.

  1. True

  2. False


Correct Option: B

Which table should you query to determine when your procedure was last compiled?

  1. USER_OBJECTS

  2. USER_PROCEDURES

  3. USER_PROCS

  4. USER_PLSQL_UNITS


Correct Option: A

Which of the following syntax is correct for creating a proc

  1. CREATE OR REPLACE PROCEDURE <> as

  2. CREATE OR REPLACE PROCEDURE <>(Parameter list) as

  3. CREATE OR REPLACE PROCEDURE <> is

  4. All of the above


Correct Option: D
  1. When a parameter is passed as an IN variable it is passed by reference

  2. When variables are passed in OUT or INOUT mode it is pass by value

  3. The NOCOPY clause tells to PL/SQL engine to pass the variable by reference

  4. All of the above


Correct Option: D
  1. Use the DBMS_MANAGE_LOB.MIGRATE procedure

  2. Use the UTL_MANAGE_LOB.MIGRATE procedure.

  3. Use the ALTER TABLE command

  4. You cannot migrate from a LONG to a LOB date type for a column


Correct Option: C
  1. FOR EACH ROW trigger on the EMP table.

  2. Statement-level trigger on the EMP table.

  3. FOR EACH ROW trigger on the AUDIT_TABLE table.

  4. Statement-level trigger on the AUDIT_TABLE table.


Correct Option: A
  1. The tablespace must be online

  2. The tablespace must not contain any active rollback segments

  3. he tablespace must not be involved in an open backup

  4. All of the above


Correct Option: D
  1. The Default tablespace

  2. The temp tablespace

  3. The SYSTEM tablespace

  4. None of the above


Correct Option: C
  1. in the INTO clause of an INSERT statement

  2. in the GROUP BY clause of a SELECT statement

  3. in the VALUES clause of an INSERT statement

  4. in the ORDER BY clause of a SELECT statement


Correct Option: A
  1. to move data from one data source to another

  2. powerful ETL tool

  3. To design various kind of reports

  4. to provide business information to a wider audience within an organization


Correct Option: A,B,D
  1. Selects the total number of orders from the Sales table, if this number is greater than 5

  2. Selects all customers from table Sales that have made more than 5 orders.

  3. Selects all Customers from the Sales table

  4. None of the above


Correct Option: B

Which of the following SQL statements is correct?

  1. TRUNCATE Sales TABLE

  2. TRUNCATE * FROM TABLE Sales

  3. TRUNCATE TABLE Sales

  4. All the above


Correct Option: C

What is a stored procedure?

  1. A process for data export/import.

  2. A set of SQL statements stored and executed as a single entity.

  3. A process to convert tables.

  4. Data stored in a database.


Correct Option: B
- Hide questions