❖Communication practices: Principle 1 Listen: •Try to focus on the speaker‘s words, rather than formulating your response to those words. •Ask for clarification if something is unclear, but avoid constant interruptions. •Never become contentious in your words or actions (e.g., rolling your eyes or shaking your head) as a person is talking. Principle 2 Prepare before you communicate: •Spend the time to understand the problem before you meet with others. If necessary, perform some research to understand business domain. •If you have responsibility for conducting a meeting, prepare an agenda in advance of the meeting. Principle 3 someone should facilitate the activity: •Every communication meeting should have a leader (a facilitator) 1)To keep the conversation moving in a productive direction, 2)To mediate any conflict that does occur, and 3)To ensure that other principles are followed. Principle 4 Face-to-face communication is best: •It usually works better when some other represen...
DCL-Data Control Language And TCL -Transaction Control language
- Get link
- X
- Other Apps
DCL-Data Control Language
TCL -Transaction Control language
DCL-Data Control Language:-The data control language is use to give permition and revoke the permition, To perform any for operation in the database then user need permition like inserting data of reating record deleting data or view record. The record for In data control language there are mainly two command.
1.Greant command
2.Revoke command
1.Greant command:-The Greants command is use to given in the permission to user after that this user perform operation on database generally a grent statement is use by owner of table.
When we give permission to that user then this user must be present in the database.
Syntax-Grent permission on table name to user name.
There are various permission that is given below
2.Revoke command:-We can reject the permission given to database particulars user with the help revoke command.
Syntax-Revoke permission on table name from username.
To remove the permission from multiple users then we add user names seperated by","
- Get link
- X
- Other Apps
Popular posts from this blog
What is Relational structure, Table, Attributes, Rows Record, Domain, Super key, Composite key, Candidate key, Primary key, Foreign key
Table:- The table in a database has it unique name in the relational in table consisting Horizontal rows that is also called as Tuple s fore the Vertical columns also called as attributes. Each table row represent a single entity Occurrence withing the entity set. Attributes:- In the above table column represent data stored in it such column is called as attributes. Ex-Name id (column name) every cans a table must have at least one column. The squle standard does not be specify in in only maximum number of column in a table. Rows Record:- In a single row in a relational table which contain all information about. A single entity each horizantal row of student table represent the student record and in the and table there are multiple row. Domain:- The every column in a table has set of data values that are allowed for that column that is called as domain. In a relational table a domain can have a single value or null values .Type...
What is Computer engineering, complete information
Computer Engineering Computer Engineering is an engineering branch that is a combination of Computer Science and Electronics Engineering. Digital logic in design computer organization and architecture microprocessor in the system and interfacing computer networks and operating system. In this you learn the design, development and maintenance of both hardware (physical parts of the computer) and software (programs, applications, operating systems). 1.Scope of Computer Engineering . Computer Engineering students are taught these things: . Computer Hardware Design :-CPU circuit boards microcontrollers, embedded systems. ...
What is DDL --Data Definition language and DML -Data manipulation language
DDL --Data Definition language DML -Data manipulation language DDL --Data Definition language:- To create alter drop the table in or database we use data Definition language. The DDL command is used to built or modify the structure of a database or a object in that for the database object are any data that store and create in database For-tables, Rows and View 1.Create Command 2.Alter Command 3.Drop Command 4.Rename Command 1.Create Command:- To create database objects like table or modify database we used create command, The create statement is use to the create any types of objects. Syntax-Create table table name (column 1 data type (size), Column 2 datatype (size) ). Create table students (Id int , name varchar (255)); To view the create structure we use describe command " describe the table name. 2.Alter Command:- One there table or database create we required to change a structure of the database or class object we use into the alter comm...
Comments
Post a Comment