Database from blue

To use a sequence, in an INSERT statement, you a. use the NEXTVAL pseudo column for the sequence in the VALUES list for a row b. use the CURRVAL +1 expression for the sequence in the VALUES list for a row c. code the sequence name in the VALUES list for a row

a. use the NEXTVAL pseudo column for the sequence in the VALUES list for a row

When you create a script for creating a database a. you can create the tables in whatever sequence you prefer b. you need to create the referred to tables that refer to them c. you need to create the indexes before you create the tables that they apply to d. you need to code the primary key column first

b. you need to create the referred to tables that refer to them

Which of the following is not true about creating indexes? a. Oracle automatically creates indexes for primary keys b. You can create an index that's based on an expression that uses one or more functions c. Oracle automatically creates indexes for foreign keys

c. Oracle automatically creates indexes for foreign keys

When you use the CREATE TABLE statement tocreate a table, you can also define the attributes and _________________for the columns of the table.

constraints

When you create a sequence, you can determine all but one of the following. Which one is it? a. the starting value for the sequence b. the number that the sequence should be increased by c. You can create an index that's based on more than one column d. Oracle automatically creates indexes for foreign keys

d. Oracle automatically creates indexes for foreign keys

You can't code which one of the following as part of a CREATE TABLE statement a. not null constraints b. column-level constraints c. table-level constraints d. function-based indexes

d. function-based indexes

Unless you specify otherwise, the CREATE INDEX statement creates a/an _______________________ index for the specified column or columns.

non-clustered

You use DDL to create, modify, and delete the ________ of a database.

objects

An index can improve performance when SQL Server does a/an _______________ or a join based on a specific value in the indexed column.

search

When you define a foreign key constraint, you can determine all but one of the following.

that the insertion of a row in a foreign key table that has a foreign key that isn't matched in the primary key table should be cascaded up to the primary key table

The CREATE DATABASE statement creates two files on the hard drive of the server: a data file and a/an __________ file.

transaction log