databases Online Quiz - 127

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

Equijoins are also called______ or __________

  1. simple joins

  2. outer joins

  3. inner joins

  4. inner and outer joins

Correct Option: A,C

How many columns are presented after executing this query: SELECT address1||','||address2||','||address2 "Adress" FROM employee;

  1. 1

  2. 2

  3. 3

  4. 0

  5. 4

Correct Option: A
  1. Primary key access

  2. Access via unique index

  3. Table access by ROWID

  4. Full table scan

Correct Option: C

Which of the following can be a valid column name?

  1. Column

  2. 1966_Invoices

  3. Catch_#22

  4. #Invoices

  5. None of the above

Correct Option: C

Which command will delete all data from a table and will not write to the rollback segment?

  1. drop

  2. delete

  3. cascade

  4. truncate

Correct Option: D

The primary key on table EMP is the EMPNO column. Which of the following statements will not use the associated index on EMPNO?

  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

When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?

  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

To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four-table join?

  1. 8

  2. 2

  3. 3

  4. 4


Correct Option: C

An internal LOB is a

  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

The old and new qualifiers can be used in which type of trigger ?

  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?





Correct Option: B

A call statement inside the trigger enables you to call the ?

  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 ?



  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

You have currently installed SQL Server 7.0 Standard Edition SP4 and wish to upgrade to SQL Server 2005. Which versions of SQL Server 2005 can you upgrade to?

  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