0

databases Online Quiz - 127

Description: databases Online Quiz - 127
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. simple joins

  2. outer joins

  3. inner joins

  4. inner and outer joins


Correct Option: A,C
  1. Primary key access

  2. Access via unique index

  3. Table access by ROWID

  4. Full table scan


Correct Option: C
  1. Column

  2. 1966_Invoices

  3. Catch_#22

  4. #Invoices

  5. None of the above


Correct Option: C

Which character function can be used to return a specified portion of a character string?

  1. INSTR

  2. SUBSTRING

  3. SUBSTR

  4. POS


Correct Option: C
  1. select * from EMP where nvl(EMPNO, '00000') = '59384';

  2. select * from EMP where EMPNO = '59384';

  3. select EMPNO, LASTNAME from EMP where EMPNO = '59384';

  4. select 1 from EMP where EMPNO = '59834';


Correct Option: A
  1. System tablespace

  2. Users tablespace

  3. Default tablespace for the user

  4. Oracle will give an error

  5. Undefined


Correct Option: C

Assuming today is Monday, 10 July 2000, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;

  1. 03-JUL-00

  2. 10-JUL-00

  3. 12-JUL-00

  4. 11-JUL-00

  5. 17-JUL-00


Correct Option: E
  1. A Table

  2. A column that is a primary key

  3. Stored in database

  4. A file , which is pointed from database column


Correct Option: C
  1. Row level DML trigger

  2. Statement level DML trigger

  3. Row level Application trigger

  4. Statement level Application trigger


Correct Option: A

Which view display indirect dependencies, indenting each dependency?

  1. DEPTREE

  2. IDEPTREE

  3. INDENT_TREE

  4. I_DEPT_TREE


Correct Option: B
  1. Package

  2. Stored Function

  3. Stored Procedure

  4. Another Trigger


Correct Option: C

Which type of argument passes a value from a procedure to calling environment ?

  1. VARCHAR2

  2. BOOLEAN

  3. IN

  4. OUT


Correct Option: D

What are different variants of SQL Server 2005?

  1. (a) Developer Edition

  2. (b) Express Edition

  3. (c) Enterprise Edition

  4. (d) Integration Edition

  5. (e) Standard Edition

  6. (f) All of the above


Correct Option: A,B,C,E

You are planning for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols will you use to achieve this goal?

  1. (a) Named Pipes

  2. (b) TCP/IP

  3. (c) Shared Memory

  4. (d) Virtual Interface Adapter

  5. (e) Multiprotocol


Correct Option: A,B

What are the different components of SQL Server 2005?

  1. (a) Reporting Services

  2. (b) Integration Services

  3. (c) Analysis Services

  4. (d) Database Engine

  5. (e) Mobile Engine


Correct Option: A,B,C,D

SQL Server 2005 has the ability to improve business intelligence. Which features help to achieve this?

  1. (a) Data Migration

  2. (b) Improved analytical capabilities

  3. (c) Smaller Data engine

  4. (d) Superior Integration properties


Correct Option: A,B,D
  1. (a) SQL Server 2005 Developer Edition

  2. (b) SQL Server 2005 Enterprise Edition

  3. (c) SQL Server 2005 Standard Edition

  4. (d) SQL Server 2005 Express Edition


Correct Option: B,C
- Hide questions