0

databases Online Quiz - 91

Description: databases Online Quiz - 91
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. SELECT to_char(visible_parameter41,’yyyy-mm-dd hh24:mi:ss’) from KCRT_REQUEST_DETAILS where request_id = 31301 and batch_number = ‘1’;

  2. SELECT to_date(visible_parameter41) from KCRT_REQUEST_DETAILS where request_id = 31301 and batch_number = ‘1’;

  3. SELECT to_date(visible_parameter41, ‘mm-dd-yyyy hh24:mi:ss’) from KCRT_REQUEST_DETAILS where request_id = 31301 and batch_number = ‘1’;

  4. SELECT to_date(visible_parameter41,’yyyy-mm-dd hh24:mi:ss’) from KCRT_REQUEST_DETAILS where request_id = 31301 and batch_number = ‘1’;


Correct Option: D
  1. Delete from employees where employee_id = (select employee_id from employees);

  2. Delete * from employees where employee_id = (select employee_id from new_employees);

  3. Delete from employees where employee_id in (select employee_id from new_employees where name = 'Carrey');

  4. Delete * from Employees where employee_id in (select employee_id from new_employees where last_name = 'Carrey');


Correct Option: C

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements insert a row in to the table? (Choose three). A - INSERT INTO employees VALUES (NULL, 'John', 'Smith'); B - INSERT INTO employees(first_name, last_name) VALUES ('John', 'Smith'); C - INSERT INTO employees VALUES ('1000', 'John', NULL); D - INSERT INTO employees(first_name, last_name, employee_id) VALUES ('1000', 'John', 'Smith'); E - INSERT INTO employees(employee_id) VALUES (1000); F - INSERT INTO employees(employee_id,first_name,last_name) VALUES (1000,'John',' ');

  1. A, B, D

  2. C, D, E

  3. C, E, F

  4. B, D, F


Correct Option: C

The Student_Grades table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar has asked for a report on the average grade point average (GPA), sorted from the highest grade point average to each semester, starting from the earliest date. Which statement will accomplish this? A. SELECT Student_id, semester_end, gpa from student_grades order by semester_end DESC, gpa DESC; B. SELECT Student_id, semester_end, gpa from student_grades order by semester_end, gpa ASC order by semester_end DESC, gpa DESC; C. SELECT Student_id, semester_end, gpa from student_grades order by semester_end DESC, gpa ASC; D. SELECT Student_id, semester_end, gpa from student_grades order by semester_end ASC, gpa ASC; E. SELECT Student_id, semester_end, gpa from student_grades order by semester_end DESC, gpa ASC;

  1. A

  2. B

  3. C

  4. E


Correct Option: D
  1. Use the specified table as the "Last" table in the join

  2. Use the specified table as the "Log" table in the join

  3. Use the specified table as the "Driving" table in the join

  4. Use the query as the "First" query in the set.


Correct Option: C

Which are the two ways of retrieving the execution plan for an SQL statement?

  1. select * from utlxplan;

  2. select * from plan_table;

  3. select plan from plan_table;

  4. select * from table(dbms_xplan.display);


Correct Option: B,D

Which of these are types of table partitioning?

  1. Index Partitioning

  2. Range Partitioning

  3. Rowid Partitioning

  4. List Partitioning

  5. Hash Partitioning

  6. Composite Range Hash Partitioning


Correct Option: B,D,E,F
  1. allows Logical Rowid's to remain independent of physical rowid's

  2. allows rows to move across partitions

  3. allows rows to be physically located in a different tablespace, while remaining tagged to a partition

  4. allows rows to be copied to non-partitioned tables


Correct Option: B
  1. Online Redifinition method

  2. Hybrid Method

  3. Export/Import Method

  4. Insert with a Subquery method

  5. Dump Exchange Method

  6. Partition Exchange method


Correct Option: A,C,D,F

What is the command to get information about the currently running processes in SQL Server?

  1. sp_how

  2. sp_configure

  3. sp_who2

  4. sp_get_processinfo


Correct Option: C
  1. sp_helpserver

  2. sp_configure

  3. sp_helpdb

  4. sp_get_serverinfo


Correct Option: B
  1. sys.dm_os_schedulers

  2. sys.dm_exec_requests

  3. sys.dm_db_index_physical_stats

  4. sys.dm_db_index_usage_stats


Correct Option: C

Which of the following SQL service is dependent of SQL Server service?

  1. SQL Server Browser

  2. SQL Server Integration Services

  3. SQL Server Full-Text Search

  4. SQL Server Agent


Correct Option: D

What are the 3 recovery models in SQL Server?

  1. Simple

  2. Full

  3. T-log

  4. Bulk-Logged


Correct Option: A,B,D

On what default port does SQL Server run?

  1. 1441

  2. 25

  3. 8000

  4. 1433


Correct Option: D
  1. Transactional

  2. Snapshot

  3. Mirroring

  4. Merge


Correct Option: A,B,D

What component of SQL Server is used to send emails in SQL Server 2005?

  1. SQL Mail

  2. Server Mail Utility

  3. Database Mail

  4. Mail Forms


Correct Option: C
- Hide questions