databases Online Quiz - 91 Online Test

0

databases Online Quiz - 91

Description: databases Online Quiz - 91
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

KCRT_REQUEST_DETAILS Request_type_id Request_id Batch_No Visible_parameter41 Visible_parameter31 --------------- ----------- --------- ------------------- ------------------- 1 31300 1 Online (null) 1 31300 2 Batch (null) 1 31300 3 Manually (null) 2 31301 1 2010-03-17 11:55:00 99 2 31301 2 2009-11-09 14:00:00 55 2 31301 3 2010-05-27 11:55:00 789 3 31302 1 TCS ACCM1 3 31302 2 INFOSYS BAPP1 3 31302 3 CTS IT1 KCRT_REQUEST_TYPES Request_Type_Id Request_Type_Name --------------- ----------------- 1 AXA_RT_Application_Demand 2 AXA_RT_Application_Definition 3 AXA_RT_Support_Release The statement that converts the Visible_parameter41 in the format ‘17/03/10’ for Request_id = 31301 for batch No ‘1’?

technology databases

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

KCRT_REQUEST_DETAILS Request_type_id Request_id Batch_No Visible_parameter41 Visible_parameter31 --------------- ----------- --------- ------------------- ------------------- 1 31300 1 Online (null) 1 31300 2 Batch (null) 1 31300 3 Manually (null) 2 31301 1 2010-03-17 11:55:00 99 2 31301 2 2009-11-09 14:00:00 55 2 31301 3 2010-05-27 11:55:00 789 3 31302 1 TCS ACCM1 3 31302 2 INFOSYS BAPP1 3 31302 3 CTS IT1 KCRT_REQUEST_TYPES Request_Type_Id Request_Type_Name --------------- ----------------- 1 AXA_RT_Application_Demand 2 AXA_RT_Application_Definition 3 AXA_RT_Support_Release Which is the best option to create a VIEW for visible_parametr41 for batch 3 along with the request_id?

technology databases

CREATE OR REPLACE VIEW PARAM41_VIEWAS Select request_id, visible_parameter41 from KCRT_REQUEST_DETAILS where batch_number = 3;
CREATE OR REPLACE VIEW PARAM1 VIEW AS Select request_id, visible_parameter41 from KCRT_REQUEST_DETAILS;
CREATE OR REPLACE VIEW AS Select request_id, visible_parameter41 from KCRT_REQUEST_DETAILS where batch_number = 3;
CREATE VIEW AS Select request_id, visible_parameter41 from KCRT_REQUEST_DETAILS where batch_number = 3;

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES ---------- EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES -------------- EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2(25) Which DELETE Statement is valid?

technology databases

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

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',' ');

technology databases

A, B, D
C, D, E
C, E, F
B, D, F

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;

technology databases

A
B
C
E

Which two statements about view are true? (Choose two) A. A view can be created as read only B. A view can be created as a join on two or more tables C. A view can not have an ORDER BY clause in the SELECT statement D. A view can not be created with a GROUP BY Clause in the SELECT statement E. A view must have aliases defined for the column names in the SELECT statement

technology databases

C, D
A, E
A, B
B, D

The "Leading" hint causes the optimizer to

technology databases

Use the specified table as the "Last" table in the join
Use the specified table as the "Log" table in the join
Use the specified table as the "Driving" table in the join
Use the query as the "First" query in the set.

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

technology databases

select * from utlxplan;
select * from plan_table;
select plan from plan_table;
select * from table(dbms_xplan.display);

Which of these are types of table partitioning?

technology databases

Index Partitioning
Range Partitioning
Rowid Partitioning
List Partitioning
Hash Partitioning
Composite Range Hash Partitioning

The "ENABLE ROW MOVEMENT"

technology databases

allows Logical Rowid's to remain independent of physical rowid's
allows rows to move across partitions
allows rows to be physically located in a different tablespace, while remaining tagged to a partition
allows rows to be copied to non-partitioned tables

Which are the 4 ways of partitioning an existing table?

technology databases

Online Redifinition method
Hybrid Method
Export/Import Method
Insert with a Subquery method
Dump Exchange Method
Partition Exchange method

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

technology databases

sp_how
sp_configure
sp_who2
sp_get_processinfo

What is the command to view/change SQL Server level paramaters/properties?

technology databases

sp_helpserver
sp_configure
sp_helpdb
sp_get_serverinfo

Which DMV is used to identify fragmentation of Indexes

technology databases

sys.dm_os_schedulers
sys.dm_exec_requests
sys.dm_db_index_physical_stats
sys.dm_db_index_usage_stats

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

technology databases

SQL Server Browser
SQL Server Integration Services
SQL Server Full-Text Search
SQL Server Agent

What are the 3 recovery models in SQL Server?

technology databases

Simple
Full
T-log
Bulk-Logged

What is the command to get information about the currently running query for a particular process?

technology databases

sp_who2
dbcc checkdb
dbcc inputbuffer(spid)
dbcc processinfo

On what default port does SQL Server run?

technology databases

1441
25
8000
1433

What are the different types of Replication?

technology databases

Transactional
Snapshot
Mirroring
Merge

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

technology databases

SQL Mail
Server Mail Utility
Database Mail
Mail Forms

- Hide questions