A.You want to create a nonequijoin.
B.The tables to be joined have multiple NULL columns.
C.The tables to be joined have columns of the same name and different data types.
D.The tables to be joined have columns with the same name and compatible data types.
E.You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.
第1题:
You want the size of the tablespace to increase when it is full. Which option would you use?()
第2题:
You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this?()
第3题:
When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?()
第4题:
Which clause should you use to exclude group results?()
第5题:
Host naming
Local naming
Easy Connect
External naming
directory naming
第6题:
The PRIMARY KEY is created along with a new index.
The PRIMARY KEY is created and it would use an existing unique index.
The PRIMARY KEY would be created in a disabled state because it is using an existing index.
The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.
第7题:
INCLUDING DEPENDENCIES
INCLUDING DEPENDENCIES CASCADE
COMPACT
CASCADE
None of the above
第8题:
WHERE
HAVING
RESTRICT
GROUP BY
ORDER BY
第9题:
table
transactional trigger
stored procedure
FROM clause query
第10题:
ORDER BY SALARY > 5000
GROUP BY SALARY > 5000
HAVING SALARY > 5000
WHERE SALARY > 5000
第11题:
Use Oracle Managed Files (OMF).
Specify the SEED FILE_NAME_CONVERT clause.
Specify the PDB_FILE_NAME_CONVERT initialization parameter.
Specify the DB_FILE_NAMECONVERT initialization parameter.
Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).
第12题:
Hash cluster
Index cluster
Sorted hash cluster
Real Application cluster
第13题:
You want to create a WebLogic domain in a production environment. Which three actions should you perform?()
第14题:
You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility?()
第15题:
You are maintaining a database of credit card transactions. You want the data to be returned automatically in the chronological order of the credit card numbers without using the ORDER BY clause in the query. Which type of cluster will you use to obtain the desired result?()
第16题:
You decided to increase the value for the SHARED_SERVERS parameter by using the following command: SQL> ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=?; Which three values can be specified for the SCOPE clause?()
第17题:
ALL
PFILE
BOTH
NONE
SPFILE
MEMORY
INSTANCE
DATABASE
第18题:
use automatic extent allocation
disable threshold for the tablespace
use freelists to manage the free space
use automatic segment space management
create the tablespace as a bigfile tablespace
use the RESIZE clause while creating the tablespace
enable AUTOEXTEND for at least one of the data files in the tablespace
第19题:
The statement would not execute because table aliases are not allowed in the JOIN clause.
The statement would not execute because the table alias prefix is not used in the USING clause.
The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.
The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.
第20题:
FIND_TIMER
CREATE_TIMER
SET_TIMER
DELETE_TIMER
GET_APPLICATION_PROPERTY
第21题:
You want to create a nonequijoin.
The tables to be joined have multiple NULL columns.
The tables to be joined have columns of the same name and different data types.
The tables to be joined have columns with the same name and compatible data types.
You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.
第22题:
UNTIL CANCEL
UNTIL SCN
UNTIL SEQUENCE
UNTIL TIME
第23题:
at the water's edge
on deck
on the bottom
well in the water
第24题:
802.11B
spanning-tree
802.1Q
ISL
VTP
Q.921