0

databases Online Quiz - 43

Description: databases Online Quiz - 43
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Given below, What is the maximum level of data protection

  1. RAID 1 and Fallback

  2. RAID 5 and Fallback

  3. RAID 5 and No Fallback

  4. RAID 1 and No Fallback


Correct Option: A
  1. The increase of hash buckets has resulted in more hash collisions.

  2. Duplicate NUPI values will produce the same row hash.

  3. Uniform row distribution is accomplished using UPIs.

  4. The low-order 16 bits of the row hash are input to the hash map.


Correct Option: B
  1. Shared nothing

  2. Shared memory

  3. Shared everything

  4. shared data


Correct Option: A

Why to Choose a Non Unique primary index instead of a unique primary index

  1. A Non Unique primary index may be more effective for query access and joins

  2. A NUPI query simplifies the optimization process in the PE

  3. A NUPI provides better data distribution

  4. A NUPI requires less disk space to store the data row


Correct Option: A

When utilizing a unique secondary index, how many AMP(s) are most probably accessed

  1. 1 AMP

  2. Multi - AMP

  3. 2 -AMP

  4. All-AMP


Correct Option: C
  1. assigned at the table level

  2. permanent space currently not used

  3. spool space currently not used

  4. subtracted form sysadmin


Correct Option: B

Sybase char_length equialent of SQL is

  1. length

  2. char_length

  3. char_len

  4. len


Correct Option: D

How to change <> null in sybase to SQL?

  1. is not null

  2. is null

  3. != null

  4. <> null


Correct Option: A

" in sybase is changed to ' in sql

  1. True

  2. False


Correct Option: A

exp1 LIKE exp2 in sybase is changed to

  1. exp1 like exp2

  2. exp1 like ltrim(exp2)

  3. exp1 like rtrim(exp2)

  4. ltrim(exp1) like exp2


Correct Option: C

*= operator belongs to SQL server 2008

  1. True

  2. False


Correct Option: B

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table?

  1. INSERT INTO employees VALUES (NULL, 'JOHN','Smith');

  2. INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');

  3. INSERT INTO employees VALUES ('1000','JOHN','NULL');

  4. INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');


Correct Option: C
  1. GRANT select, insert, update ON student_grades TO manager

  2. GRANT select, insert, update ON student_grades TO ROLE manager

  3. GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;

  4. GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;


Correct Option: D

The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR;

  1. You obtain the results retrieved from the public synonym HR created by the database administrator.

  2. You obtain the results retrieved from the HR table that belongs to your schema.

  3. You get an error message because you cannot retrieve from a table that has the same name as a public

  4. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to


Correct Option: B
  1. A view can be created as read only.

  2. A view cannot have an ORDER BY clause in the SELECT statement.

  3. A view cannot be created with a GROUP BY clause in the SELECT statement.

  4. A view must have aliases defined for the column names in the SELECT statement.


Correct Option: A
  1. SELECT last_name, 12*salary* commission_pct FROM emp;

  2. SELECT last_name, 12*salary* (commission_pct,0) FROM emp;

  3. SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;

  4. SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;


Correct Option: C
  1. SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;

  2. SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;

  3. SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;

  4. SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;


Correct Option: D
- Hide questions