单项选择题X 纠错
A. You want to identify the most senior employee in the company.
B. You want to find the manager supervising the largest number of employees.
C. You want to identify the person who makes the highest salary for all employees.
D. You want to rank the top three sales representatives who have sold the maximum number of products.
你可能喜欢
多项选择题
A. You cannot use IN operator in a condition that involves an outerjoin.
B. You use (+) on both sides of the WHERE condition to perform an outerjoin.
C. You use (*) on both sides of the WHERE condition to perform an outerjoin.
D. You use an outerjoin to see only the rows that do not meet the join condition.
E. In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.
F. You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.
单项选择题
A. CREATIVE USER susan;
B. CREATIVE OR REPLACE USER susan;
C. CREATE NEW USER susan DEFAULT
D. CREATE USER susan IDENTIFIED BY blue;
E. CREATE NEW USER susan IDENTIFIED BY blue;
F. CREATE OR REPLACE USER susan IDENTIFIED BY blue;
单项选择题
A. ALTER TABLE commercials MODIFY (description CHAR2(2000));
B. ALTER TABLE commercials CHANGE (description CHAR2(2000));
C. ALTER TABLE commercials CHANGE (description VARCHAR2 (2000));
D. ALTER TABLE commercials MODIFY (description VARCHAR2 (2000));
E. You cannot increase the size of a column if the table has rows.
单项选择题
A. Removes the table
B. Removes all rows from a table
C. Shortens the table to 10 rows
D. Removes all columns from a table
E. Removes foreign keys from a table
单项选择题
A. INSERT
B. UPDATE
C. SELECT
D. DESCRIBE
E. DELETE
F. RENAME
单项选择题
A. SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;
B. SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;
C. SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;
D. SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;
E. SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;
单项选择题
A. All of the desired results
B. Two of the desired results
C. One of the desired results
D. An error statement
单项选择题
A. Create groups of data
B. Sort data in a specific order
C. Convert data to a different format
D. Retrieve data based on an unknown condition
单项选择题
A. WHERE
B. HAVING
C. RESTRICT
D. GROUP BY
E. ORDER BY
单项选择题
A. You can join a maximum of two tables through an equijoin.
B. You can join a maximum of two columns through an equijoin.
C. You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.
D. To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.
E. You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.