MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Database
Managing Databases With Oracle
Quiz 1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Q.1
The default extension for SQL*Plus is .sql.
True
False
Q.2
The left-leaning slash tells Oracle to execute whatever statement is in the buffer.
True
False
Q.3
Oracle commands, column names, table names, view names and all other database elements are case sensitive.
True
False
Q.4
If there is only one statement and no ambiguity about what is wanted, Oracle will treat the semicolon and slash as the same.
True
False
Q.5
The only time that case matters is inside quotation marks of strings.
True
False
Q.6
You can use the DROP statement to remove structures from the database.
True
False
Q.7
Oracle, the world's most popular DBMS, is powerful and robust, running on many different operating systems.
True
False
Q.8
When you type into SQL*Plus and press enter, the statement will be finished and executed.
True
False
Q.9
Oracle allows the ORDER BY clause in view definitions.
True
False
Q.10
Oracle does NOT support a CASCADE UPDATE constraint.
True
False
Q.11
Sequences guarantee valid surrogate key values.
True
False
Q.12
Oracle will let you define Notepad as your default editor, and whenever you type NOTEPAD, SQL*Plus will invoke Notepad.
True
False
Q.13
The semicolon terminates a SQL statement (and executes it).
True
False
Q.14
SQL*Plus is a text editor.
True
False
Q.15
When you type Start FILENAME, the statement in your file will be executed automatically.
True
False
Q.16
Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values.
True
False
Q.17
Money is defined in Oracle with the Currency data type.
True
False
Q.18
You have linked SQL*Plus to an external text editor. To invoke the text editor for use within SQL*Plus, which command do you use?
Open [
FileName
]
Show [
FileName
]
Alter [
FileName
]
Edit [
FileName
]
Q.19
The default extension for an Oracle SQL*Plus file is:
.txt
.pls
.ora
.sql
Q.20
You can check on the status of tables with the DESCRIBE or DESC command.
True
False
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page