0

databases Online Quiz - 57

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

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;

  3. GRANT QUERY ON dept TO ALL_USERS;

  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

Which SQL statement returns a numeric value?

  1. SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;

  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

Which object privileges can be granted on a view?

  1. none

  2. DELETE, INSERT,SELECT

  3. ALTER, DELETE, INSERT, SELECT

  4. DELETE, INSERT, SELECT, UPDATE


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

To maximize session performance by filter it should be

  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 following transformation is passive and connected?

  1. Aggregator

  2. Expression

  3. Joiner

  4. Filter


Correct Option: B
  1. Stored procedure, Look up

  2. Stored procedure, filter

  3. Look up , joiner

  4. Filter, Expression


Correct Option: A

Which of the following task can be made reusable?

  1. Session

  2. Command

  3. Email

  4. All of the above


Correct Option: D
- Hide questions