The SQL Quiz by 'The Cloud 9' assesses knowledge in SQL commands and concepts, focusing on operations like DELETE, understanding constraints, Oracle interfaces, and performance optimization. It's designed for learners to test and enhance their SQL skills effectively.
Unique
Primary key
Not null
Foreign key
Check
Rate this question:
1. Open Call Interface
2. Oracle Call Interface
3. Oracle Communication Interface
4. Oracle Connection Interface
Rate this question:
1. Indexes are only used in special cases
2. Indexes are used to make table storage more efficient
3. Indexes rarely make a difference in SQL performance
4. Indexes exist solely to improve query speed.
Rate this question:
1. RIS
2. CHA
3. ARRIS
4. ARR
Rate this question:
1. A DDL command and can be rolled back
2. A DML command and cannot be rolled back
3. A DDL command and cannot be rolled back.
4. A TCL command and can be rolled back
Rate this question:
1. SELECT last_name, department_name FROM employees , departments(+);
2. SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);
3. SELECT last_name, department_name FROM employees(+) e JOIN departments d ON (e.department_id = d.department_id);
4. SELECT last_name, department_name FROM employees(+) , departments ON (e.department_id = d.department_id);
Rate this question:
True
False
Bath correct
None
Rate this question:
1. MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'
2. UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'
3. UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
4. MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen
Rate this question:
GRANT select, insert, update ON student_grades TO manager;
GRANT select, insert, update ON student_grades TO ROLE manager;
GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;
GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;
GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;
Rate this question:
You obtain the results retrieved from the public synonym HR created by the database administrator.
You obtain the results retrieved from the HR table that belongs to your schema.
You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
Rate this question:
A view can be created as read only.
A view can be created as a join on two or more tables.
A view must have aliases defined for the column names in the SELECT statement.
A view cannot be created with a GROUP BY clause in the SELECT statement.
Rate this question:
SELECT dept_id, job_cat, MAX(salary) FROM employees WHERE salary > MAX(salary);
SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id, job_cat;
SELECT dept_id, job_cat, MAX(salary) FROM employees;
SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id;
Rate this question:
SELECT last_name, 12*salary* commission_pct FROM emp;
SELECT last_name, 12*salary* (commission_pct,0) FROM emp;
SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;
SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;
Rate this question:
ALTER TABLE table_name ENABLE constraint_name;
ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint_name;
ALTER TABLE table_name ENABLE CONSTRAINT constraint_name;
ALTER TABLE table_name STATUS ENABLE CONSTRAINT constraint_name;
ALTER TABLE table_name TURN ON CONSTRAINT constraint_name;
Rate this question:
SUM(start_date)
AVG(start_date)
COUNT(start_date)
AVG(start_date, end_date)
MIN(start_date)
MAXIMUM(start_date)
ALTER TABLE students ADD PRIMARY KEY student_id;
ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);
ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;
ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
Rate this question:
TIMESTAMP
INTERVAL MONTH TO DAY
INTERVAL DAY TO SECOND
INTERVAL YEAR TO MONTH
TIMESTAMP WITH DATABASE TIMEZONE
Rate this question:
Quiz Review Timeline (Updated): Mar 21, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Wait!
Here's an interesting quiz for you.