Oracle SQL 9i, Databases

Question: Which of the following substitution variables should be used to reuse the variable value without prompting the user each time?
A
&

B
ACCEPT

C
PROMPT

D
&&

Note: Not available
1. Report
Question: Which of the following constitute the correct guidelines for naming database tables?
A
Must begin with either a number or letter

B
Must be 1-30 characters long

C
Should not be an Oracle Server reserved word

D
Must contain only A-Z, a-z, 0-9, _,*, and #

E
Must contain only A-Z, a-z, 0-9, _, $, and #

F
Must begin with a letter

Note: Not available
1. Report
Question: Which of the following are DML statements?
A
COMMIT

B
MERGE

C
UPDATE

D
DELETE

E
CREATE

F
DROP

Note: Not available
1. Report
Question: An outer join is used when:
A
The tables being joined have NOT NULL columns

B
The tables being joined have only matched data.

C
The columns being joined have NULL values

D
The tables being joined have only unmatched data

E
The tables being joined have both matched and unmatched data

Note: Not available
1. Report
Question: Which of the following components are required to run iSQL*plus on PC?
A
SQL*PLUS installed on the PC

B
HTTP Server

C
Oracle net on PC

D
iSQL*PLUS Server

Note: Not available
1. Report
Question: Which of the following constitute the attributes of /SQL*Plus?
A
/SQL*Plus commands cannot be abbreviated

B
/SQL*Plus commands are accessed from a browser

C
/SQL*Plus commands are used to manipulate data in tables

D
/SQL*Plus commands manipulate table definitions in the database

E
/SQL*Plus is the Oracle proprietary interface for executing SQL statements

Note: Not available
1. Report
Question: Which component is a literal in the following select statement? Select 'Emp name :'||ename from emp where deptno=20;
A
ename

B
20

C
Emp name:

D
||

Note: Not available
1. Report
Question: Which of the following statements is a complete transaction?
A
DELETE employees;

B
DESCRIBE employees;

C
ROLLBACK TO SAVEPOINT C;

D
GRANT SELECT ON employees TO SCOTT;

E
ALTER TABLE employees SET UNUSED COLUMN sal;

Note: Not available
1. Report
Question: Which of the following tasks can be performed by using the TO_CHAR function?
A
Convert '10'to 10

B
Convert 10 to '10'

C
Convert 'TEN' to 10

D
Convert a date to a character expression

E
Convert a character expression to a date

Note: Not available
1. Report
Question: What kinds of commands can you enter at the command prompt in 9i Sql Plus?
A
PL/SQL Blocks

B
SQL*Plus commands

C
Security commands

D
SQL commands

Note: Not available
1. Report

First Prev 1 2 3 Next Last

Question: Which of the following substitution variables should be used to reuse the variable value without prompting the user each time?

Question: Which of the following constitute the correct guidelines for naming database tables?

Question: Which of the following are DML statements?

Question: An outer join is used when:

Question: Which of the following components are required to run iSQL*plus on PC?

Question: Which of the following constitute the attributes of /SQL*Plus?

Question: Which component is a literal in the following select statement? Select 'Emp name :'||ename from emp where deptno=20;

Question: Which of the following statements is a complete transaction?

Question: Which of the following tasks can be performed by using the TO_CHAR function?

Question: What kinds of commands can you enter at the command prompt in 9i Sql Plus?