✕

Stuck or curious?

Ask the uCertify AI Tutor for instant help, hints, explanations or even practice questions—right inside this course.

Advance Search

  • All
  • *
  • Part 1
  • 1
  • 2
  • Part 2
  • 3
  • 4
  • Part 3
  • 5
  • 6
  • 7
  • 8
  • 9
  • Part 4
  • 10
  • 11
  • Part 5
  • 12
  • 13
  • Part 6
  • 14
  • 15
  • Part 7
  • 16
  • 17
  • Part 8
  • 18
  • 19
  • Part 9
  • 20
  • 21
  • 22
  • Part 10
  • 23
  • 24
  • 25
  • Part 11
  • 26
  • 27
  • 28
  • 29
  • Part 12
  • 30
  • *
  • *
  • *
Title
3.7.1 Understanding Physical Schema - ER Model
Unattempted
4.1.1 Understanding generalization
Unattempted
6.1.1 Creating a table
Unattempted
6.2.1 Using Referential Integrity constraints in a table
Unattempted
6.2.2 Using Check constraints in a table
Unattempted
6.3.1 Retrieving the data from the table
Unattempted
6.3.2 Using select-project-join query
Unattempted
6.3.3 Using alias-naming
Unattempted
6.3.4 Retrieving all the attribute values using asterisk
Unattempted
6.3.5 Retrieving the data using multiple condition
Unattempted
6.3.6 Specifying the cross product of the table
Unattempted
6.3.7 Using SELECT DISTINCT statement and UNION operator
Unattempted
6.3.8 Using substring pattern matching
Unattempted
6.3.9 Using arithmetic operators
Unattempted
6.3.10 Retrieving the sorted data using ORDER BY clause
Unattempted
6.4.1 Inserting values into a table
Unattempted
6.4.2 Inserting values into a table from existing table
Unattempted
6.4.3 Deleting the rows from a table
Unattempted
6.4.4 Updating the table
Unattempted
7.1.1 Retrieving values of a table using nested queries I
Unattempted
7.1.2 Retrieving values of a table using nested queries II
Unattempted
7.1.3 Retrieving values of a table using JOIN operator
Unattempted
7.1.4 Using Aggregate functions
Unattempted
7.1.5 Counting all the rows of a table
Unattempted
7.1.6 Using the GROUP BY and HAVING clauses
Unattempted
7.1.7 Using the CASE clause
Unattempted
7.2.1 Specifying general constraints as Assertions
Unattempted
7.3.1 Creating view
Unattempted
7.4.1 Modifying the table definition
Unattempted
8.1.1 Retrieving the distinct rows from the table
Unattempted
8.1.2 Using the UNION operator
Unattempted
8.1.3 Using the SELECT operator
Unattempted
8.2.1 Understanding relational set operator
Unattempted
12.1.1 Drag the object database concept to its description.
Unattempted
14.3.1 Normalizing the unnormalized model to 1st normal form I
Unattempted
14.3.2 Normalizing the unnormalized model to 1st normal form II
Unattempted
14.3.3 Normalizing the 1st normal form to 2nd normal form
Unattempted
14.3.4 Normalizing the 2nd normal form to 3rd normal form
Unattempted
14.4.1 Analyzing the normal forms
Unattempted
14.5.1 Normalizing the 3rd normal form to BCNF
Unattempted
15.1.1 Identifying inference rules
Unattempted
16.1.1 Understanding storage device types
Unattempted
16.2.1 Identifying the components of disk device
Unattempted
16.3.1 Understanding the buffer replacement strategies
Unattempted
16.5.2 Understanding program variables
Unattempted
16.11.1 Describing the hashing techniques
Unattempted
17.5.1 Creating a function-based index
Unattempted
17.5.2 Using a function-based index
Unattempted
18.1.1 Identifying the steps of processing a high-level query
Unattempted
18.1.2 Counting the number of department from the table
Unattempted
18.1.3 Using NOT IN operator
Unattempted
18.5.1 Using INTERSECT operator
Unattempted
19.1.1 Unnesting query
Unattempted
20.1.1 Understanding the page replacement method
Unattempted
20.2.1 Understanding the transaction states
Unattempted
21.1.1 Identifying deadlock dealing techniques
Unattempted
22.7.1 Creating a backup
Unattempted
23.1.1 Click to select the advantages of distributed databases.
Unattempted
24.1.1 Categorizing NOSQL systems
Unattempted
26.3.1 Classifying spatial operators
Unattempted
27.1.1 Identifying the features of databases and IR systems
Unattempted
27.3.1 Identifying types of queries
Unattempted
28.6.2 Understanding the applications of data mining
Unattempted
30.4.1 Identifying database attacks
Unattempted
3.7.1. Understanding Physical Schema - ER Model
Understanding Physical Schema - ER Model
Unattempted
4.1.1. Understanding generalization
Understanding generalization
Unattempted
6.1.1. Creating a table
Creating a table
Unattempted
6.2.1. Using Referential Integrity constraints in a table
Using Referential Integrity constraints in a table
Unattempted
6.2.2. Using Check constraints in a table
Using Check constraints in a table
Unattempted
6.3.1. Retrieving the data from the table
Retrieving the data from the table
Unattempted
6.3.2. Using select-project-join query
Using select-project-join query
Unattempted
6.3.3. Using alias-naming
Using alias-naming
Unattempted
6.3.4. Retrieving all the attribute values using asterisk
Retrieving all the attribute values using asterisk
Unattempted
6.3.5. Retrieving the data using multiple condition
Retrieving the data using multiple condition
Unattempted
6.3.6. Specifying the cross product of the table
Specifying the cross product of the table
Unattempted
6.3.7. Using SELECT DISTINCT statement and UNION operator
Using SELECT DISTINCT statement and UNION operator
Unattempted
6.3.8. Using substring pattern matching
Using substring pattern matching
Unattempted
6.3.9. Using arithmetic operators
Using arithmetic operators
Unattempted
6.3.10. Retrieving the sorted data using ORDER BY clause
Retrieving the sorted data using ORDER BY clause
Unattempted
6.4.1. Inserting values into a table
Inserting values into a table
Unattempted
6.4.2. Inserting values into a table from existing table
Inserting values into a table from existing table
Unattempted
6.4.3. Deleting the rows from a table
Deleting the rows from a table
Unattempted
6.4.4. Updating the table
Updating the table
Unattempted
7.1.1. Retrieving values of a table using nested queries I
Retrieving values of a table using nested queries I
Unattempted
7.1.2. Retrieving values of a table using nested queries II
Retrieving values of a table using nested queries II
Unattempted
7.1.3. Retrieving values of a table using JOIN operator
Retrieving values of a table using JOIN operator
Unattempted
7.1.4. Using Aggregate functions
Using Aggregate functions
Unattempted
7.1.5. Counting all the rows of a table
Counting all the rows of a table
Unattempted
7.1.6. Using the GROUP BY and HAVING clauses
Using the GROUP BY and HAVING clauses
Unattempted
7.1.7. Using the CASE clause
Using the CASE clause
Unattempted
7.2.1. Specifying general constraints as Assertions
Specifying general constraints as Assertions
Unattempted
7.3.1. Creating view
Creating view
Unattempted
7.4.1. Modifying the table definition
Modifying the table definition
Unattempted
8.1.1. Retrieving the distinct rows from the table
Retrieving the distinct rows from the table
Unattempted
8.1.2. Using the UNION operator
Using the UNION operator
Unattempted
8.1.3. Using the SELECT operator
Using the SELECT operator
Unattempted
8.2.1. Understanding relational set operator
Understanding relational set operator
Unattempted
12.1.1. Drag the object database concept to its description.
Drag the object database concept to its description.
Unattempted
14.3.1. Normalizing the unnormalized model to 1st normal form I
Normalizing the unnormalized model to 1st normal form I
Unattempted
14.3.2. Normalizing the unnormalized model to 1st normal form II
Normalizing the unnormalized model to 1st normal form II
Unattempted
14.3.3. Normalizing the 1st normal form to 2nd normal form
Normalizing the 1st normal form to 2nd normal form
Unattempted
14.3.4. Normalizing the 2nd normal form to 3rd normal form
Normalizing the 2nd normal form to 3rd normal form
Unattempted
14.4.1. Analyzing the normal forms
Analyzing the normal forms
Unattempted
14.5.1. Normalizing the 3rd normal form to BCNF
Normalizing the 3rd normal form to BCNF
Unattempted
15.1.1. Identifying inference rules
Identifying inference rules
Unattempted
16.1.1. Understanding storage device types
Understanding storage device types
Unattempted
16.2.1. Identifying the components of disk device
Identifying the components of disk device
Unattempted
16.3.1. Understanding the buffer replacement strategies
Understanding the buffer replacement strategies
Unattempted
16.5.2. Understanding program variables
Understanding program variables
Unattempted
16.11.1. Describing the hashing techniques
Describing the hashing techniques
Unattempted
17.5.1. Creating a function-based index
Creating a function-based index
Unattempted
17.5.2. Using a function-based index
Using a function-based index
Unattempted
18.1.1. Identifying the steps of processing a high-level query
Identifying the steps of processing a high-level query
Unattempted
18.1.2. Counting the number of department from the table
Counting the number of department from the table
Unattempted
18.1.3. Using NOT IN operator
Using NOT IN operator
Unattempted
18.5.1. Using INTERSECT operator
Using INTERSECT operator
Unattempted
19.1.1. Unnesting query
Unnesting query
Unattempted
20.1.1. Understanding the page replacement method
Understanding the page replacement method
Unattempted
20.2.1. Understanding the transaction states
Understanding the transaction states
Unattempted
21.1.1. Identifying deadlock dealing techniques
Identifying deadlock dealing techniques
Unattempted
22.7.1. Creating a backup
Creating a backup
Unattempted
23.1.1. Click to select the advantages of distributed databases.
Click to select the advantages of distributed databases.
Unattempted
24.1.1. Categorizing NOSQL systems
Categorizing NOSQL systems
Unattempted
26.3.1. Classifying spatial operators
Classifying spatial operators
Unattempted
27.1.1. Identifying the features of databases and IR systems
Identifying the features of databases and IR systems
Unattempted
27.3.1. Identifying types of queries
Identifying types of queries
Unattempted
28.6.2. Understanding the applications of data mining
Understanding the applications of data mining
Unattempted
30.4.1. Identifying database attacks
Identifying database attacks
Unattempted
Collecting data, please wait...
We use cookies to enhance your experience. By continuing to visit this site you agree to our use of cookies. More information
Accept