RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
SQL* Plus CLI
«Prev
Next»
User Connectivity
Configuring Oracle
SID List Listener
Configuring Listener
Oracle Net Basic Concepts
Password Files
Necessary Password Files
Password Creation Process
Placing | Naming PW File
Creating Password File
Remote Login Password
Connecting Internal Password
DBA Privileges
Different DBA Roles
Connect Database
PW Files Data Dictionary
Rebuilding Password File
Manage PW Conclusion
Enterprise Manager
SQL Plus Worksheet
OEM Architecture
SQL* Plus CLI
Accept Prompt Commands
Spooling Printing Report
SQL Plus Line Editing Commands
Creating Users
Steps To Change Security Manager
Default Tablespaces
Drop User
What Objects does User Own
Managing User Roles
Types System Privileges
Granting System Privileges
With Admin Option Clause
session_privs View
Revoke Privileges Oracle
Managing System Privileges
SQL*Plus Line Editing - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
You have the following SQL statement in the buffer:
SELECT tuble_name FROM user_tables;
Which of these commands will correct the spelling of the word “table”?
Please select the best answer.
A.
C /tuble_name/ to /table_name/
B.
C /tuble_name/table_name/
C.
R /tuble_name/table_name/
D.
CHG tuble_name,table_name
2.
Which of the following would allow you to insert new lines after line 3 of the current SQL statement?
Please select the best answer.
A.
L 3 I
B.
I 3
C.
L 4 I
D.
I /3
3.
Which of the following sets of commands could be used to add an ORDER BY clause to this SQL statement:
SELECT table_name
FROM user_tables
Please select all the correct answers.
A.
L
I ORDER BY table_name
B.
L 2
A ORDER BY table_name
C.
L
C /ORDER BY table_name/
D.
/
ORDER BY table_name
4.
When you are done editing a statement in the buffer, which of the following commands could you use to execute it?
Please select the best answer.
A.
RUN
B.
@@
C.
/
D.
GO