Examine the command that is used to create a table：
SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER（6）， oamt NUMBER（10，2）） TABLESPACE users；
Which two statements are true about the effect of the above command） （）
A.A CHECK constraint is created on the OID column.
B.A NOT NULL constraint is created on the OID column.
C.The ORDERS table is the only object created in the USERS tablespace.
D.The ORDERS table and a unique index are created in the USERS tablespace.
E.The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.
您可能感兴趣的试卷
你可能感兴趣的试题
You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this.
Which data type would you use for the new column（）
A.CLOB
B.BLOB
C.BFILE
D.LONG RAW
You created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL> DROP PROFILE app_user；
Which statement describes the result（）
A.The command produces an error.
B.The profile is dropped and current user sessions use the DEFAULT profile immediately.
C.The profile is dropped and only the subsequent user sessions use the DEFAULT profile.
D.The profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.
In your database instance， the user sessions are connected to the database server from the remotemachines. You want to achieve the following for these users：
1：The user account must be locked after four unsuccessful login attempts.PASSWORD_LOCK_TIME
2：The user must be prompted to change the password at regular intervals.PASSWORD_LIFE_TIME
3：The user may not have more than three simultaneous sessions.SESSIONS_PER_USER
4：The user session must automatically be logged off if more than 10 minutes elapsed time used.CONNECT_TIME
How would you accomplish the above（）
A.by assigning profiles for the users
B.by implementing Fine-Grained Auditing （FGA）
C.by granting a secure application role to the users
D.by implementing the Database Resource Manager plan
View the Exhibit to observe the roles assigned to the SLP_REP user.
Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SLP_REPuser（）
A.The user must enable the role explicitly.
B.The user can grant the role to other users.
C.The user cannot use the role until the DBA enables it explicitly.
D.The user can start using the role immediately without any changes.
View the Exhibit and examine the user information.
The user has been granted CONNECT and RESOURCE roles and no individual system privileges. TheSL_REP user executes this command to create a table：
SQL> CREATE TABLE orders（oid number（6）， odate date， ccode number（4）， oamt number（10，2）） TABLESPACE purchase_space；
The PURCHASE_SPACE tablespace already exists in the database.
Which statement describes theeffect of the command（）
A.The command executes successfully and creates the table in the USERS tablespace.
B.The command executes successfully and creates the table in the PURCHASE_SPACE tablespace.
C.The command produces an error because the user does not have the privilege to create the table.
D.The command produces an error because the user does not have quota in the PURCHASE_SPACE tablespace.
You want to create a role to meet these requirements：
1：The role is to be protected from unauthorized usage.
2：The password of the role is not to be embedded in the application source code or stored in a table.
Which method would you use to restrict enabling of such roles（）
A.Create the role with global authentication.
B.Create the role with external authentication.
C.Create the role as a secure application role.
D.Create the role as a password-protected role.
E.Create a role and use Fine-Grained Access Control （FGAC） to secure the role.
Examine the commands executed in the following sequence：
1：SQL> CREATE ROLE mgrrole；
2：SQL> GRANT create user，select any table，connect，resource TO mgrrole；
3：SQL> GRANT select，update ON sh.sales TO mgrrole；
4：SQL> CREATE ROLE ceo IDENTIFIED BY boss；
5：SQL> GRANT mgrrole，drop any table，create any directory TO ceo；
6：SQL> GRANT ceo TO mgrrole；
Which statement is true about the above commands（）
A.The commands execute successfully.
B.Command 6 produces an error because of circular role grant.
C.Command 5 produces an error because a role cannot be granted to another role.
D.Command 3 produces an error because the MGRROLE role already contains system privileges.
E.The table created by HR remains and HR still has the CREATE TABLE system privilege.
F.The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
Examine the following steps performed on a database instance：
1：The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.
2：The SKD usercreates a table.
3：The SKD user grants theCREATETABLE system privilege to the HR user.
4：The HR user creates a table.
5：The DBA revokes the CREATE TABLE system privilege from SKD.
Which statement is true after step 5 is performed（）
A.The table created by SKD isnot accessibleand SKD cannot create new tables.
B.The tables created by SKD and HR remain， but both cannot create new tables.
C.The table created by HR remains and HR still has the CREATE TABLE system privilege.
D.The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command：
SQL> GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL> GRANT SELECT，INSERT，UPDATE ON hr.emp TO jim；
Now， the user HR decides to revoke privileges from JIM using this command： SQL> REVOKE SELECT，INSERT，UPDATE ON emp FROM jim； Which statement is true after HR issues the REVOKE command（）
A.The command fails because SCOTT still has privileges.
B.The command succeeds and privileges are revoked from JIM.
C.The command fails because HR cannot revoke the privileges from JIM.
D.The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.
View the Exhibit and examine the privileges granted to the MGR_ROLE role.
The user SKD has been granted the CONNECT and RESOURCE roles only. The database administrator （DBA） grants MGR_ROLE to the user SKD by executing the command： SQL> GRANT MGR_ROLE TO SKDWITH ADMIN OPTION；
Which statement is true about the user SKD after he/she is granted this role（）
A.The user SKD can grant only the MGR_ROLE role to other users， but not the privileges in it.
B.The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor.
C.The user SKD can grant the privileges in the MGR_ROLE role to other users， but not with ADMIN OPTION.
D.The user SKD can grant the privileges in the MGR_ROLE role to other users， but cannot revoke privileges from them.
最新试题
Which kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist？（）
Which statements are true regarding a tablespace（）
You are working on a database that must be functioning 24 hours a day， 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command：SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno；SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session（）
You set the following parameters in the parameter file and restarted the database：MEMORY_MAX_TARGET=0MEMORY_TARGET=500MPGA_AGGREGATE_TARGET=90MSGA_TARGET=270MWhich two statements are true about these parameters after the database instance is restarted（）
In a new installation of Oracle Database 11g， you perform these activities：1. Organize software and data on different subdirectories to avoid poor performance.2. Use consistent naming conventions for database files.3. Separate administrative information pertaining to the database in different directories. Which optioncorresponds to the type of activities you performed（）
You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this（）
View the Exhibit and examine the privileges granted to the SL_REP user. The EMP table is owned by theSCOTT user. The SL_REP user executes the following command：SQL> GRANT SELECT ON scott.emp TO hr；Which statement describes the outcome of the command（）
Which statement is true about loading data using the conventional path of SQL*Loader（）
After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN；Which two statements are true（）