RelationalDBDesign
Technology
Search
SiteMap
RedhatLinuxSys
Seomining
Advanced Oracle Tuning
Advanced SQL
Backup Recovery Options
Basic SQL
DB Admin Features
DB Creation Architecture
Extended DB Features
Managing DB Objects
Managing Connectivity
Network Configuration
Oracle BU Features
Oracle DB Recovery
Network Administration
Oracle Network Topology
Oracle SQL Extensions
Oracle SQL Tuning
8i PL/SQL Programming
Performance Tuning
PL/SQL Stored Objects
PL/SQL Programming
Relational DB Analysis
Relational DB Design
Tech Interview Questions
Tuning Oracle Instance
DB Creation Architecture
Oracle Server Manager
Oracle DB Architecture
Oracle Instance Architecture
Oracle Memory Architecture
Using Oracle Server Manger - Quiz
Quiz Instructions
Each question is worth one point. Select the best answer or answers for each question.
1.
Which of the following commands will successfully connect to your default Oracle database?
Please select the best answer.
A.
CONNECT INTERNAL
B.
CONNECT DEFAULT
C.
CONNECT ORACLE_SID
D.
CONNECT DEFAULT/INTERNAL
2.
Which of the following SQL statements is terminated correctly?
Please select all the correct answers.
A.
select name
from v$database/
B.
select name
from v$database;
C.
select name
from v$database
.
D.
select name
from v$database
\
E.
select name
from v$database
/
3.
You made a mistake typing in a command and now Server Manager is letting you type more commands, but is not executing those commands. What should you do?
Please select the best answer.
A.
Reboot the database server
B.
Press
Enter
twice to reset the command prompt
C.
Call Oracle Support for help
D.
Type in a semicolon and press
Enter
4.
You need to log the output of a critical SQL script to a file. Which of the following command pairs will start and stop the logging of output?
Please select the best answer.
A.
SET OUTPUT
filename
SET OUTPUT
OFF
B.
SET ECHO ON
SET ECHO OFF
C.
SPOOL
filename
SPOOL OFF
D.
LOG OUTPUT TO
filename
LOG OFF
