Question 1

Equijoins are also called______ or __________

simple joins
outer joins
inner joins
inner and outer joins

Answer

Correct Option: A,C

Question 2

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

technology databases

1
2
3
0
4

Answer

Correct Option: A

Question 3

Which Oracle access method is the fastest way for Oracle to retrieve a single row?

technology databases

Primary key access
Access via unique index
Table access by ROWID
Full table scan

Answer

Correct Option: C

Question 4

Which of the following can be a valid column name?

technology databases

Column
1966_Invoices
Catch_#22
#Invoices
None of the above

Answer

Correct Option: C

Question 5

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

technology databases

drop
delete
cascade
truncate

Answer

Correct Option: D

Question 6

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

technology databases

INSTR
SUBSTRING
SUBSTR
POS

Answer

Correct Option: C

Question 7

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

technology databases

select * from EMP where nvl(EMPNO, '00000') = '59384';
select * from EMP where EMPNO = '59384';
select EMPNO, LASTNAME from EMP where EMPNO = '59384';
select 1 from EMP where EMPNO = '59834';

Answer

Correct Option: A

Question 8

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

technology databases

System tablespace
Users tablespace
Default tablespace for the user
Oracle will give an error
Undefined

Answer

Correct Option: C

Question 9

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;

technology databases

03-JUL-00
10-JUL-00
12-JUL-00
11-JUL-00
17-JUL-00

Answer

Correct Option: E

Question 10

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?

technology databases

8
2
3
4
THERE IS NO SUCH CRITERIA

Answer

Correct Option: C

Question 11

An internal LOB is a

technology databases

A Table
A column that is a primary key
Stored in database
A file , which is pointed from database column

Answer

Correct Option: C

Question 12

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

technology databases

Row level DML trigger
Statement level DML trigger
Row level Application trigger
Statement level Application trigger

Answer

Correct Option: A

Question 13

Which view display indirect dependencies, indenting each dependency?

technology databases

DEPTREE
IDEPTREE
INDENT_TREE
I_DEPT_TREE

Answer

Correct Option: B

Question 14

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

technology databases

Package
Stored Function
Stored Procedure
Another Trigger

Answer

Correct Option: C

Question 15

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

technology databases

VARCHAR2
BOOLEAN
IN
OUT

Answer

Correct Option: D

Question 16

What are different variants of SQL Server 2005?

technology databases

(a) Developer Edition
(b) Express Edition
(c) Enterprise Edition
(d) Integration Edition
(e) Standard Edition
(f) All of the above

Answer

Correct Option: A,B,C,E

Question 17

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?

technology databases

(a) Named Pipes
(b) TCP/IP
(c) Shared Memory
(d) Virtual Interface Adapter
(e) Multiprotocol

Answer

Correct Option: A,B

Question 18

What are the different components of SQL Server 2005?

technology databases

(a) Reporting Services
(b) Integration Services
(c) Analysis Services
(d) Database Engine
(e) Mobile Engine

Answer

Correct Option: A,B,C,D

Question 19

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

technology databases

(a) Data Migration
(b) Improved analytical capabilities
(c) Smaller Data engine
(d) Superior Integration properties

Answer

Correct Option: A,B,D

Question 20

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?

technology databases

(a) SQL Server 2005 Developer Edition
(b) SQL Server 2005 Enterprise Edition
(c) SQL Server 2005 Standard Edition
(d) SQL Server 2005 Express Edition

Answer

Correct Option: B,C

Description: databases Online Quiz - 127
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 127

Find more quizzes from top tags