Ready to test your Knowledge?
Try out our new practice tests completely free!
exam preparation banner icon

Database Concepts Study Set 2

Computing

Quiz 10 :

Getting Started With Oracle Database 11g Release 2

Quiz 10 :

Getting Started With Oracle Database 11g Release 2

search
arrow
The default file extension for text files created for or within SQL Developer is .sql.
Free
True False
Answer:

Answer:

True

arrow
Oracle Database XE 11.2 uses Application Express to create new workspaces.
Free
True False
Answer:

Answer:

True

arrow
The Oracle Database GUI tool used for application development is the Oracle SQL Developer.
Free
True False
Answer:

Answer:

True

arrow
With Oracle Database,data must be entered using SQL INSERT statements.
True False
Answer:
arrow
To log into Oracle Database XE 11.2,use your personal account information.
True False
Answer:
arrow
Oracle Database XE 11.2 is a Web-based Oracle Database administration utility.
True False
Answer:
arrow
To log into a workspace connection in Oracle SQL Developer,use the username and password you created for Application Express.
True False
Answer:
arrow
Which of the following is the easiest tool for creating a database with Oracle Database?
Multiple Choice
Answer:
arrow
With Oracle Database,using a sequence does not guarantee valid surrogate key values.
True False
Answer:
arrow
The Oracle Database FORMAT_DATE function can be used to make sure that Oracle Database interprets date data correctly.
True False
Answer:
arrow
Which of the following is an account name for which you are asked to enter a password for the Oracle Database XE 11.2 utility?
Multiple Choice
Answer:
arrow
When using Oracle Database,a sequence is an object that generates a sequential series of unique numbers.
True False
Answer:
arrow
An important reason for using Oracle Database 11g Release 2 is that it has full SQL capabilities.
True False
Answer:
arrow
The NextVal method provides the next value in a sequence.
True False
Answer:
arrow
Which of the following tasks can be done using the Oracle SQL Developer?
Multiple Choice
Answer:
arrow
Which of the following is the easiest tool for doing database development with Oracle Database?
Multiple Choice
Answer:
arrow
The Oracle Database ODBC Client is automatically installed when Oracle Database 11g Release 2 is installed.
True False
Answer:
arrow
The CurrVal method provides the current value in a sequence.
True False
Answer:
arrow
Sequences are most often used to provide values for surrogate keys.
True False
Answer:
arrow
Which of the following is an account name for which you would enter a password to connect to a workspace in Oracle SQL Developer?
Multiple Choice
Answer:
Showing 1 - 20 of 43