ORACLE Question Bank (Chapters 1-4)
1. The following logical structures that are not part of ORACLE are () physical structures
A. district
B. segment
C. Data files
D. Table space
2. Which of the following users is not the user that exists after ORACLE is installed by default ()
A . SYSDBA
B. SYSTEM
C. SCOTT
D. SYS
3 Which of the following causes the user to connect to the ORACLE database but cannot create a table()
A. The role of CONNECT was granted, but the role of RESOURCE was not granted
B. The user is not granted the role of system administrator
C. The database instance is not starting
D. Database listening does not start
4. The () function is usually used to calculate cumulative rankings, moving averages, and report aggregations.
A . Summary
B. Analysis
Group C,
D Single line
5. A SELECT statement with a () statement can place an exclusive lock on one or more rows of the table.
A . FOR INSERT
B. For UPDATE
C. FOR DELETE
D. FOR REFRESH
6. In Oracle, you log in as SYSDBA, the CUSTOMER table is in the Mary user scenario, which of the following statements creates a synonym () for all users in the database to create a CUSTOMER table.
A. CREATE PUBLIC SYNONYM cust ON mary.customer;
B. CREATE PUBLIC SYNONYM cust FOR mary.customer;
C. CREATE SYNONYM cust ON mary.customer FOR PUBLIC;
D. You cannot create a common synonym for CUSTOMER.
E.
11. In Oracle, the table EMP contains the following:
……
NAME VARCHAR2(20)
ADDR VARCHAR2(60)
……
To return data in NAME's address is ADDR format, the following SQL statement is correct ().
A. SELECT NAME + ’’’s address is ‘ + ADDR FROM EMP;
B. SELECT NAME || ’’’s address is ‘ || ADDR FROM EMP;
C. SELECT NAME + ’\’s address is ‘ + ADDR FROM EMP;
D. SELECT NAME || ’\’s address is ‘ || ADDR FROM EMP;
12. In Oracle, the following are () that are not part of the collection operator.
A. UNION
B. SUM
C. MINUS
D. INTERSECT
13. In Oracle, the table partitioning method () recommends partitioning of powers of 2 (2, 4, 8, etc.) to obtain the most average data publication.
A. Scope zoning
B. List partitioning
C. Hash partitioning
D. Composite zoning
14. In Oracle, the following description of locks is incorrect ().
A. Locks are used to control concurrent access to data between users
B. Locks can be classified into row-level locks and table-level locks
C. insert, update, delete statements automatically obtain row-level locks
D. Only one user can lock a specific table at a time
17: In Oracle, using the SELECT command with a () clause can place an exclusive lock on one or more rows of a table.
A. FOR INSERT OF
B. FOR REFRESH
C. FOR UPDATE
D. FOR LOCK
18: In Oracle, the sequence venseq is created with the following statement:
CREATE SEQUENCE venseq INCREMENT BY 1 START WITH 10
MAXVALUE 100 MINVALUE 10 CYCLE CACHE 5;
The following statement modified by the sequence venseq is wrong ().
A. ALTER SEQUENCE venseq START WITH 1;
B. ALTER SEQUENCE venseq MAXVALUE 90;
C. ALTER SEQUENCE venseq NOMINVALUE;
D. ALTER SEQUENCE venseq NOCACHE;
19: In Oracle, create a view with the following statement:
CREATE OR REPLACE VIEW pen_view
AS SELECT * FROM order_master
WHERE ostatus = ‘p’ WITH CHECK OPTION CONSTRAINT penv;
When a user attempts to execute the following statement:
UPDATE pen_view SET ostatus = ‘d’ WHERE ostatus=’p’;
The following description is correct ().
A. Oracle modifies ostatus to d without prompting any errors
B. Oracle does not perform an update operation and returns an error message
C. Oracle modifies ostatus to d and returns an error message
D. Oracle does not perform update operations and does not prompt any errors
20: In Oracle, you can get better performance by indexing bitmaps () in the following cases.
A. Created on a column with a unique column value
B. Create on columns with very small differences in column values
C. Build on columns with frequently repeated column values
D. Created on the column used to save the bitmap
21: In Oracle, the lock can be released via the command ().
A. INSERT
B. DELETE
C. ROLLBACK
D. UNLOCK
24: In Oracle, (A) data dictionary tables can be used to see the actual structure of abstract data types.
A. USER_TYPE_ATTRS
B. USER_TABLES
C. USER_TYPE_TABS
D. USER_TAB_COLUMNS
32: In Oracle, you need to create an index to improve the performance of the salary review, which is to analyze and process the employee's salary increase by 12 percentage points, which of the following create index command solves this problem ().
A. CREATE INDEX my_idx_1 ON employee(salary*1.12);
B. CREATE UNIQUE INDEX my_idx_1 ON employee(salary);
C. CREATE BITMAP INDEX my_idx_1 ON employee(salary);
D. CREATE INDEX my_idx_1 ON employee(salary) REVERSE;
33: In Oracle, execute the following statement:
SELECT ceil(-97.342),
floor(-97.342),
round(-97.342),
trunc(-97.342)
FROM dual;
Which function does not return a value equal to -97().
A. ceil()
B. floor()
C. round(0)
D. trunc()
34: In Oracle, create a sequence with the following SQL command:
CREATE SEQUENCE my_seq
START WITH 394
INCREMENT BY 12
NOMINVALUE
NOMAXVALUE
NOCYCLE
NOCACHE;
The user executes a my_seq that includes. NEXTVAL's SQL statement three times, and then execute the include
my_seq. CURRVAL's SQL statement four times, please ask the current value of the sequence my_seq is ().
A. 406
B. 418
C. 430
D. 442
E. 242:
43: In Oracle, the lock can be released via the command (). (Select two)
A. INSERT
B. DELETE
C. ROLLBACK
D. COMMIT
44: In Oracle, using the following SQL statement in a transaction does not cause a lock (). (Select one)
A. SELECT
B. INSERT
C. UPDATE
D. DELETE
E.
46: In Windows operating systems, Oracle's () server listens and accepts connection requests from client applications. (Select one)
A. OracleHOME_NAMETNSListener
B. OracleServiceSID
C. OracleHOME_NAMEAgent
D. OracleHOME_NAMEHTTPServer
47: In Oracle, there is a sequence object called seq, and the following statement returns the sequence value but does not cause the sequence value to increase (). (Select one)
A. select seq. ROWNUM from dual;
B. select seq. ROWIDfrom dual;
C. select seq. CURRVALfrom dual;
D. select seq. NEXTVALfrom dual;
48: In ORACLE, execute the statement: SELECT address1||','|| address2||','|| address2 "Address" FROM employ； will return the () column.
A. 0
B. 1
C. 2
D. 3
50: In Oracle databases, the following () can be used as a valid column name.
A. Column
B. 123_NUM
C. NUM_#123
D. #NUM123
52: In Oracle databases, access to () provides the fastest way to access a row in a table.
A. Primary key
B. Rowid
C. Unique index
D. Full table scanning
53: In Oracle, generate a sequence using the following statement:
CREATE SEQUENCE id；
The Oracle server pre-opens memory and maintains a sequence value of (). (Select one)
A. 0
B. 10
C. 20
D. 100
54: In Oracle databases, the following () command can delete data from the entire table and cannot be rolled back.
A. drop
B. delete
C. truncate
D. cascade
55: In the Oralce database, the following () function can be operated on any data type.
A. TO_CHAR
B. LOWER
C. MAX
D. CEIL
63: In Oracle, statement () displays ORDER_DATE date value 'March 18, 2000' as 'January 1, 2000' (select two) BD
A. select round(order_date,'day')from inventory
B. select round(order_date,'year')from inventory
C. select round(order_date,'month')from inventory
D. select round(to_char(order_date,'yyyy'))from inventory
69: In Oracle, using the following SQL statement in a transaction does not cause a lock().
A. SELECT
B. INSERT
C. UPDATE
D. DELETE
76: In Oracle databases, the following () function can be operated on any data type.
A. TO_CHAR
B. LOWER
C. MAX
D. CEIL
79: In Oracle there is a table "cd", which contains the attributes "cdcode", "category" and "cdname", and to query the rows with the value of "CLASSIC" or "ROCK" in category, the statement () should be used.
A. SELECT * FROM cd WHERE category IN ('CLASEIC','ROCK');
B. SELECT * FROM cd WHERE category BETWEEN 'CLASSIC' AND 'ROCK';
C. SELECT * FROM cd WHERE category='CLASSIC' AND category='ROCK';
D. SELECT * FROM cd WHERE category='CLASSIC' OR category='ROCK';
80: In Oracle, when executing a SQL statement, you accidentally use the Update command to set all the ID values to 11111, then you can use the () command to cancel this operation.
A. EXIT
B. COMMIT
C. ROLLBACK
D. UNDO
82 In Oracle, if a user TOM is created using the following statement, the following statement is incorrect for that user (). (Select one) CREATE USER TOM IDENTIFIED BY TOMSYS
A The user's password is TOMSYS
B TOM defaults to tablespace and SYSSTEM
The temporary tablespace of the C TOM is TEMP
D Enables the GRANT UPDATE command to modify TOM's password
|
Landlord|
Posted on 3/13/2015 4:28:34 PM
|
Posted on 3/13/2015 4:27:56 PM
