Exam Prep Questions


1:

You have granted user Haylee the SELECT ANY TABLE privilege WITH ADMIN OPTION. Haylee has granted SELECT ANY TABLE to Blaine and Garrison. After you realize that you granted Haylee the wrong privileges, you revoke her SELECT ANY TABLE privilege. What is the status of Blaine and Garrison?

  • A. Blaine can select from any table, but Garrison cannot.

  • B. Garrison can select from any table, but Blaine cannot.

  • C. Both Blaine and Garrison can select from any table.

  • D. Neither Blaine nor Garrison can SELECT ANY TABLE.

A1:

Answer C is correct; both Blaine and Garrison can still select from any table in the database. Answers A and B are incorrect; revoking the SELECT ANY TABLE WITH ADMIN OPTION from Haylee won't revoke the privilege from one of the people that she granted it to but not the other. Answer D is incorrect because it is a system privilege. Revoking the privilege from Haylee won't have any effect on the privileges that she granted to other people.

2:

User Loren has granted Alex SELECT ON ALBUMS WITH GRANT OPTION. Alex has granted SELECT ON ALBUMS to Brittney and Brent. Loren decides that she no longer wants Alex to be able to grant other people access to her tables and revokes her privileges. What does this do to the privileges of Brittney and Brent?

  • A. Both Brittney and Brent can still select information from the albums table.

  • B. Neither Brittney nor Brent can select information from the albums table.

  • C. Brittney can continue to select from the albums table, but Brent cannot.

  • D. Brent can continue to select from the albums table, but Brittney cannot.

A2:

Answer B is correct; neither Brittney nor Brent can any longer select from the albums table. WITH GRANT OPTION on a nonsystem privilege means that when the privilege is revoked from the initial user, those revokes cascade to all users to whom that user granted the privileges. Answer A is incorrect; SELECT on a specific table is not a system privilege and will therefore not follow the rules of the passed-on privilege remaining after the user WITH GRANT OPTION has had her privileges revoked. Answers C and D are incorrect because the revoke would not affect one user while leaving the other user unaffected.

3:

User Arthur logs on to an idle instance as a user with SYSOPER and attempts to start up the database in restricted mode. What is the effect of the STARTUP RESTRICT command in this case?

  • A. Database is started and opened normally.

  • B. Database is started and opened in restricted mode.

  • C. Database is not started at all; SYSOPER can't start the database.

  • D. There is no SYSOPER role.

A3:

Answer B is correct; SYSOPER has the permissions to start up the database in restricted mode. Answer A is incorrect; the database will be started in restricted mode, not normally. Answer C is incorrect; SYSOPER does have start database privileges. Answer D is incorrect; two roles created when the database is created are SYSDBA and SYSOPER.

4:

You need to determine what system privileges have been granted to user Bethany. Which of the following queries would help you with this determination?

  • A. SELECT PRIVILEGE FROM DBA_SYS_PRIVS where grantee = 'BETHANY';

  • B. SELECT PRIVILEGE FROM DBA_TAB_PRIVS where grantee = 'BETHANY';

  • C. SELECT PRIVILEGE FROM SESSION_PRIVS where grantee = 'BETHANY';

  • D. SELECT PRIVILEGE FROM DBA_COL_PRIVS where grantee = 'BETHANY';

A4:

Answer A is correct; DBA_SYS_PRIVS contains a list of all the system privileges that have been granted to user or to roles. Answer B is incorrect; DBA_TAB_PRIVS contains a list of all the grants on any objects in the database but not any information on system privileges. Answer C is incorrect; SESSION PRIVS contains a list of all the system privileges currently available to the given user. Answer D is incorrect; DBA_COL_PRIVS lists all the object column grants in the database.

5:

What command provides user Crystal with select rights to the address table in your schema?

  • A. GIVE SELECT ON ADDRESS TO CRYSTAL;

  • B. GRANT SELECT ON ADDRESS TABLE TO CRYSTAL;

  • C. GRANT SELECT ON ADDRESS TO CRYSTAL;

  • D. PROVIDE CRYSTAL WITH SELECT PRIVILEGE ON ADDRESS TABLE;

A5:

Answer C is correct; GRANT SELECT ON ADDRESS TO CRYSTAL is the way that you grant select privileges to one user when you are logged in as the owner of that table or as SYS, SYSTEM, or other user with SYSDBA privilege. Answer A is incorrect; GIVE is not a keyword used to provide privileges to a user. Answer B is incorrect; the keyword TABLE is not necessary and will cause an error. Answer D is incorrect; PROVIDE is not a keyword or command in Oracle.

6:

Select any dictionary privilege has been granted to public. User Vaughn runs the following query. What is the result? Select * from v$session

  • A. Query fails; SELECT ANY TABLE does not allow for the selecting of data dictionary views when O7_DICTIONARY_ACCESSIBILITY is set to false.

  • B. Query is successful because the O7_DICTIONARY_ACCESSIBILITY parameter is set to FALSE.

  • C. Query is successful because the user has SELECT ANY TABLE privilege.

  • D. Query is successful because SELECT ANY DICTIONARY granted to PUBLIC allows anyone to select from the data dictionary.

A6:

Answer D is correct; this query is successful because SELECT ANY DICTIONARY has been granted to PUBLIC. This means that everyone who logs in to the database can select data dictionary views. Answer A is incorrect; although SELECT ANY TABLE alone doesn't allow you to select from the data dictionary when O7_DICTIONARY_ACCESSIBILITY is set to false, the addition of SELECT ANY DICTIONARY privilege allows the query to complete successfully. Answer B is incorrect; O7_DICTIONARY_ACCESSIBILITY set to false alone causes the query to fail. Answer C is incorrect; SELECT ANY TABLE alone when O7_DICTIONARY_ACCESSIBILITY is set to false causes the query to fail.

7:

What is the command used to enable auditing on altering tables in the database?

  • A. AUDIT

  • B. AUD$

  • C. AUDIT_TRAIL

  • D. DBA_AUDIT_OBJECT

A7:

Answer A is correct; enabling auditing on this level can be accomplished with the AUDIT command. Answer B is incorrect; AUD$ is the table into which audit records are placed. Answer C is incorrect; AUDIT_TRAIL is the initialization parameter that allows for auditing in the database at all but is not a command. Answer D is incorrect; this is a data dictionary view generated for objects that are audited.

8:

Which of the following statements is true to enable auditing in the database?

  • A. To set up auditing in Oracle, the AUDIT_TRAIL initialization parameter must be set to DB or OS.

  • B. To set up auditing in Oracle, the BEGIN_AUDIT initialization parameter must be set to trUE.

  • C. To set up auditing in Oracle, the AUDIT_TRAIL initialization parameter must be set to NONE.

  • D. To set up auditing in Oracle, the AUDITING initialization parameter must be set to trUE.

A8:

Answer A is correct; AUDIT_TRAIL=DB or AUDIT_TRAIL=OS allows auditing to be enabled in the database. Answer B is incorrect; BEGIN_AUDIT is not a valid initialization parameter. Answer C is incorrect; AUDIT_TRAIL=NONE turns off auditing in your database. Answer D is incorrect; AUDITING is not an initialization parameter.

9:

You have gotten several emergency calls from users who are trying to connect to the database. The users state that the database won't let them connect and that the audit trail is full. What statements describe what is happening in your database? [choose all that apply]

  • A. The database is up and running.

  • B. The users have lost CREATE SESSION privilege.

  • C. The SYS.AUD$ table is full, and you are auditing sessions.

  • D. Operating system authentication is used, and the users have lost their authentication.

  • E. The database has crashed.

  • F. The network has gone down.

A9:

Answers A and C are correct. The database is up and running, but the SYS.AUD$ table has filled up, and you are auditing sessions. Answer B is incorrect; unless revoked, privileges don't just go away. Answer D is incorrect; there is no way to tell what kind of authentication is being used, but they would not get an error about the audit trail being full if something was wrong with the authentication. Answer E is incorrect; if the database was down, they would not be getting an auditing error. Answer F is incorrect; if the network was down, the users wouldn't be able to get to Oracle.

10:

Which privilege enables a user to create a foreign key relationship on another user's table?

  • A. CREATE INDEX

  • B. CREATE ANY INDEX

  • C. REFERENCES

  • D. CREATE ANY KEY

A10:

Answer C is correct; REFERENCES is the privilege that allows you to create foreign keys on another user's tables. Answer A is incorrect. There is no CREATE INDEX privilege; it is inferred by the CREATE TABLE privilege, but only in the owned schema. Answer B is incorrect; CREATE ANY INDEX won't allow a user to create a foreign key relationship. Answer D is incorrect; there is no CREATE ANY KEY privilege.



    Oracle 9i Fundamentals I Exam Cram 2
    Oracle 9i Fundamentals I Exam Cram 2
    ISBN: 0789732653
    EAN: 2147483647
    Year: 2004
    Pages: 244
    Authors: April Wells

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net