Quiz II

Quiz II

Time limit: 0

Quiz Summary

0 of 16 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 16 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

Current
Review
Answered
Correct
Incorrect

Question 1 of 16

1. Question
1 point(s)
What type of statement is used to manage grants and access in SQL?
- DDL
- DML
- DTL
- DCL
Question 2 of 16

2. Question
1 point(s)
Which of these is NOT an authentication method in Postgresql
- Kerberos
- trust
- md5
- password
Question 3 of 16

3. Question
1 point(s)
Which of these keywords is NOT used in DML statements
- SELECT
- INSERT
- CREATE
- DELETE
Question 4 of 16

4. Question
1 point(s)
A user role in postgres have which of the following attributes by default?
- login
- createrole
- replication
- createdb
Question 5 of 16

5. Question
1 point(s)
Which of the following is a good practice for managing access in your Postgresql server
- use the default super user
- create a new super user
- create a user with the createrole attribute
- create a role with login, createdb and createrole attributes
Question 6 of 16

6. Question
1 point(s)
What is a result set?
- A variable holding a set of values
- The output or result of a SQL Query
- a python variable whose data type is a set
- a collection of numbers
Question 7 of 16

7. Question
1 point(s)
JSON stands for ________
- Java Stream Object Normalization
- Juxtaposed SQL Open Notation
- Java Stream Object Notation
- Javascript Object Notation
Question 8 of 16

8. Question
1 point(s)
JSON is a python data type, True or False?
- True
- False
Question 9 of 16

9. Question
1 point(s)
JSON is to dictionaries as arrays are to __________
- classes
- Numbers
- lists
- strings
Question 10 of 16

10. Question
1 point(s)
A string is a mutable data type in python, True or False?
- True
- False
Question 11 of 16

11. Question
1 point(s)
Which of the following is true?
- list in python can only store elements of the same data type
- python only has 3 basic data types – Int, float, string
- the possible values of the boolean data type is True and False
- tuples in python are mutable
Question 12 of 16

12. Question
1 point(s)
The time complexity of a nested for loop is _________
- O(1)
- O(n)
- O(n^2)
- O(2n)
Question 13 of 16

13. Question
1 point(s)
The time complexity of looking up a key in a dictionary is ___________
- O(1)
- O(n)
- O(n^2)
- O(2n)
Question 14 of 16

14. Question
1 point(s)
A row is to a record as column is to a ____________
- key
- table
- entity
- field
Question 15 of 16

15. Question
1 point(s)
A window is a subset of a result set, uniquely identified by one or more columns, True or False?
- True
- False
Question 16 of 16

16. Question
1 point(s)
An entire result set can also be a valid window, True or False?
- True
- False

Scroll to Top

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?