Certificate in Oracle SQL

/30
1

Certificate in Oracle SQL

1 / 30

Which of the following package procedure is UNRESTRICTED in Oracle?

2 / 30

Which of the following is not Constraint in SQL?

3 / 30

Which of the following database was designed first for enterprise grid computing?

4 / 30

Which of the following is not a Key in SQL Server?

5 / 30

Which of the following is not an advantage of a client/server model?

6 / 30

What is Oracle?

7 / 30

Which of the following is used to logically group data together?

8 / 30

Which of the following is not an Oracle Database feature?

9 / 30

The SQL statement

SELECT SUBSTR (‘123456789’, INSTR (‘abcabcabc’, ‘b’), 4) FROM DUAL;

10 / 30

command to use is command is used for removing a table and all its data from the database?

Create command

11 / 30

Which of the following is not a valid SQL type?

12 / 30

What command is used to create a new table in SQL?

13 / 30

What does the following statement in SQL do?

14 / 30

Which of the following is/are the DDL statements?

15 / 30

Which of the following commands are a part of Data Control Language?

16 / 30

POST-BLOCK trigger is a.

17 / 30

Which of the following is another name of Oracle database’s design?

18 / 30

Which of the following are types of Unicode character string types in SQL?

19 / 30

Which data manipulation command is used to combines the records from one or more tables?

20 / 30

Which schema object instructs Oracle to connect to remotely access an object of a database?

21 / 30

What does BLOB in SQL stand for?

22 / 30

SQL Views are also known as

23 / 30

A command that lets you change one or more field in a table is:

24 / 30

What does DLL stand for?

25 / 30

Which of the following is correct about Oracle?

26 / 30

Which of the following command is used to SELECT only one copy of each set of duplicable rows in SQL?

27 / 30

Which of the following commands is used to delete all rows and free up space from a table?

28 / 30

Which of the following is record based logical model?

29 / 30

Oracle server configuration is dedicated for

30 / 30

Which of the following is an advantage of Oracle database?