Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

Multiple choice technology databases

What code modificaiton should be made to run the below code ? begin dbms_scheduler.create_job ( job_name => 'RUN_SHELL1', schedule_name => 'DEMO_SCHEDULE', job_type => 'EXECUTABLES', job_action => '/home/test/run_script.sh', enabled => true, comments => 'Run shell-script' ); end; /

  1. No change is required,job can be scheduled.

  2. Enabled option should be set to False.

  3. Job type should be changed to Executable

  4. Job type should be changed to Executable Block

  5. None
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation
Multiple choice technology databases

An existing sales catalog database structure exists on a system in your company. The company sells inventory from a single warehouse location that is across town from where the computer systems are located. The product table has been created with a nonclustered index, based on the product ID, which is also the primary key. Nonclustered indexes exist on the product category column and also the storage location column. Most of the reporting done is ordered by storage location. How would you change the existing index structure?

  1. Change the definition of the primary key so that it is a clustered index.

  2. Create a new clustered index, based on the combination of storage location and product category.

  3. Change the definition of the product category so that it is a clustered index.

  4. Change the definition of the storage location so that it is a clustered index.
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation
Multiple choice technology databases

You are designing an application that will provide data entry clerks the capability of updating the data in several tables. You would like to ease entry and provide common input so the clerks do not need to enter data into all fields or enter redundant values. What types of technologies could you use to minimize the amount of input needed? (Select all that apply.)

  1. Foreign key

  2. Cascading update

  3. Identity column

  4. Default

  5. NULL

  6. Unique index
Reveal answer Fill a bubble to check yourself
B,C,D,E Correct answer
Full explanation
Multiple choice technology databases

You are the database developer for a leasing company. Your database includes a table that is defined as shown here: CREATE TABLE Lease (Id Int IDENTITY NOT NULL CONSTRAINT pk_lease_id PRIMARY KEY NONCLUSTERED, Lastname varchar(50) NOT NULL, FirstName varchar(50) NOT NULL, SSNo char(9) NOT NULL, Rating char(10) NULL, Limit money NULL) Each SSNo must be unique. You want the data to be physically stored in SSNo sequence. Which constraint should you add to the SSNo column on the Lease table?

  1. The UNIQUE CLUSTERED constraint

  2. The UNIQUE UNCLUSTERED constraint

  3. The PRIMARY KEY CLUSTERED constraint

  4. The PRIMARY KEY UNCLUSTERED constraint
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation
Multiple choice technology databases

You are preparing a new index on a table that has 1,500 rows. 10 rows are added to this table every day. The table already has a primary key, and the new index does not represent the order in which data in the table is to be stored. Updates to the table occur periodically but are infrequent. Which type of index would you create under this situation?

  1. Use a clustered index with a high FILLFACTOR setting

  2. Use a clustered index with a low FILLFACTOR setting

  3. Use a nonclustered index with a high FILLFACTOR setting

  4. Use a nonclustered index with a low FILLFACTOR setting
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation