Quizzes, Questions & Answers

Recent Quizzes

Are you familiar with PL/SQL in Oracle? Take this Oracle PL/SQL test and test your knowledge. If you learned Oracle, this quiz would be an easy one for you. We have got a set of questions for your practice and knowledge-testing...

Questions: 40 | Attempts: 4636 | Last updated: Aug 22, 2023

Sample Question
Examine this function: CREATE OR REPLACE FUNCTION CALC_PLAYER_AVG (V_ID in PLAYER_BAT_STAT.PLAYER_ID%TYPE) RETURN NUMBER IS V_AVG NUMBER; BEGIN SELECT HITS / AT_BATS INTO V_AVG FROM PLAYER_BAT_STAT WHERE PLAYER_ID = V_ID; RETURN (V_AVG); END; Which statement will successfully invoke this function in SQL *Plus?

SELECT CALC_PLAYER_AVG(PLAYER_ID) FROM PLAYER_BAT_STAT;

EXECUTE CALC_PLAYER_AVG(31);

CALC_PLAYER('RUTH');

CALC_PLAYER_AVG(31);

START CALC_PLAYER_AVG(31)

Test Your Database Skills

Explore the essentials of database search techniques with the 'Test Your Database Skills' quiz. Learn to formulate effective queries using logical operators like AND, OR, NOT, and wildcard characters to refine search results,...

Questions: 6 | Attempts: 1211 | Last updated: Mar 22, 2023

Sample Question
If you wanted to find research about either Australia or New Zealand which of the following search queries would be best?

Australia AND New Zealand

Australia OR New Zealand

Australia NOT New Zealand

Oracle Report Training! Trivia Quiz

This trivia quiz below is designed to test Your Knowledge about Oracle Report Training! Using the Oracle Database, you can input data into the system and freely generate a report based on the data. To see how well you understood...

Questions: 10 | Attempts: 366 | Last updated: Mar 21, 2023

Sample Question
You can filter a group of data in Data Model View?

True

False

SQL Course 1 70-431

This quiz assesses advanced skills in managing and querying databases using SQL Server 2005. It covers topics such as linked servers, protocol configurations, and optimization techniques, essential for database administrators and...

Questions: 19 | Attempts: 150 | Last updated: Aug 23, 2024

Sample Question
Your application must access data that is located on two SQL Server 2005 computers. One ofthese servers is named SQL1 and the other is SQL2. You have permissions to create a storedprocedure on SQL1 to support your application. However, on SQL2 you only have permissions to select data. You write the stored procedure on SQL1. The stored procedure accesses SQL2 byusing the OPENQUERY Transact-SQL statement. However, the query fails when executed. You need to troubleshoot the cause of the error. What should you do?

Join the two servers by using the four-part syntax of server.database.schema.table.

Reference SQL2 by using an alias.

Add SQL2 as a remote server to SQL1.

Add SQL2 as a linked server to SQL1.

Access Interrogation: MS Access Queries Quiz

MS Access has all that it takes to manage a whole database with its tools and features to face modern world data-related problems. Challenge yourself with scenarios that mimic real-world data challenges, from sorting and grouping...

Questions: 10 | Attempts: 1141 | Last updated: Jul 29, 2024

Sample Question
Give the correct expression operator - Numbers between 1 to 10.

Between 1 or 10

Between 1 to 10

Between 1 and 10

Between 1 - 10

Quiz Me SQL

Questions regarding sql server 2005. mainly from stored procedures, triggers and indexes.

Questions: 44 | Attempts: 883 | Last updated: Mar 22, 2023

Sample Question
Which of the following statemens are true?

Procedures and functions must return values

Procedures and functions may return value

Procedures may return values

Functions must return values

Grand Test SQL

The 'Grand Test SQL' quiz assesses knowledge of SQL queries in an Oracle environment, focusing on query syntax, data manipulation, and ANSI compliance. It tests practical skills essential for database management and IT roles.

Questions: 40 | Attempts: 1085 | Last updated: Mar 21, 2023

Sample Question
) You issue the following select statement in Oracle: SQL> select e.empno, e.ename, d.loc from emp e, dept d where e.deptno = d.deptno and substr(e.ename,1,1) = 'S';Which of the following statements identifies an ANSI-compliant equivalent statement usable on the Oracle database?

Select empno, ename, loc from emp join dept on emp.deptno = dept.deptno where substr(emp.ename,1,1) = 'S';

Select empno, ename, loc from emp, dept on emp.deptno = dept.deptno where substr(emp.ename,1,1) = 'S';

Select empno, ename, loc from emp join dept where emp.deptno = dept.deptno and substr(emp.ename,1,1) = 'S';

Select empno, ename, loc from emp join dept on emp.deptno = dept.deptno and substr(emp.ename,1,1) = 'S';

Test Your DDL And DML Knowledge

Are you an avid coder? We have a special Oracle quiz for you! Test your DDL and DML Knowledge with this super informative, interesting quiz! We are here to challenge your knowledge! Let's see how well you perform in this...

Questions: 10 | Attempts: 4097 | Last updated: Mar 13, 2024

Sample Question
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?

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

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

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

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

INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',");

Oracle_test6

Oracle_Test6

Oracle_Test6 assesses understanding of SQL queries in Oracle, focusing on data manipulation and query outcomes. Key skills include interpreting SQL syntax and functionality, as well as precision in data handling. Ideal for...

Questions: 20 | Attempts: 1543 | Last updated: Mar 20, 2023

Sample Question
You issue the following query: SELECT salary "Employee Salary" FROM employees; How will the column heading appear in the result?

EMPLOYEE SALARY

EMPLOYEE_SALARY

Employee Salary

Employee_salary

Oracle_test4

Oracle_test4 is designed to assess skills in SQL, focusing on functions, query syntax, and data manipulation. The quiz evaluates understanding of SELECT statements, ORDER BY clause, and string manipulation in SQL, essential for...

Questions: 15 | Attempts: 1329 | Last updated: Mar 22, 2023

Sample Question
Which SELECT statement will the result 'ello world' from the string 'Hello World'?

SELECT SUBSTR ('Hello',) FROM dual;

SELECT INITCAP (TRIM ('Hello World',1,1) FROM dual;

SELECT LOWER (SUBSTR ('Hello World',1,1) FROM dual;

SELECT LOWER (SUBSTR ('Hello World',2,1) FROM dual;

SELECT LOWER (TRIM ('H' FROM 'Hello World')) FROM dual;

« Previous 1...4 5 6 789 10 Next »