Home > Articles

Creating a Database

  • Print
  • + Share This
This chapter is from the book

Exam Prep Questions

  1. What three tablespaces can be created using the CREATE DATABASE statement? [Select three]

    1. Undotbs1

    2. System

    3. Users

    4. Datatbs

    5. Indextbs

    6. Temporary

    Answers A, B, and F are correct. The three tablespaces that you can create at database creation time are the Undo tablespace (which defaults to the name in A if none is given and automatic undo is used), a default temporary tablespace, and the system tablespace (SYSTEM is the only one that is mandatory). Although Users (C), Datatbs (D), and Indextbs (E) may be valid tablespaces, they have to be created after the database is created.

  2. What should you do as soon as you have successfully created the database and the data dictionary?

    1. Open the database for users to start adding data.

    2. Start adding a bunch of tablespaces to allow users to use.

    3. Leave it running for a few days to make sure that nothing bad is going to happen.

    4. Shut it down and take a cold backup.

    Answer D is correct. As soon as you have successfully created the database and the data dictionary, you should shut down the database and take a cold backup to make sure that you have a fallback point should something happen later. Answer A is incorrect because many things can happen to a database when users are accessing it, and you would, at this point, have to re-create the database if anything should happen to the database that would cause you to have to restore, you would have a backup to restore from. Answer B is incorrect. Adding a lot of tablespaces could only complicate your initial restore if you should have to recover the new database. Answer C is incorrect because nothing will really be lost but definitely nothing will be gained from simply letting the database run for a while.

  3. What should you not do if your database creation script fails?

    1. Check the SQL Syntax.

    2. Make sure that there is sufficient space in the file system or directory or drive.

    3. Rerun the script immediately.

    4. Delete existing files.

    Answer C is correct. Rerunning the script immediately won't resolve any issues and will likely present you with new ones that may cloud the original issue. Answer A should be done first; check to see whether you have syntax errors in your CREATE DATABASE script. Answer B should be done next; make sure that you have enough space in the place you are using for your files to house them. Answer D should be done right before you are ready to run the script again; leaving files out in the same location will likely cause your script to fail again.

  4. What starts the instance and allows users to access the database?

    1. STARTUP NOMOUNT

    2. STARTUP OPEN

    3. STARTUP MOUNT

    4. STARTUP RESTRICT

    Answer B is correct. STARTUP OPEN opens the instance and the database to allow users to connect to the database. Answer A is usually only used for database creation and starts just the instance. Answer C starts the instance and mounts the database, but at this point it can only be accessed by someone with sysdba authority. Answer D is incorrect because RESTRICT signifies that only privileged users (sysdba and those with restricted session authority) can access the instance and the database.

  5. You are using the DBCA and you need to change some of the templates that you have stored. What option from the first screen would you use to accomplish this?

    1. Create Database

    2. Manage Templates

    3. Configure Database Options in Database

    4. Change All Templates

    Answer B is correct; you want to manage templates. Answer A is incorrect; you would use this option to create a new database. Answer C is incorrect; you would use this option to change configuration settings in a database that already exists. Answer D is incorrect; it is not an option in the DBCA.

  6. Which three operations can be accomplished through the Database Creation Assistant? [Choose three]

    1. Create Database

    2. Maintain Database

    3. Delete Database

    4. Alter Database

    5. Configure Database

    Answers A, C, and E are correct. Through the DBCA, you can create, delete, or configure an existing database. Answer B is incorrect because that is what you do with most of your time as a DBA and can be done with the assistance of Oracle Enterprise Manager. Answer D is incorrect; OEM and command line are the means by which you can alter the database.

  7. What GUI tool is provided by Oracle to assist in the creation of databases?

    1. DBCA

    2. OEM

    3. SQL Plus

    4. Java

    Answer A is correct. Database Creation Assistant (DBCA) is the GUI tool provided to assist with the creation of databases. Answer B, OEM, is the tool that assists database administrators with daily routine maintenance of the database. Answer C is a command-line–like interface through which users can submit SQL queries (it can run in Windows as a GUI interface or native on any other platform). Answer D in incorrect; Java is a programming language that is the basis for many of the Oracle tools but is not the interface.

  8. What is the minimum number of control files that Oracle suggests for a database?

    1. 1

    2. 2

    3. 3 groups

    4. 0

    Answer B is correct. Oracle suggests having at least two control files for a production database. Answer A is the minimum number necessary to run a database. Answer C is the suggested number of redo log groups. Answer D is incorrect because there needs to be at least one available control file for database operation.

  9. You need to determine the placement of your multiplexed CONTROL FILES in the database that you are creating. With what parameter in the CREATE DATABASE script would you specify the location?

    1. control_files

    2. controlfile

    3. logfile

    4. datafile

    Answer A is correct; you specify the name and location of the CONTROL FILES with the controlfile parameter in the CREATE DATABASE script. Answer B is incorrect; the control_files parameter is in the initialization files. Answer C is incorrect; it specifies the location of the online redo log files. Answer D is incorrect; the datafile parameter isn't in the initialization file but is a specification of the tablespace creation command.

  10. Which is not a necessary decision to make at database creation time?

    1. Location of the control files

    2. Location of the redo log files

    3. Location of the SYSTEM tablespace's data files

    4. Location of all the data files that will belong to the database

    Answer D is correct; it is not necessary to know the location of every data file that will be connected to your database at database creation time. Answers A, B, and C are incorrect because they are all necessary information for creation of the database initially.

  • + Share This
  • 🔖 Save To Your Account