0

databases Online Quiz - 232

Description: databases Online Quiz - 232
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. a) GRANT SELECT ON ADD_PLAYER TO PUBLIC;

  2. b) GRANT EXECUTE ON ADD_PLAYER TO PUBLIC;

  3. c) GRANT INSERT ON PLAYER TO PUBLIC;

  4. d) GRANT EXECUTE, INSERT ON ADD_PLAYER TO PUBLIC;

  5. e) REVOKE INSERT ON PLAYER FROM PUBLIC;


Correct Option: B,E

The two types of SQL environment are interactive and embedded?

  1. True

  2. False


Correct Option: A
  1. A table can have up to 10,000 columns.

  2. The size of a table does NOT need to be specified

  3. A table CANNOT be created while users are using the database

  4. The structure of a table CANNOT be modified while the table is online


Correct Option: B

ALTER TABLE inventory ENABLE CONSTRAINT inventory_id_pk; Which statement is true?

  1. The statement will achieve the desired results

  2. The statement will execute, but will NOT enable the PRIMARY KEY constraint.

  3. The statement will execute, but will NOT verify that values in the ID column do NOT violate the constraint.

  4. The statement will return a syntax error.


Correct Option: A

Which three functions can be used to manipulate character, number, or date column values? (Choose three.)

  1. CONCAT

  2. ROUND

  3. TRUNC

  4. RPAD

  5. INSTR


Correct Option: A,D,E
  1. The UNIQUE constraint does not permit a null value for the column.

  2. A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.

  3. The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index

  4. The NOT NULL constraint ensures that null values are not permitted for the column


Correct Option: B,D
  1. A MERGE statement is used to merge the data of one table with data from another.

  2. A MERGE statement replaces the data of one table with that of another.

  3. A MERGE statement can be used to insert new rows into a table.

  4. A MERGE statement can be used to update existing rows in a table.


Correct Option: A,C,D

Which statement describes the ROWID data type?

  1. binary data up to 4 gigabytes

  2. character data up to 4 gigabytes

  3. raw binary data of variable length up to 2 gigabytes

  4. binary data stored in an external file, up to 4 gigabytes

  5. a hexadecimal string representing the unique address of a row in its table


Correct Option: E
  1. CREATE TABLE EMP9$# AS (empid number(2));

  2. CREATE TABLE EMP*123 AS (empid number(2));

  3. CREATE TABLE PACKAGE AS (packid number(2));

  4. CREATE TABLE 1EMP_TEST AS (empid number(2));


Correct Option: A

Which three are true regarding the use of outer joins? (Choose three.)

  1. You cannot use IN operator in a condition that involves an outer join

  2. You use (+) on both sides of the WHERE condition to perform an outer join

  3. You use (*) on both sides of the WHERE condition to perform an outer join

  4. You use an outer join to see only the rows that do not meet the join condition

  5. In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outer join

  6. You cannot link a condition that is involved in an outer join to another condition by using the OR operator.


Correct Option: A,E,F
  1. a schema object

  2. a subquery that can contain an ORDER BY clause

  3. another name for a view that contains group functions

  4. a subquery that is part of the FROM clause of another query


Correct Option: D
  1. JVM Object Noation

  2. Javascript Oreinted Notation

  3. JavaScript Object Notation

  4. Java Object Novation


Correct Option: C
- Hide questions