databases Online Quiz - 57

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

You want to use SQL*Plus to connect to the oracle database. Which of the following choices does not indicate a component you must specify when logging into the oracle?

  1. The SQL*Plus Keyword.

  2. The username

  3. The password

  4. The database name

Correct Option: D

Evaluate the SQL statement: SELECT LPAD (salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?

  1. 17000.00

  2. 17000*****

  3. ****170.00

  4. **17000.00

  5. an error statement

Correct Option: C
  1. Convert any date literal to a date

  2. Convert any numeric literal to a date

  3. Convert any character literal to a date

  4. Convert any date to a character literal

  5. Format ’10-JAN-99’ to ‘January 10 1999’

Correct Option: C
  1. select

  2. delete

  3. execute

  4. alter table

  5. create table

Correct Option: E
  1. String

  2. Character

  3. Integer

  4. Calander

  5. Numeric

  6. Translation

Correct Option: B,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: A,D
  1. GRANT select ON dept TO ALL_USERS;

  2. GRANT select ON dept TO ALL;


  4. GRANT select ON dept TO PUBLIC;

Correct Option: D
  1. Unique

  2. Not null

  3. Check

  4. Primary key

  5. Foreign key

Correct Option: B

Which best describes an inline view?

  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. no privileges

  2. only the SELECT privilege

  3. only the CONNECT privilege

  4. all the privileges of a default user

Correct Option: A

Which is iSQL*Plus commands?

  1. Insert

  2. Update

  3. Select

  4. Describe

  5. Delete

  6. Rename

Correct Option: D

  2. SELECT ROUND(hire_date)FROM EMP;

  3. SELECT sysdate-hire_date FROM EMP;

  4. SELECT TO_NUMBER(hire_date + 7)FROM EMP;

Correct Option: C
  1. none




Correct Option: D
  1. the use of rowed

  2. a GROUP BY clause

  3. an ORDER BY clause

  4. only an inline view

  5. an inline view and an outer query

Correct Option: C,E
  1. In the database

  2. using a source qualifier transformation

  3. using a joiner transformation

  4. his cannot be done in Power Center 8.x

Correct Option: B
  1. Near to source

  2. Near to target

  3. Can be placed anywhere

  4. (i)Session performance is not affected

Correct Option: A

Which of the below transformation can be used as connected and unconnected both way?

  1. Stored procedure, Look up

  2. Stored procedure, filter

  3. Look up , joiner

  4. Filter, Expression

Correct Option: A
  1. Session

  2. Command

  3. Email

  4. All of the above

Correct Option: D
- Hide questions