Oracle 1Z0-874 Online Practice Questions and Exam Preparation

Oracle 1Z0-874 Online Questions & Answers

• Question 11:

  Which of the following best describe the general steps involved in normalization?

  A. Change the character set of the tables to normalize.
  B. Remove repeating groups within rows.
  C. Remove duplicate data within columns.
  A. Change the character set of the tables to normalize.

• Question 12:

  In order to create an account where no username is needed for login, ...

  A. the account should be created with a username consisting of the empty string
  B. the account should be created with the username "anon"
  C. the account should be created with the username "%"
  D. Accounts cannot be specified in a way such that no username is required
  E. None of the above
  A. the account should be created with a username consisting of the empty string

• Question 13:

  Can you have several MySQL servers running on the same computer, using the same InnoDB tablespace files?

  A. No
  B. Yes, always
  C. Yes, provided their permissions are set to read-only
  A. No

• Question 14:

  Assuming that the account 'joe'@'%' does not already exist on the server, executing the statement mysql> CREATE USER 'joe'@'%' IDENTIFIED BY 'sakila' will have the following consequences:

  A. The account 'joe'@'%' is created on the server. However, clients cannot connect using this account until further privileges have been assigned to the account.
  B. The account 'joe'@'%' is created on the server. Clients may connect to the server using this account, but will not be able to access any databases, tables or stored routines
  C. The account 'joe'@'%' is created on the server. Clients may connect to the server using this account and execute stored routines, but will not be able to access any databases or tables
  D. Nothing; there is no such command as CREATE USER
  B. The account 'joe'@'%' is created on the server. Clients may connect to the server using this account, but will not be able to access any databases, tables or stored routines

• Question 15:

  Which of the following statements best describe the indexes supported by the MEMORY storage engine, and their general characteristics?

  A. MEMORY tables only support HASH indexes which provide fast lookups that use a unique index.
  B. MEMORY tables only support BTREE which provide better performance with non-unique index values and other comparison operators.
  C. MEMORY tables support HASH indexes which provide fast lookups that use a unique index, and BTREE indexes which provide better performance with non-unique index values and other comparison operators.
  D. MEMORY tables support HASH indexes which provide better performance with non-unique index values and other comparison operators, and BTREE indexes which provide fast lookups that use a unique index.
  C. MEMORY tables support HASH indexes which provide fast lookups that use a unique index, and BTREE indexes which provide better performance with non-unique index values and other comparison operators.

• Question 16:

  Connection strings in FEDERATED tables are stored...

  A. In variables.
  B. Within the table definition.
  C. In a .fed file corresponding to the table.
  D. They are not stored, but must be re-specified at server restart.
  B. Within the table definition.

• Question 17:

  Which of the following best describes the purpose of the join buffer, and when should you increase the size of it?

  A. The join buffer is used to process joins.
  B. The join buffer is set per-connection.
  C. The join buffer is global and can only be changed by restarting the server.
  D. The value should be increased if the client performs a lot of SELECT operations.
  E. The join buffer is used to process sorts when complex joins are being performed.
  F. The value should be increased if the client has the tendency to perform complex joins.
  B. The join buffer is set per-connection.

• Question 18:

  By default, mysqld's memory settings are...

  A. There are no default memory settings for mysqld.
  B. Set to a median value good for overall general use.
  C. Rather consuming and should be decreased if possible.
  D. Rather conservative and should be increased if possible.
  D. Rather conservative and should be increased if possible.

• Question 19:

  As an administrator, you attempt to create the account 'joe'@'example.com' with the following statement:

  GRANT SELECT, UPDATE, DELETE ON world.* TO 'joe'@'example.com'

  Which of the following best describe the effects of issuing this statement?

  A. The account is not created, as you must always specify a password for new users
  B. Depending on active SQL modes, you may be prevented from creating the account because no password is specified. Otherwise, an account with no password is created.
  C. An account with no password is created, regardless of SQL modes. The password will not need to be set at a later time.
  D. Since no password is specified, the account is created with an empty password that must be changed by the user on first login
  E. There is not enough information provided to determine the outcome of executing that statement.
  A. The account is not created, as you must always specify a password for new users

• Question 20:

  What is the effect of using WITH GRANT OPTION when executing the following statement?

  GRANT SELECT, UPDATE, DELETE ON world.*

  TO 'joe'@'example.com'

  IDENTIFIED BY 'Sakila'

  WITH GRANT OPTION

  A. Nothing; WITH GRANT OPTION is not a valid clause in GRANT commands.
  B. The account 'joe'@'example.com' may grant SELECT, UPDATE and DELETE privileges on tables in the world database to other users
  C. The account 'joe'@'example.com' may grant any type of privilege on tables in the world database to other users
  D. The account 'joe'@'example.com' becomes an administrator account
  B. The account 'joe'@'example.com' may grant SELECT, UPDATE and DELETE privileges on tables in the world database to other users